You shouldn't be trying to do an "INSTALL" of SQL Server.  It's been a long while since I've had to be the one to do the CU updates but, IIRC,...

It seems that you're still concentrating on waits... what have...

p.s.  And NO!!!  Rebuilding indexes at a lower Fill Factor is NOT A PANACEA especially on "ever-increasing indexes".  Just do it on the ones you did the Rebuilds on here...

Hi,

I have a Combined View which is fetching data from 2 underline views which in turn are referring to 2 tables.

I did an index rebuild on the underlined tables...

For a Windows shop, is there any practical benefit, like in terms of licensing costs or performance, for running SQL Server on a non-containerized Linux instance? For example, could...

How does just changing the delimiter from one character to another make anything easier?  The...

p.s.  Go look for Jonathan Keyhias' code for finding the longest and most prevalent compile times.  I once has a 100ms piece of code that ran a couple of tens...

I have a slightly different take on things... I call the top 10 wait types the "Top 10 symptoms that don't lead you to much" because they are just symptoms...

I must say, seeing Jeff Modan, Eric Russel, Joe Celko, people I have learned so much from, all chime in on the same thread... Well, it just brings a...

Thank God there's no GOSUB in SQL.

There's a school of thought that gets sniffy at overuse of if statements in OO languages.

Such constructs feel like a vestigal organ like...

thx for the quick replies..  My table has several thousand rows, so I cannot hard code dates as list in the example above.  This SQL gets me kind of...

No they weren't... at least...

@JeffModen,

Thanks for the detailed response. Agreed, could have made this example more performant following some of the guidance you mention.

Regarding why there is no index, the row set in...

I agree that you sometimes need to do the loop in one of it's many forms.  I have no qualms and fairly minor shivers from things like that. 😀

However... your...

Thanks for the feedback, Bruin...

Heh... you DO have to pay attention to the resolution of the data. 😀