Nicholas Cain

Checking Your Database Fragmentation Level

Fragmentation in SQL Server is a huge debate. Does it matter? How much is too much? What should you do? In any case, new author Nicholas Cain has put together a system that allows him to keep track of the levels of fragmentation as well as defragment those tables when he feels they are getting too spread apart.

5 (1)

2005-11-18 (first published: )

33,819 reads

SQL Blocking and Blocked Proc + Notifi - Part2

Based on the script by Paul Delmarche ( http://www.sqlservercentral.com/scripts/contributions/1482.asp ).Updated to now include the spid, username, blocked and blocking SQL statements in the email (still logged to table).Schedule the procedure to run at defined intervals (I use 2 minutes)

5 (1)

2005-05-12 (first published: )

1,399 reads

Blogs

Azure SQL Training

By

I thought being an Azure Data/Database blogger I would share some amazing content from...

Managing virtual machine drives on ESXi

By

Recently I migrated my home lab from a SuperMicro SYS-E300-8D to something a little...

Thinking About the 2021 PASS Summit

By

I know that we don’t yet know how the 2020 Summit will turn out,...

Read the latest Blogs

Forums

Career advancement in cloud

By Aatish Patel

I am a SQL server administrator with 5 years of pure DBA experience. I...

Security for 2FA

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Security for 2FA

Basic Git for DBAs: What's a Pull Request?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Basic Git for DBAs: What's...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers