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,139 reads
Security Queries: Database-level
A set of queries which attempt to gather as much security-related information on a single database as possible.
2015-10-30 (first published: 2013-10-24)
3,516 reads
Security Queries: Server-level
A set of queries which attempt to gather as much security-related information on a server instance as possible.
2013-11-05 (first published: 2013-10-24)
2,001 reads
Server-Side Trace Pack
Loads temporary stored procs that assist in running and monitoring server-side tracing.
2012-03-02 (first published: 2012-02-21)
1,042 reads
Blogs
The Microsoft Power Platform
By James-Serra
The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow....
From Evangelist to Advocate
It’s time for a little bit of change to occur. I am no longer...
Database File Changes
Data professionals around the globe are frequently finding themselves occupied with figuring out why...
Forums
Building a table based on another one(s)
Hi, We have 3 people that answer the phones to help our customer with...
Best way to find if string is whitespace
I appreciate it is a trifling question and yet. One of our sites organises...
How to measure Latency between App and database server
Hi All, We have SQL Server instance running on a VM. Now we wanted...
Ask SSC