This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.
2011-04-18 (first published: 2008-10-01)
4,696 reads
Retrieve the charindex of matching string for the desired occurrence
2011-04-13 (first published: 2011-04-06)
1,508 reads
Uses sp_MsForEachDb, locates members in db_datareader with permissions other than Select and Connect.
2011-04-11 (first published: 2011-03-29)
1,093 reads
The script will be helpful to kill all the user sessions before performing the refresh of the database.
2011-04-08 (first published: 2011-03-29)
2,665 reads
converting a date from existing timezone to some different time zone covering multiple location
2011-04-05 (first published: 2011-03-24)
1,190 reads
2011-04-01 (first published: 2008-02-23)
3,812 reads
Third in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2011-03-30 (first published: 2009-02-16)
2,457 reads
Second in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2011-03-29 (first published: 2009-02-09)
2,542 reads
2011-03-28 (first published: 2009-02-06)
8,131 reads
This custom sp rebuilds \ reorganizes indexes for SQL 2005 databases and logs results for further analysis.
2011-03-25 (first published: 2009-02-16)
7,200 reads
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Comments posted to this topic are about the item How Can SQL Server Detect...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers