Find all published tables with row counts and table size
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
3,551 reads
Scripts
2017-03-08 (first published: 2017-02-16)
2,045 reads
2017-03-07 (first published: 2017-03-01)
1,269 reads
Corrupt Page Notification
This trigger will send mail notification once a row is written in the suspect pages table
2017-03-03 (first published: 2017-02-21)
524 reads
Missing index with change impact percentage
This script will list all missing indexes with create statements.
2017-03-01 (first published: 2017-02-24)
1,354 reads
2017-02-28 (first published: 2015-06-22)
2,122 reads
Getting resource content from blocked process report
This script serves to display the content of the waiting resource. It is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCRL.
2017-02-27 (first published: 2017-02-21)
1,325 reads
Check if xp_cmdshell is turned on and flip the bit
The code works well for an automation process that needs to have xp_cmdhsell turned on.
2017-02-22 (first published: 2017-02-13)
1,632 reads
2017-01-31 (first published: 2017-01-30)
814 reads
2017-01-30 (first published: 2017-01-26)
19,722 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Kontak Bank BCA KCP Purwosari [083178278662]
Alamat BCA KCP Purwosari WHATSAPP:083178278662 Solo Center Point, Ruko No. A11 & A12, Sondakan,...
Alamat Bank BCA KCP Palur [083178278662]
WHATSAPP:083178278662 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers