2016-08-23 (first published: 2015-05-01)
1,452 reads
2013-04-17 (first published: 2013-04-03)
1,452 reads
2013-03-19 (first published: 2013-03-01)
1,047 reads
Get Detach or Attach all user databases script
Script to generate script to detach or attach user databases
2013-02-15 (first published: 2013-01-29)
5,704 reads
Reorganize indexes for all tables in all user databases
Script to reorganize all indexes on all tables in user databases
2013-02-14 (first published: 2013-01-31)
3,250 reads
2013-02-06 (first published: 2012-12-27)
1,840 reads
Change database compatability level of all databases
Changes the database compatibility level of all databases to the given level.
2013-01-31 (first published: 2013-01-07)
927 reads
2012-12-03 (first published: 2012-11-07)
2,011 reads
2012-10-04 (first published: 2012-04-10)
2,012 reads
2012-07-25 (first published: 2012-07-12)
2,507 reads
Blogs
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
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...
Forums
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Economics of AI: What is the Real Cost to Profit?
Comments posted to this topic are about the item Economics of AI: What is...
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
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