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,817 reads

SQL Blocking and Blocked Proc + Notifi - Part2

Based on the script by Paul Delmarche ( ).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


An Updated Version of the Power BI Enterprise Deployment Whitepaper is Available


A new version of the Microsoft whitepaper “Planning a Power BI Enterprise Deployment” is...

What I learned from “The boy who cried wolf”


I was thinking about the story The boy who cried wolf earlier today and...

Automate deployment of Azure services with ARM Template


Automation is a useful thing. It allows to avoid many mistakes and saves a...

Read the latest Blogs


Is AG listener name being used in the to capture on the SQL side?

By Feivel

Due to the hurricane season around we have a requirement to have all the...

Just want record counts from two tables with 1:Many relationship

By jeffshelix

select count (H.Customs_Entry_Num) ,count(L.Customs_Entry_Num) FROM ADHOC.ATS_ESH H -- this table has only unique Entry...

Daily Coping 28 May 2020

By Steve Jones - SSC Editor

Today’s tip is to recall three things you’ve done that you are really proud...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers