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.

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

34,748 reads

Technical Article

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)

You rated this post out of 5. Change rating

2005-05-12 (first published: )

1,428 reads

Technical Article

Retrieve Index Information For All Tables - V2

This is an update to sp_helpindex, it allows you to pass the table name and whether you want to retrieve clustered, nonclustered or primary key indexes for a table. Using the sp_msforeach table will allow you to do this for all tables in a database. Inserting the data into a table will allow you to […]

You rated this post out of 5. Change rating

2004-03-04

1,007 reads

Technical Article

Retrieve Index Information For All Tables

This is an update to sp_helpindex, it allows you to pass the table name and whether you want to retrieve clustered, nonclustered or primary key indexes for a table. Using the sp_msforeach table will allow you to do this for all tables in a database. Inserting the data into a table will allow you to […]

You rated this post out of 5. Change rating

2004-03-01

1,277 reads

Blogs

Comparing Microsoft Fabric Alternatives in AWS, GCP, and OCI in 2025

By

Microsoft's unified analytics platform, Fabric, simplifies integration across various tools in Azure by offering...

Techno Security East: Quantum Computing Slides

By

I always try and ensure that I post my slides to my talks here...

A Basic Update Trigger: #SQLNewBlogger

By

I had someone ask me about using triggers to detect changes in their tables....

Read the latest Blogs

Forums

SSIS raw file conversion

By bokswager

Hi, Does anyone know how to handle a raw data file where some rows...

Force Strict Encryption - SQL Agent fails

By gustaw1234

Hi, On my SQL 2022 (16.0.4195.2) test environment, I tried to enable Force Strict...

Error converting data type varchar to float

By water490

Hi everyone I have a bunch of CSV files that I need to import...

Visit the forum

Question of the Day

How Many Nested Triggers?

I have DDL trigger code that I'm working on in SQL Server 2022, but I am concerned that we might end up with multiple triggers firing and the response to the user is delayed. If I want to check how many triggers have fired, or are nested, how can I do this in my code?

See possible answers