You do realize that's...

An updated answer to an old question is still a good thing.  Someone has already benefited from it.

You've posted in a 2005 forum.  What version of SQL Server do you actually have?

Grant and many others will seriously disagree with me but... My recommendation is that you don't spread your learning too thin.  I've found that a whole lot of what people...

I think the first step towards "vertical partitioning" is actually "proper normalization of a table".

I also think that people that have the following 3 columns (as identified in the Reddit...

Hi - I would like to decrease the performance of SQL for certain users or specific queries.

The majority of users will be running very quick queries that last less...

Brian hit a nail on the head that I totally forgot about and that's to be sure you include what he said about support, what's supported or not, and that...

I could be wrong but most of the code looks like it takes in some form of CSV and splits it.  Since you're using SQL Server 2019, lookup the STRING_SPLIT...

<li style="list-style-type: none;">

• Can you show the result of

  Restore HeaderOnly from url= ... ?

  ?

<li style="list-style-type: none;">

<li style="list-style-type: none;">

• Keep in mind you...

I'm not talking about ISNULL speeding anything up, Scott.  I'm talking about the use of a Clustered Index slowing things down.  I'll try to come up with an example other...

Write a section that identifies the purpose/problem this will solve. (Problem Overview)

Write a section on how the spreadsheets, etc, will solve the problems.  If you have additional advantages, such as...

That should do it, Mr. Williams.

Thanks for the feedback and pretty darned honest of...

Automating things has always been a key skill of good DBAs and, so far as I'm concerned, has absolutely nothing to do with "DevOps", which is becoming a more and...

Hi Jeff,

I was asked to pull this information because our cyber insurance company wants an approximation of the total number of rows across all SQL instances.  I imagine this...