2016-05-17 (first published: 2014-08-25)
2,588 reads
Scripts
2016-05-16 (first published: 2012-10-17)
5,583 reads
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,955 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,604 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,311 reads
Agent Job Schedule Description
Yet another schedule description query with added grammatical improvements.
2016-05-06 (first published: 2016-04-20)
874 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)
826 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,307 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,283 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)
646 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Anyone knows where to download SQLexpress edition for 2022
Where to download earlier version of SQL server express 2022? Thanks
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
SSL/TLS Cert Validity Periods Decreasing
Hi, to all of you who are using CA certs on SQL Server boxes...
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers