Nicholas Cain

Nicholas Cain started out as the overnight grunt at the now defunct MicroWarehouse 3 years ago. There he got his first introduction to SQL Server where he found an interest and a little aptitude thanks to the help of some great workmates. He now works as a DBA at T-Mobile USA.

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,822 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,401 reads

Blogs

PASS Summit 2020 Mental Health Presentation Eval Comments

By

I first starting presenting on mental health last December in Charlotte, NC on mental...

Daily Coping 1 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Power BI – Hungry Median – Aggregations

By

Introduction In my last blog post, I have addressed an issue with DAX Median...

Read the latest Blogs

Forums

SQL server service account lost permission on directories

By sqlfriend

I last week installed a SQl 2019 instance on a new server, applied the...

poor performance function

By Tomas Martin

Hello friends. This is my table "Cuentas" [IdCuenta] [int] IDENTITY(1,1) NOT NULL, [IdJerarquia] [int]...

Random Timeout Error

By tinyyyy

Hi, following a code release we have seen random timeout errors. I'm not sure...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers