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,262 reads
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,262 reads
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)
5,618 reads
A set of queries which attempt to gather as much security-related information on a server instance as possible.
2013-11-06 (first published: 2013-10-24)
3,115 reads
Loads temporary stored procs that assist in running and monitoring server-side tracing.
2012-03-12 (first published: 2012-02-21)
1,089 reads
By Steve Jones
This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...
Comments posted to this topic are about the item Does Version Control Scare You
Comments posted to this topic are about the item Unlimited Text
If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?
See possible answers