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,259 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,259 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,541 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,075 reads
Loads temporary stored procs that assist in running and monitoring server-side tracing.
2012-03-12 (first published: 2012-02-21)
1,088 reads
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I'm using the below connection string using providing UserID and password on their respective...
Comments posted to this topic are about the item Knowing Your Total Reward