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,795 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

Life Support 2008 – Audit Logons

By

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...

All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT

By

This is the first in a series of posts about gatekeeping in Information Technology...

Read the latest Blogs

Forums

full text search

By Sailor

Trying to understand why when I search for numerics in full text, contains does...

New CVE-2019-1068 vulnerability - is there a patch for MSSQL 2012?

By Andy sql

MSSQL Server 2012 Service Pack 4 is officially supported until 2022-07-12: https://support.microsoft.com/en-us/lifecycle/search?alpha=sql%20server%202012 The new...

SSIS Package/Agent Job Not Failing!!!

By tim.ffitch 25252

I have a package running in SQL 2016 using Project Deployment. One of the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers