Mechanism To Dynamically Build Pivot Table
Script to build PIVOT queries with an arbitrary number of columns
2018-10-25 (first published: 2018-10-15)
1,018 reads
Yet another way to defrag indexes
A script we use in our company, that rebuilds online=on by default, but takes care of special exceptions.
2016-07-28 (first published: 2014-06-06)
2,405 reads
2013-06-06 (first published: 2009-03-16)
2,660 reads
Generate a random password
If you ever need a quick way to generate random passwords, this is a pretty useful way to do so.
2013-05-15 (first published: 2008-09-24)
3,380 reads
My favorite way to access Excel files
Using opendatasource to retrieve data from Excel files as if querying a table.
2011-03-22 (first published: 2009-01-27)
11,906 reads
A quick way to find recently entered datetime entries in tables
Sometimes you need to scan a large number of datetime columns for most recent access.
2010-06-08 (first published: 2010-05-04)
1,874 reads
Deleting old files (with/without archive bit)
A hopefully useful script to delete old files, not just backups, and make use of the archive bit.
2009-01-01 (first published: 2008-12-09)
2,519 reads
Finding all data types in user tables
A quick way to get a snapshot of what data types are being used in all user tables.
2008-12-04 (first published: 2008-10-02)
1,134 reads
2008-11-06 (first published: 2008-09-12)
1,073 reads
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
668 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers