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

Blogs

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

This Saturday: #DataWeekender, DataSaturday Southwest

By

Geeked to be speaking 2x on Saturday May 14, my second time speaking at...

Daily Coping 14 May 2021

By

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

Read the latest Blogs

Forums

Incorrect syntax near the keyword 'AS'

By basmster

Hi Everyone. I'm hoping someone can take a look at my code here to...

What counts for a DBA: Foresight

By Louis Davidson (@drsql)

Comments posted to this topic are about the item What counts for a DBA:...

SSRS report server installation

By sqlfriend

If we want to install SQL server SSRS service on another server separating  it...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Container Logs

See possible answers