NO! Semicolons are TERMINATORS not BEGINNINGATORS!

I read something about temp tables just a while back. I only vaguely remember the article, but I had thought about testing the premise about not dropping temp tables at...

Nothing like being in 3rd place with a 4-3 record.

I agree, but the problem is most of the developers I have worked with still only look at the database as a data store. Doesn't matter if it is MS...

Just yesterday, I had to troubleshoot an issue where CPU was pegged at 99%, and I determined the bottleneck to be a high volume query executed by the eCommerce...

Well, if you call this fnTally with a start value of zero (0), you get two zeros (0). You can eliminate:

SELECT N = 0 WHERE @StartN = 0 UNION ALL

from...

I would like the elusive 5th title...

I am ready. It is time for Fantasy Football!!!

I appreciate your help. You mentioned:

"The process which transforms your data should be kept separate from any scripts you use to build your database objects (tables, keys, foreign key...

I would do the normalization on paper first. That will give you a chance to see if you are going through the normalization process correctly without wasting effort in building...

Hello,

I need to create a script to create some database : 1 to 3. I wrote the script with a variable called @NB_APP This variable should be asked to...

This is just a...

This is how much I have paid attention to the alerts, prior to today, the last alert I received was way back on 2022-01-07. I just thought this thread was...

Now, if they would just fix the problem of NOT returning to the same page where you post a comment, that would be great.

And Jeff, yes, I got the notification.