Queries, Plans, and Indexes
Find indexes associated with queries and vice versa. Helps figure out what procedures are using indexes.
2008-11-18 (first published: 2008-07-31)
1,713 reads
Scripts
Backup And Restore Remain Time
Script to found out how much time before Restore or Backup Process remain
2008-11-17 (first published: 2008-09-30)
1,064 reads
Data extrapolation on the fly
Sometimes we need to generate the data based on a given date, to an end date (data extrapolation).
This is a easy way to do that without any temporary storage.
2008-11-14 (first published: 2008-09-25)
906 reads
Display SQL services information
This Script is used to display the SQL and windows services information
by using the Windows Management Instrumentation Command-line (WMIC),
2008-11-11 (first published: 2008-09-20)
1,385 reads
Yet Another Pad Utility
A useful user defined function for padding values from the left or right with any token, number, or character.
2008-11-07 (first published: 2008-09-13)
785 reads
2008-11-06 (first published: 2008-09-12)
1,025 reads
Get Record count of all tables of current database
This script will return record count of all user tables from the current database
2008-11-05
1,081 reads
Add Primary key
This Store procedure is used to add primary key to all tables in a database, if table does not contain it.
2008-11-04
986 reads
2008-11-04
1,956 reads
Delimited String Parsing Functions - TwoCol set
Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.
2008-11-03 (first published: 2008-08-05)
2,230 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 kantor BCA KCP Kutabumi Telp:082144477715
Wa:0821-4447-7715 Jl. Raya Kutabumi No.16-17 Blok B-18, Kutabumi, Kec. Ps. Kemis, Kabupaten Tangerang, Banten...
Alamat kantor BCA KCU GADING SERPONG Telp:082144477715
Wa:0821-4447-7715 Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster Scientia Garden No.001...
ALAMAT BCA KCU JOMBANG Telp:08218154393
WA:08218154393 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers