Click here to Skip to main content
15,889,879 members

Bugs and Suggestions

   

General discussions, site bug reports and suggestions about the site.

For general questions check out the CodeProject FAQs. To report spam and abuse Head to the Spam and abuse watch. If you wish to report a bug privately, especially those related to security, please email webmaster@codeproject.com

 
GeneralRe: A suggestion Pin
Ümit BOSTANCI7-Dec-06 10:39
Ümit BOSTANCI7-Dec-06 10:39 
GeneralRe: A suggestion Pin
Chris Maunder7-Dec-06 11:04
cofounderChris Maunder7-Dec-06 11:04 
GeneralRe: A suggestion Pin
Shog97-Dec-06 12:23
sitebuilderShog97-Dec-06 12:23 
GeneralRe: A suggestion Pin
Michael P Butler7-Dec-06 10:45
Michael P Butler7-Dec-06 10:45 
GeneralRe: A suggestion Pin
Vasudevan Deepak Kumar7-Dec-06 22:08
Vasudevan Deepak Kumar7-Dec-06 22:08 
General[...Deleted...] Pin
James R. Twine9-Dec-06 2:33
James R. Twine9-Dec-06 2:33 
GeneralWhen threads get moved... Pin
Colin Angus Mackay7-Dec-06 5:23
Colin Angus Mackay7-Dec-06 5:23 
GeneralDedicated Database Section Pin
James R. Twine7-Dec-06 2:25
James R. Twine7-Dec-06 2:25 
   The more and more I work with SQL and databases, and the more developers I talk to (and the more I visit http://thedailywtf.com[^] :P), the more I notice a general lack of RDBMS fundamentals.

   I have seen some pretty gnarly SQL code and database design come from some otherwise talented and experienced developers.  To that end, I would like to recommend a article section specifically for non-code database articles.  For example, introductions to basic SQL syntax, how to code SQL queries, stored procedures, when to and not to index, basic table design, how joins work, subqueries, views, triggers, etc.  There are some SQL-specific articles that already exist on the site that can be moved there.

   I think that this would be a benefit for any developer that ever needs to write raw/ad-hoc SQL queries, stored procedures, or has to design a small schema, to make sure they have a better understanding of what is going on behind the scenes and are aware of any best practices that may apply.

   It would also raise the possibility of discussion (a new Database/RDBMS/SQL message board, perhaps?) regarding alternate/better approaches to certain problems.  For example, given a certain scenario, it is better to build a dynamic query using multiple values in an IN, or populate a temporary table and query against it?

   While having a DB message board might increase the risk of a non-developer audience, I think we could manage it.

   Thoughts?

   Peace!

-=- James
If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong!
Avoid driving a vehicle taller than you and remember that Professional Driver on Closed Course does not mean your Dumb Ass on a Public Road!
DeleteFXPFiles & CheckFavorites
(Please rate this post!)

GeneralRe: Dedicated Database Section Pin
Paul Conrad7-Dec-06 4:10
professionalPaul Conrad7-Dec-06 4:10 
GeneralRe: Dedicated Database Section Pin
James R. Twine7-Dec-06 6:41
James R. Twine7-Dec-06 6:41 
GeneralRe: Dedicated Database Section Pin
Paul Conrad7-Dec-06 7:39
professionalPaul Conrad7-Dec-06 7:39 
GeneralRe: Dedicated Database Section Pin
Pete O'Hanlon7-Dec-06 4:26
mvePete O'Hanlon7-Dec-06 4:26 
GeneralRe: Dedicated Database Section Pin
James R. Twine7-Dec-06 6:38
James R. Twine7-Dec-06 6:38 
GeneralOT Pin
J. Dunlap9-Dec-06 3:21
J. Dunlap9-Dec-06 3:21 
GeneralRe: OT Pin
Paul Conrad9-Dec-06 11:18
professionalPaul Conrad9-Dec-06 11:18 
GeneralUnable to view items in Purgatory Pin
Tarakeshwar Reddy6-Dec-06 0:42
professionalTarakeshwar Reddy6-Dec-06 0:42 
GeneralRe: Unable to view items in Purgatory Pin
Vasudevan Deepak Kumar6-Dec-06 1:06
Vasudevan Deepak Kumar6-Dec-06 1:06 
GeneralRe: Unable to view items in Purgatory Pin
Tarakeshwar Reddy6-Dec-06 1:49
professionalTarakeshwar Reddy6-Dec-06 1:49 
GeneralRe: Unable to view items in Purgatory Pin
Colin Angus Mackay6-Dec-06 1:42
Colin Angus Mackay6-Dec-06 1:42 
GeneralRe: Unable to view items in Purgatory Pin
Tarakeshwar Reddy6-Dec-06 1:49
professionalTarakeshwar Reddy6-Dec-06 1:49 
GeneralRe: Unable to view items in Purgatory Pin
Vasudevan Deepak Kumar6-Dec-06 21:52
Vasudevan Deepak Kumar6-Dec-06 21:52 
Generalprogramming questions in the lounge. Pin
V.6-Dec-06 0:36
professionalV.6-Dec-06 0:36 
GeneralRe: programming questions in the lounge. Pin
Vasudevan Deepak Kumar6-Dec-06 1:07
Vasudevan Deepak Kumar6-Dec-06 1:07 
GeneralRe: programming questions in the lounge. Pin
Amar Chaudhary7-Dec-06 15:10
Amar Chaudhary7-Dec-06 15:10 
GeneralPLEASE FIX THE SITE Pin
#realJSOP5-Dec-06 23:24
mve#realJSOP5-Dec-06 23:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.