2008-08-26 (first published: 2008-07-09)
842 reads
Scripts
Numero de Registros y espacio usado en disco
Generacion de numero de registros y espacio usado en disco todas las tablas de la base de datos
2008-08-22 (first published: 2008-06-24)
542 reads
sp_import_errorlog
To import the SQL Server error log into a table, so that it can be queried
Written by: Anand Mahendra Tested on: SQL Server 2000
2008-08-21 (first published: 2008-06-30)
813 reads
2008-08-20 (first published: 2008-06-19)
1,142 reads
2008-08-18 (first published: 2008-06-25)
1,749 reads
Case Cleanup Function
Capitalize the first letter of each new word in the string (clean, efficient, and easy to modify).
2008-08-14
341 reads
ChangeDateTpFirstOfNextMonth
Nothing fancy; just allows you to change a date the the first of the following month. Friend needed this so I thought I would post it here for other newbies.
2008-08-14 (first published: 2008-06-20)
557 reads
2008-08-13 (first published: 2008-06-17)
1,107 reads
How to get list of Stored Procedure
You can use following stored procedure with four optional input parameters to get a list of all stored procedures in the current environment.
2008-08-11
1,092 reads
2008-08-11 (first published: 2008-06-17)
896 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
Alamat BCA KCP Iskandar Muda Telp/Wa:0821-8200-233
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
BCA KCP Panglima Polim Raya Tlp:0821-8200-203
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Alamat BCA KCP Kota Kasablanka Tlp/Wa:0821-8200-174
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers