This script displays all data files within a SQL Server database with the following relevant properties: FileName, FileLocation, FileSizeMB, SpaceUsedMB, AvailableSpaceMB, %FreeSpace, FileGrowthMB and FileGroupName
2013-11-11 (first published: 2013-10-29)
1,550 reads
I'm no big fan of dynamic SQL or cursors, however there are times where they do the job.
2013-11-08 (first published: 2013-10-29)
1,852 reads
This script converts a numeric column index to an Excel column name (ex: AC)
2013-11-07 (first published: 2013-10-23)
2,084 reads
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)
3,178 reads
This query gives you an idea of the growth of your database over time.
2013-11-01 (first published: 2008-03-10)
14,414 reads
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,592 reads
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,113 reads
This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.
2013-10-23 (first published: 2007-12-17)
19,866 reads
2013-10-22 (first published: 2007-10-10)
30,330 reads
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,030 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers