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,235 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)
4,646 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-06 (first published: 2013-10-24)
2,626 reads
Server-Side Trace Pack
Loads temporary stored procs that assist in running and monitoring server-side tracing.
2012-03-12 (first published: 2012-02-21)
1,063 reads
Blogs
Fixing a giant or running a SQL Server project deployment with Temporal tables
By Rayis Imayev
(2022-Jan-27) When Hogarth, a nine-year-old boy, a character from “The Iron Giant” movie, met a...
Azure Cosmos DB introduction
Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and...
Display dates between two input dates using SQL DATEDIFF function in SQL Server
SQL Server has a very useful function called DATEDIFF. This function is used to...
Forums
Create View in stored procedure
Hello, I'm new here and currently learn SQL Server. For my program I try...
Optimize Query
--####################################### --Given Rawdata --####################################### create table #Base (C1 char(1),C2 char(3)) insert into #Base values...
Static data masking is not showing in 18.0 above
I read this article trying to understand the feature of data masking in SQL...
Ask SSC