Are you properly closing your connections. If not then you may have too many open connections on the server and this will cause issues. Check sp_who and see how many...

The problem is DISTINCT is going to be across the entire output so more than one joke from the same user can be output because they are different jokes and...

Your going about it the best way you will find in SQL Server 7 and 2000 however if 2005 try PIVOT

see http://msdn2.microsoft.com/en-us/library/ms177410.aspx

Otherwise I would normally suggest it best to...

They do post to the data buffer so they do impact network and memory but it depends on how often, how many and how big they are as to whether...

Yeah it hurts and looking at the other threads there are obvious things they are missing that even an Oralce DBA already knows. I will admit a lot of the...

I have one question for you. What can you do with the order that shouldn't be allowed for an order to be created. Should be easy enough to see but...

But as a professional I do care if I am helping you get a job you cannot do. I am just aiding you at that point. As for helping you...

First off you asked if your code would work. The answer is possibly but most likely will not return your expected results.

For 1 the wildcard character for a LIKE in...

I think there a lot of people who got that lousy T-Shirt from this very type of situation. The problem is palin and simple office politics. Some people just do...

Great news for you guys and best of luck. Been so busy lately I was urprised I chose today to open the site and found this. Anyway I am sure...

Joe, I did some research back March/Apil 2006 and corresponded with two of the individual members of that ISO board. They informed me that their ISO was intended for Metadata only and not for database objects. However, they stated I...

To my knowledge you cannot except possibly by placing the user account in tempDB and explicitly denying create. However I have not got time to test this, this morning to...

Sorry, still a good contribution thou.

The issue isn't the use of <> or != (which I prefer the later). The pitfall is in presumption of the data and our understanding of the question.

The question being...

Just use QA and show the execution plan. I have seen Index Scans occurr in situations like this. However, it might even choose an index or table scan in TAB_C...