2011-10-12 (first published: 2011-08-31)
946 reads
Scripts
2011-10-10 (first published: 2011-08-24)
834 reads
Get Modified Objects As on Date
This table Valued Function return the Modified Objects (SP /Views) For the Date specified.
2011-10-07 (first published: 2007-11-23)
1,388 reads
2011-10-06 (first published: 2007-11-14)
1,936 reads
Using sys.dm_exec_requests to estimate completion time for a process
The following script is used to check on the progress of a database restore, backup and other processes currently executing on SQL Server.
2011-10-05 (first published: 2011-09-09)
7,673 reads
Generating number sequences with Common Table Expressions
The script shows one of ways generating number sequence - this one uses CTE.
2011-10-04 (first published: 2008-02-06)
1,944 reads
Getting Age in Text or Date Difference in text format
This function returns the difference between the date in text format
2011-10-03 (first published: 2011-08-30)
1,035 reads
2011-10-03 (first published: 2008-03-27)
7,204 reads
Copy Multiple objects from One Schema to Another Schema
Copy Multiple objects from One Schema to Another Schema
2011-09-30 (first published: 2011-09-07)
1,550 reads
Function to Expand Tab Characters
A function to replace tab characters with the correct number of spaces to align the text as originally intended.
2011-09-29 (first published: 2007-10-11)
2,222 reads
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
ALAMAT KONTAK BCA KCP Morowali Telp:08218154393
WA:08218154393 Jl. Trans Sulawesi, Keurea, Kec. Bahodopi, Kabupaten Morowali, Sulawesi Tengah 94974
ALAMAT BCA KCP Bulukumba Telp:08218154393
WA:08218154393 Jl. Sam Ratulangi, Caile, Kec. Ujung Bulu, Kabupaten Bulukumba, Sulawesi Selatan 92517
Alamat kantor BCA KCU DAAN MOGOT Telp:082144477715
Wa:0821-4447-7715 Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers