Viewing 15 posts - 1 through 15 (of 103 total)
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...
April 21, 2022 at 12:52 pm
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...
February 14, 2022 at 4:42 pm
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!
January 25, 2022 at 4:22 pm
.. Thank you for the fine feedback (although with only five letters in it, you could have spelled my name right :D) ...
Uhm .... I...
July 23, 2021 at 10:59 pm
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...
July 19, 2021 at 9:39 pm
... Then at Datamation magazine ran a gag article about the "come from" flow control structure as a replacement for the traditional "go to" flow control.
Seriously! COMEFROM... Have...
July 19, 2021 at 9:00 pm
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...
July 19, 2021 at 8:45 pm
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...
July 19, 2021 at 4:57 pm
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...
July 19, 2021 at 1:59 pm
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...
July 19, 2021 at 12:03 pm
I have SolarWinds DPA enable this trace flag on my SQL Server cluster.
This info is still valuable to this day.
Thank you.
July 16, 2021 at 9:36 pm
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...
April 28, 2021 at 9:15 pm
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...
April 28, 2021 at 7:46 pm
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...
April 28, 2021 at 5:30 pm
Viewing 15 posts - 1 through 15 (of 103 total)