2012-12-20 (first published: 2012-12-04)
1,723 reads
Scripts
Update Trigger to Store Only Updated Column and Former Value
History table needs individual rows for each column that has been updated, i.e., a column history.
2012-12-17 (first published: 2012-12-04)
1,187 reads
2012-12-14 (first published: 2012-11-27)
1,924 reads
Report Server Report Usage
Get information about how often, how fast your reports run and how big they are.
2012-12-12 (first published: 2012-11-27)
1,650 reads
Find Single use plans in Plan Cache
This script will return all the Adhoc Single use Plans currently in your Plan Cache.
It also excludes Plan Shells created from auto/forced parameterization. Works for 2005/2008
2012-12-11 (first published: 2012-11-26)
839 reads
2012-12-07 (first published: 2012-11-19)
1,391 reads
Get Scheduled Jobs from Multiple Servers
Script to loop thru multiple linked server and get agent scheduled jobs for the next XX hours.
2012-12-06 (first published: 2012-11-16)
924 reads
2012-12-03 (first published: 2012-11-07)
2,045 reads
2012-11-30 (first published: 2012-11-03)
1,102 reads
Print Text Month Calendar
This function return the text format of a month calendar. It could be useful for sending through emails when you do do not have other tools, but T-SQL to send text emails.
2012-11-29 (first published: 2012-10-31)
1,962 reads
Blogs
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...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Alamat BCA KCP Hasanudin Telp/Wa:0821-8200-203
WA Cs:62 8218200203 Jl. Sultan Hasanuddin Dalam No.43/48, RT.2/RW.1, Melawai, Kec. Kby. Baru, Kota...
Alamat BCA KCP Kemang Telp/Wa:0821-8200-174
Telp/Wa:62 8218200174 Jl. Kemang Sel. No.60, RT.4/RW.2, Bangka, Kec. Mampang Prpt., Kota Jakarta Selatan,...
Squared Values
Comments posted to this topic are about the item Squared Values
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers