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

Blogs

Daily Coping 21 Sep 2021

By

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

#PowershellBasics: Bulk insert.

By

In my last post I talked about invoke-sqlcmd. It’s a nice easy way to...

Lambda Architecture in data systems and possible meaning of this name

By

(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...

Read the latest Blogs

Forums

Difference between SaaS and web application?

By milowbrac

I'm currently interested in self-hosting and I recognized that mostly it's about alternatives for...

Reducing Temp Table Scans when joining two temp tables using OR conditions

By scarr030

Hi all. I have also posted this on DBA Stack Exchange, but I'm posting...

question about username dbo

By cphite

I have been asked to revoke access from a few developers in SQL Server...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers