2008-09-11
1,523 reads
Scripts
2008-09-10 (first published: 2008-07-12)
1,508 reads
DB Connection Killer
This script opens a little cursor that will clean out connections to any DBs you specify.
2008-09-09 (first published: 2008-07-21)
1,520 reads
2008-09-09
1,072 reads
2008-09-08 (first published: 2008-07-20)
1,267 reads
Invalid SKU Error when Adding a Node to a SQL 2008 Cluster
When trying to add a node to an existing SQL Server 2008 cluster you get an Invalid SKU Error
2008-09-07
3,210 reads
2008-09-05
1,258 reads
Check Fragmentation on All Indexes on Database
In this script we create a temporal table and then review all indexes with next conditions.
avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 %
2008-09-05 (first published: 2008-07-10)
4,683 reads
generate save, delete, get, and list objects for a table
crates sp and function template for a table
2008-09-05
188 reads
2008-09-05 (first published: 2008-07-10)
2,683 reads
Blogs
Back in the EU
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
The Feedback Multiplier: How Leaders Can Turn Input into Innovation
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
SQL Saturday Boston Slides and Code
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
Forums
how to use a variable in a CASE statement?
hi everyone I am getting an error when I add a variable to a...
How to Use SQL Server Features to Cut Web App Latency in Half
Comments posted to this topic are about the item How to Use SQL Server...
Choosing an AI in Sept 2025
Comments posted to this topic are about the item Choosing an AI in Sept...
Question of the Day
The New SQL Server 2025 Data type
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers