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,179 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)
872 reads
Blogs
What the ???? T-SQL Tuesday #120
Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...
First Time Speaking at PASS Summit
By Bert Wagner
This week, I filmed my experience as a first time speaker at PASS Summit...
Azure SQL Best Practices?
By Arun Sirpal
A way to enforce good practice and standards is by Azure Policy. As stated...
Forums
Limiting the Data Frame
Comments posted to this topic are about the item Limiting the Data Frame
Micro Credentials
Comments posted to this topic are about the item Micro Credentials
CheckDB on VLDB, Geography data type
I've narrowed down a DBCC CheckDB issue to a set of tables with Geography...
Ask SSC