Show Database and Log sizes, free space and location
This script helps to identify which database/log takes most of the disk space and how much is free.
2015-04-15 (first published: 2013-06-18)
2,971 reads
Scripts
Automate Data Purity Investigation
Sometimes running DBCC CHECKDB WITH DATA_PURITY returns thousands of affected columns. This script automates the identification of those columns.
2015-04-13 (first published: 2013-07-04)
2,410 reads
Find Stored Procedures and Functions That Reference Certain Tables
Find any code objects that interact with a given table/view, or call another given code object.
2015-04-10 (first published: 2013-07-05)
4,608 reads
Parse XML to table
A stored procedure that will parse (shred) the contents of any well-formed XML document into a SQL table.
2015-04-08 (first published: 2013-07-09)
5,168 reads
Fastest way to find DB object dependencies
One of the fastest ways to find out objects dependencies in SQL Server.
2015-04-07 (first published: 2013-07-29)
3,282 reads
Check if SQL Server is running
This script will check if the SQL Server you are connected to is actually running.
2015-04-01 (first published: 2015-03-27)
1,749 reads
List Table Foreign Keys, Primary key and indexes
This procedure let you list [optional] by table:
-Foreign keys
-Primary key
-Indexes
2015-03-27 (first published: 2014-02-06)
4,002 reads
SP Send Query Result as HTML table using DBMail
Create a stored procedure that will send the result of a query as an html table from the database mail.
2015-03-26 (first published: 2014-02-14)
4,947 reads
2015-03-25 (first published: 2014-02-25)
7,923 reads
Calendar Table by Interval Minutes
Populate a calendar table with user set interval start and end datetime values.
2015-03-24 (first published: 2014-02-21)
2,397 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
how to stop command prompt window from appearing when running PowerShell script?
Hi everyone I have a PowerShell script that is run by Execute Process Task...
Computer Algebra
Comments posted to this topic are about the item Computer Algebra
Renaming a Database
Comments posted to this topic are about the item Renaming a Database
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers