2013-10-22 (first published: 2007-10-10)
30,346 reads
Scripts
Function to format a datetime variable by a mask
I have used the following function to convert dates according to desired textual formats that were not immediately available in the standard styles on offer.
2013-10-18 (first published: 2013-10-01)
2,062 reads
Unique Identifier as Clustered index
This script selects clustered indexes containing only a uniqueidentifier column
2013-10-17 (first published: 2013-10-02)
1,251 reads
Find the size of all Indexes in a database
This script finds the size of all indexes in a database along with the table and the filegroup on which the index resides.
2013-10-15 (first published: 2013-09-23)
1,903 reads
Find Top 5 expensive Queries from a Write IO perspective
Top 5 expensive Queries from a Write IO perspective
2013-10-03 (first published: 2013-09-09)
2,394 reads
The Ultimate Index Lister (Non-Pivoted)
Lists details for all indexes on one or more tables / schemas, including row count and size. The non-pivot version also gives data type and other details for the columns.
2013-10-02 (first published: 2008-08-01)
3,761 reads
Find Top 5 expensive Queries from a Read IO perspective
The below written query helps us find the most expensive queries from a read IO perspective. The DMV that we have used in this script is sys.dm_exec_query_stats and the function that we have used is sys.dm_exec_sql_text.
2013-09-27 (first published: 2013-09-09)
2,670 reads
Determine if BACKUP COMPRESSION is available
This script will determine the SQL Server version and edition in order to find out if BACKUP COMPRESSION is available.
2013-09-25 (first published: 2013-09-10)
942 reads
Universal foreach aka sp_uforeach
This script is a universal foreach stored procedure. You can loop through everything with the help of if.
2013-09-24 (first published: 2013-09-10)
1,857 reads
Display Databases with X days without backup
Displays the information of the date of the latest backup that was done back to @daysago. When value is -0 it gives you all the backup information. The script also gives information on databases that never have been backed up.
2013-09-20 (first published: 2013-08-30)
1,605 reads
Blogs
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
Forums
Alamat Telp BCA KCP Telepon Kota +62 838-4945-0961
Wa:083849450961 Jl. Ps. Pagi Raya No.9, RT.2/RW.2, Roa Malaka, Kec. Tambora, Kota Jakarta Barat,...
Alamat Telp BCA KCP Semanggi +62 838-4945-0961
Wa:083849450961 Wisma GKBI, Jl. Jenderal Sudirman No.28 Suite G 01, RT.14/RW.1, Bend. Hilir, Kecamatan...
Alamat BCA KCP Rangkasbitung Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Sunan Kalijaga No.21, RT.2/RW.7, Muara Ciujung Bar., Kec. Rangkasbitung, Kabupaten Lebak,...
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers