Two simple commands that can be a big help in performance tuning.
The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are...
2014-09-02
2,600 reads
Kenneth Fisher
Generating a restore script
In order to speed up our backups on a large database our team decided to stripe the backup files. In...
2014-08-25 (first published: 2014-08-18)
7,527 reads
The amazing never shrinking heap
This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However...
2014-08-25
621 reads
Two years!
Two years ago today I began my blog with a post about the DEFAULT keyword. I set out with the...
2014-08-20
952 reads
More than sp_help
If you have worked with SQL Server for very long you have probably run across the extremely useful system function...
2014-08-14
1,513 reads
Deny vs Revoke
Quick quiz. Which of these two commands is the opposite of GRANT?
DENYREVOKE
Well lets start with some definitions
GRANT – Grants permissions on...
2014-08-12 (first published: 2014-08-04)
8,533 reads
T-SQL Tuesday #57: SQL Family
This month’s T-SQL Tuesday topic is SQL Family and is brought to us by Jeffrey Verheul (b/t). It’s an amazing...
2014-08-12
602 reads
The clustered index columns are in all of the non clustered indexes.
Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes...
2014-08-07 (first published: 2014-07-30)
9,434 reads
SchemaBinding – What & Why
What
When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying tables...
2014-08-06
1,128 reads
What is ANSI_NULLS and why will I be glad when it finally goes away?
Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and...
2014-08-04 (first published: 2014-07-28)
22,375 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers