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

Blogs

Top 10 Must-Ask Questions Before Going to the Cloud

By

After architecting and migrating some of the world’s largest data platforms, Let’s walk through my top...

Markdown Links– Remembering the Basics

By

For some reason, I can never remember how to do markdown links. I know...

Why Aren’t You Automating Database Deployments?

By

Building out processes and mechanisms for automated code deployments and testing can be quite...

Read the latest Blogs

Forums

B? túi bí quy?t ki?m ti?n t? Forex

By duyen96dn

th? tru?ng ngo?i h?i Forex là m?nh d?t d?u tu m? màu giúp các...

Run Azure Automation Runbook Against DB Hosted on an Azure VM

By dan-404057

Hi - has anyone created a PowerShell runbook which connects to a database hosted...

The Compression Type

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Compression Type

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers