2012-07-18 (first published: 2008-01-25)
2,200 reads
Scripts
2012-07-17 (first published: 2007-11-21)
2,272 reads
Function to Split Multivalued Parameter
This Function is written to split Multivalued Parameter passed by Reporting Services 2005.
2012-07-16 (first published: 2007-08-01)
2,814 reads
2012-07-13 (first published: 2008-03-20)
2,230 reads
TopBlocker
Script to log top blocker processes in a database. Top blocker is defined as the process that is at the top of a blocking chain.
2012-07-12 (first published: 2007-10-30)
3,036 reads
Check Used Table Space for User Defined Tables
Query the System Tables to find the space usage, which helps Database Administrators identify the Tables that are using the most space.
2012-07-11 (first published: 2012-07-04)
1,274 reads
2012-07-06 (first published: 2012-06-29)
1,005 reads
2012-07-05 (first published: 2012-06-15)
952 reads
Remove comments from the SQL Code
Takes text (varchar(max)) as input and strips out any comments and RETURN the string. Comment is replaced by new-line character.
2012-07-04 (first published: 2009-03-25)
2,607 reads
2012-07-03 (first published: 2012-06-21)
1,385 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 Kantor BCA KCP Talavera Telp/Wa:0821-8200-233
CSO 08218200233 Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec....
Alamat BCA KCP Mega Kuningan Telp/Wa:0821-8200-203
CSO 08218200203 Lingkar Mega Kuningan No.Blok E 4, RT.5/RW.2, Kuningan, Kuningan Tim., Kecamatan Setiabudi,...
Alamat BCA KCP Wisma Mulia Telp/Wa:0821-8200-174
CSO 08218200174 Jl. Gatot Subroto No.42 Suite G02, RT.3/RW.2, Kuningan Bar., Kec. Mampang Prpt.,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers