Get Set For Speed
Loops are common in application code, but set-based solutions are the way to go with SQL.
2018-02-23 (first published: 2015-12-29)
6,285 reads
Tom Staab
Temporary exclusive database access
This simple script disconnects any other session that is connected to the specified database by temporarily switching the database to single user.
2015-11-20 (first published: 2015-10-25)
905 reads
Blogs
Announcing a New Book on SQL from 3Cloud Authors
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Identify the (Top 20) most expensive queries across your SQL Server using Query Store
Script to identify the most expensive queries on your database server using the Query...
Setting Up Always Encrypted
In this post we're going to go through the steps to set up Always...
Forums
TOP with Order By alternative, performance results look mixed
Hi I have a situation where I am testing two versions of the same...
Upgrading an Always on Availability Group two node from SQLServer 2016 to 2019
I'm looking for best practice here and these are Azure VMs by the way....
Azure availability groups requirements question
Does anyone know if Azure absolutely requires windows clustered services to support availability groups?...
Ask SSC