What’s in a partition?
In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit...
2017-05-22
506 reads
In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit...
2017-05-22
506 reads
tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add...
2017-05-17 (first published: 2017-05-03)
2,061 reads
I was looking around for something to write about this evening and came across one of Russ Thomas’ (b/t) old...
2017-05-17
2,865 reads
TL;DR: It’s pretty pointless and can cause performance issues.
Let’s start by asking why you might want to shrink your log....
2017-05-15
480 reads
Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over...
2017-05-12 (first published: 2017-05-01)
2,274 reads
I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even...
2017-05-11
599 reads
It’s T-SQL Tuesday again! This month we are being hosted by James Anderson (b/t). Thanks James! He has asked us...
2017-05-09
417 reads
I had this question come up at work the other day and while I knew it was true I wasn’t...
2017-05-08 (first published: 2017-04-26)
3,753 reads
When you right click on a tab you’ll see a number of different options. You can set up new horizontal...
2017-04-24
382 reads
We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we...
2017-04-21 (first published: 2017-04-19)
2,860 reads
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers