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,755 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,430 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,008 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,281 reads

Blogs

Optimize Azure Fabric Pipelines with This Key Spark Setting

By

Boost Your Azure Fabric Pipelines: Don’t Overlook This Crucial Spark Setting Are your Azure...

SQL Server Post-Install Configurations

By

The SQL Server installer has gotten better: tempdb configuration, MAXDOP, and even max memory...

How Vastu Principles Can Inspire Smarter Database Administration: A Holistic Approach to Data Architecture

By

In the fast-paced world of IT, Database Administrators (DBAs) are the unsung heroes who ensure that...

Read the latest Blogs

Forums

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

By Chandan Shukla

Comments posted to this topic are about the item How a Legacy Logic Choked...

Monitor SQL Server using Zabbix

By Pablo Echeverria

Comments posted to this topic are about the item Monitor SQL Server using Zabbix

Archiving data older than 5 years

By Andre 425568

Hi We have databases with data stored for over 20 years, this is required...

Visit the forum

Question of the Day

TCP Provider Errors in SQL Server

You're troubleshooting a connectivity issue between a client application and a remote SQL Server instance. The client receives a "provider: TCP Provider, error: 0 - No such host is known" message. You verify that SQL Server is running and reachable on the server. The SQL Server instance is configured with a named instance and uses dynamic ports. Which of the following steps is most likely to resolve the issue?

See possible answers