2008-09-30 (first published: 2008-07-24)
876 reads
Scripts
Getting schemas for your tables
A short script you can incorporate into any 2005/2008 code to get the full schema.table.
2008-09-29
654 reads
Script to return Rows count from table using sp_ExecuteSQL
Script to return Rows count from table using sp_ExecuteSQL
2008-09-26 (first published: 2008-07-20)
1,526 reads
Using Triggers for Detective Work
When a value is changed that causes an error, finding what caused the error can be tricky. Here an application was truncating a column. The trigger helped to identify the culprit.
2008-09-25 (first published: 2008-07-17)
1,394 reads
Checking fragmented indexes
A quick script to check for fragmentation in a database and generate a list of defrag statments you can run.
2008-09-24
2,465 reads
2008-09-19 (first published: 2008-07-20)
1,479 reads
2008-09-18 (first published: 2008-07-15)
699 reads
2008-09-16
329 reads
Create string from table
This simple script retrieves a range of values from a table and presents the results as a string.
2008-09-15 (first published: 2008-07-16)
1,608 reads
Get DBMail information
get the profile name and the account name etc about the dbmails created on the server
2008-09-12 (first published: 2008-07-13)
992 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