Code Comparison between two databases
This script compares the code (SP, Func. etc.) between two databases (say Dev and QA) and reports the objects which have differences.
2009-02-26 (first published: 2007-03-08)
631 reads
Scripts
TEXT/NTEXT Find and Replace
Find And Replace any string, in the entire table with this function. Parameterized for easy use.
2009-02-26 (first published: 2009-02-09)
895 reads
Default Trace Load of All 5 Files
The default trace keeps the last 20 meg of info, and a max of 5 files...This loads all 5 files into a table so it can be reviewed.
2009-02-25 (first published: 2009-02-07)
1,256 reads
2009-02-16 (first published: 2009-02-03)
2,636 reads
2009-02-05 (first published: 2008-05-20)
2,223 reads
Two scripts to spell out numbers in words
These SQL functions will allow you to convert decimal numbers to words
2009-02-02 (first published: 2009-01-22)
2,002 reads
Growth remaining for SQL Server 2005 databases
This script is little bit similar to the one posted for SQL Server 2000 that finds how much space you have left.
2009-01-30 (first published: 2009-01-19)
948 reads
2009-01-26 (first published: 2009-01-08)
941 reads
2009-01-23 (first published: 2009-01-14)
2,015 reads
View - Table Usage (Recursive)
Written to explore the table dependencies of a view, especially when the view queries other views.
2009-01-22 (first published: 2009-01-11)
1,252 reads
Blogs
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
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...
Forums
ALAMAT KONTAK BCA KCP Pecatu Telp:08218154393
WA:08218154393 nomor 275 Blok 4, Jl. Raya Uluwatu dan 5 No.99, Ungasan, Kec. Kuta...
ALAMAT KONTAK BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
ALAMAT KONTAK BCA KCP Benoa Telp:08218154393
WA:08218154393 Jl. Suwung Batan Kendal No.2, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80222
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers