2010-08-27 (first published: 2010-08-25)
3,664 reads
Scripts
Get daylight savings time
After scouring the site, and googling until my fingers bled, I finally put together a function that will return the dates when daylight savings time began/ended since at least 1990.
2010-08-26 (first published: 2010-08-19)
1,976 reads
Reset Identity Seeds
Resets the identity seeds for all user tables to one plus the current maximum value of the identity field. Revised 24 August 2010.
2010-08-25 (first published: 2006-07-06)
375 reads
Object Explore
Summary information and metrics for any column in a given Table/View. Metrics include: number of records, distinct records, nulls, min, max, std, quartiles, kurtosis, skew, etc.
2010-08-24
43 reads
Using GO Repeat To Fill Tally Table
Fill a small Tally table with a 1 column primary key using GO keyword to repeat an insert.
2010-08-18 (first published: 2010-08-16)
1,543 reads
2010-08-16 (first published: 2010-03-05)
3,819 reads
Enterprise wide Backup Audit
Enterprise wide Backup Audit that produces backup information in a csv format.
2010-08-06 (first published: 2009-11-10)
1,838 reads
2010-08-05 (first published: 2009-11-25)
7,186 reads
Find botched constraints, idxs, fks
Shows awesome view of columns with constraints and indexes and foreign keys to spot errors fast.
2010-08-04 (first published: 2009-12-03)
1,460 reads
2010-07-27 (first published: 2010-07-09)
2,163 reads
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers