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.

And in other news....I have taken the plunge. After almost 25 years as a developer I have just accepted a new position as a full time DBA. Even more...

Hope noone minds but I'll pop in now to say I will try again next year. Plus, this makes sure I see future posts to this thread.

Have you tried setting the correct settings and then create the filtered index, or is it failing because the underlying table has the wrong settings?