Posted inSQL Server
Backup History
If you want to see more than just when the last backup occurred. Here is a script for backup history with two bonus features. Backup compression ratio - CompressionRatio Backup…
Posted inBlog Powershell SQL Server
SQL Server and PowerShell (SQLPS) Starter
The following two snippets of code are two ways to achieve the same outcome, which is the $Server object containing the default instance. Or when opening a SQL PS (Powershell)…
Posted inSQL Server
Using the default system_health Extended Event
The default extended event system_health appeared in SQL 2008 and provides several key monitors, which can prove useful when investigating issues. In the past I have mentioned this in the…
Posted inSQL Server
Creating a Deadlock
Previously we have looked at how to capture a deadlock, but how do we go about creating a deadlock? I think the following is the simplest method: 1. Create two…
Posted inSQL Server
Most Recent SQL Query
Here is another query that is useful to have when you need to find out what everyone is up to. Or in some cases when we need to recover what…
Posted inSQL Server
SQL Index dm_db_index_xxx_stats
There are 3 dm_db_index_xxx_stats objects that can be used to check and investigate index information. sys.dm_db_index_usage_stats can be used to see how beneficial the index is, and its related maintenance…
Posted inSQL Server
Simple Table and Index Breakdown With Buffered
This script builds on the Simple Table and Index script to further show the buffered metrics. This script will give you a simple breakdown of your tables and indexes, which…
Posted inSQL Server
Detailed Table Index Breakdown With Buffered
This script builds on the Detailed Table and Index script to further show the buffered metrics. This script will give you a comprehensive breakdown of your tables and indexes, which…
Posted inPowershell SQL Server
Quick data wipe via truncate
"How to remove all data from a database?" is something that I have often seen asked on the forums. How do you remove all the data quickly? First you try…
Posted inSQL Server
Leap Year
A leap year can be calculated using a formula (Please see Microsoft article), however there is no real need to calculate it this way. All that is needed in sql…