Aaron Ingold

SQLServerCentral Article

Indexing in SQL Server 2005

How should you approach indexing your database? Do you have a good strategy for deciding which indicies to create and on which columns? Aaron Ingold brings us a great article discussing these very topics that is likely to become a must read for many DBAs.

4.89 (9)

You rated this post out of 5. Change rating

2007-12-24 (first published: )

21,675 reads


A New Word: Ghough


ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection


I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets


Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs


Need to output table data into multiple CSV files

By Mh-397891

Hello, I created the below script to output 999 rows from SQL Server table...

Changing Database page Verify on a Database in an AG

By John D

I have a database on SQL 2019 in an Availability Group (AG) and I...

Alwyason availability group can set primary role permanently?

By SQL Galaxy

Hi. Two node windows clusters Node1 and Node2 and configured alwayson availability group. Will...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers