2016-05-16 (first published: 2012-10-17)
5,578 reads
Scripts
Compare two tables for structure and layout
Compare the structure/layout of two tables within an instance of SQL Server (version 2012) and return non-matches.
2016-05-13 (first published: 2014-04-23)
2,950 reads
Aggregrating varchar columns
Concatenate columns grouping on Index column (approach for summing varchar columns by grouping on index)
2016-05-12 (first published: 2009-09-13)
1,591 reads
sp_spaceused rewritten as one query (no cursors)
Query that simulates running sp_spaceused on every applicable object in a database and gathering it all into a single result set.
2016-05-10 (first published: 2013-06-03)
2,294 reads
Agent Job Schedule Description
Yet another schedule description query with added grammatical improvements.
2016-05-06 (first published: 2016-04-20)
869 reads
Get Space on SQL hardrive
I was recently asked to monitor the Database size on the SQL server, and display the results in a report.
2016-05-05 (first published: 2016-04-16)
818 reads
DBCC CHECKDB to a table
An enhanced version of a script originally posted by Robert Pearl some time ago. It now takes into account changes in the tabelresults for CHECKDB in latter versions of SQL Server.
2016-05-04 (first published: 2016-04-20)
1,297 reads
Brute Force data search tool
searches entire db for a string, number, or date, returns list of results
2016-05-02 (first published: 2016-04-20)
1,275 reads
SQL server Agent - Status
As part of the application to monitor SQL health I created.
The procedure returns status of the SQL server Agent
2016-04-29 (first published: 2016-04-16)
639 reads
2016-04-28 (first published: 2016-04-07)
525 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Alamat BCA KCP Pasar Telp:08218200203
WA CS 628218200203 Komp. Cipulir Permai, E Jl. Ciledug Raya No.9, RT.9/RW.5, Ulujami, Kec....
Alamat BCA KCP Manhattan Telp/Wa:0821-8200-203
Hub CS 08218200203 The Manhattan Square, Mid. Tower, Lt. Ground Unit A & Lt....
Alamat BCA KCP Mal Pondok Indah Telp:0821-8200-203
Telp/Wa 62 8218200203 Ground Floor G31 & G32, Jl. Metro Pondok Indah, RT.1/RW.16, Pd....
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers