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)
3,162 reads
Scripts
An easy way to track the growth of your database
This query gives you an idea of the growth of your database over time.
2013-11-01 (first published: 2008-03-10)
14,386 reads
Performance Testing Script
Fourth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2013-10-31 (first published: 2009-02-17)
10,582 reads
PivotByDate clr stored procedure
This script pivots 1 to N numeric columns, grouping by 1 to N (N)(Var)char columns, pivoting by distinct date.
2013-10-30 (first published: 2013-10-15)
1,099 reads
Get record count for a specific database
This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.
2013-10-23 (first published: 2007-12-17)
19,853 reads
2013-10-22 (first published: 2007-10-10)
30,315 reads
Function to format a datetime variable by a mask
I have used the following function to convert dates according to desired textual formats that were not immediately available in the standard styles on offer.
2013-10-18 (first published: 2013-10-01)
2,012 reads
Unique Identifier as Clustered index
This script selects clustered indexes containing only a uniqueidentifier column
2013-10-17 (first published: 2013-10-02)
1,223 reads
Find the size of all Indexes in a database
This script finds the size of all indexes in a database along with the table and the filegroup on which the index resides.
2013-10-15 (first published: 2013-09-23)
1,878 reads
Find Top 5 expensive Queries from a Write IO perspective
Top 5 expensive Queries from a Write IO perspective
2013-10-03 (first published: 2013-09-09)
2,370 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers