dbatools.io is the main reason I jump into PoSh when interacting with SQL Server. Just so much value there. On the other hand, if a fancy crafted SQL is required...

Thank you for the great intro article to ADS!

Would like to point out that per Microsoft, "There are two SQL Server PowerShell modules; SqlServer and SQLPS. The SqlServer module is...

Such workarounds are absolutely stupid.  Not because the workaround itself is stupid but, rather, because Microsoft has made such a workaround NECESSARY. .......

F@#$%NG EPIC!

<comment removed>

Uhm .... I...

OMG, David Poole chimes in too. I can't stop crying. I feel so small.

Thank God there's no GOSUB in SQL.

There's a school of thought that gets sniffy at overuse...

Seriously! COMEFROM... Have...

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

• This reply was modified 3 years, 8 months ago by  qbrt.
• This reply was modified 3 years, 8 months ago by  qbrt.

A go to statement can jump into the middle of a begin – end block. This means that all of those local variables have to be allocated beginning of...

I do not wish to get into the pros/cons of GoTo as a quick google search will return a ton of good content. And since you mentioned "not overused" makes...

Ack...GOTO.

Didn't the world teach everyone how evil GOTO is and never to use it in higher level languages? It's evolution. Let's not evolve backwards.

I understand it's an...

I have SolarWinds DPA enable this trace flag on my SQL Server cluster.

This info is still valuable to this day.

Thank you.

As a bit of a sidebar and especially since the partitioning is done on a temporal column, consider a strategy like 1 filegroup with 1 file per quarter and...

Very good question, Jeff. Thanks for asking. And you're spot on.

These tables are part of a data warehouse solution and their sole purpose is to store all the data that...

So, stopped being lazy for five minutes, and tested this myself. Indeed, the partition scheme is used to insert new records into such a heap table. Clustered index is not...