Monitor database growth - a better way for sp_spaceused
A better way to use sp_spaceused, returning values on one row for the database instead of two.
2008-09-04
4,052 reads
Scripts
Quick and dirty way to make a very large table
A script that can generate a massive amount of data relatively quickly
2008-09-04 (first published: 2008-07-11)
1,322 reads
2008-09-03
216 reads
Import/Export SQL Server 2000 Enterprise Manager Registered Servers
Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.
2008-08-27 (first published: 2008-02-15)
2,602 reads
2008-08-27
1,024 reads
2008-08-27 (first published: 2008-07-03)
2,178 reads
sp_import_errorlog
To import the SQL Server error log into a table, so that it can be queried
Written by: Anand Mahendra Tested on: SQL Server 2000
2008-08-21 (first published: 2008-06-30)
774 reads
2008-08-20 (first published: 2008-06-19)
1,125 reads
2008-08-18 (first published: 2008-06-25)
1,739 reads
Case Cleanup Function
Capitalize the first letter of each new word in the string (clean, efficient, and easy to modify).
2008-08-14
329 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