Parameterization Part 4: Handling Non-Uniform Data Distribution
This is the fourth post in the “Parameterization” series. In the previous post I wrote about parameter sniffing, and I...
2014-09-11 (first published: 2014-09-08)
7,152 reads
This is the fourth post in the “Parameterization” series. In the previous post I wrote about parameter sniffing, and I...
2014-09-11 (first published: 2014-09-08)
7,152 reads
A short post today to pass on a script I wrote to fulfil a requirement I had.
Which indexes are on...
2014-09-07
549 reads
I spent the last couple days at Flowcon 2014, a conference that is bringing people together to talk about growing...
2014-09-05
791 reads
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-09-05
743 reads
Lately I spent some time evaluating some monitoring tools for SQL Server and one thing that struck me very negatively...
2014-09-05
476 reads
This month I’m very grateful because I was given the opportunity to present at DevLink in Chattanooga. I got to...
2014-09-05
534 reads
Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files....
2014-09-09 (first published: 2014-09-05)
7,454 reads
Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files....
2014-09-05
648 reads
I wrote Titles Matter – Part 2 based on lessons learned the hard way not long ago. Titles matter because they...
2014-09-05
526 reads
A couple of days ago, when I was in Germany – I have received some extremely exciting news that I was...
2014-09-05
141 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers