SQL Server with Mr. Denny:

Index

1

June 5, 2013  2:00 PM

What does the RCSI overhead mean?



Posted by: Denny Cherry
AlwaysOn, Availability Groups, Clustered Index, Index, Indexing, Nonclustered Index, SQL Server, Tables

Earlier I posted a blog post which talked about the fact that when you turn on readable secondary replicas there are an

May 28, 2013  4:27 PM

Extra Bytes Per Row With AlwaysOn Availability Groups



Posted by: Denny Cherry
AlwaysOn, Database Administration, Execution Plans, Index, Index Performance, Index Seek, Indexing, SQL Server, SQL Server 2012

One of things to keep in mind with SQL Server 2012 AlwaysOn Availability Groups is that when the availability group has readable secondary replicas any...


April 25, 2011  2:00 PM

We get many warnings in our SQL error log about I/O requests taking longer than 15 seconds to complete. What do we do in such scenario?



Posted by: Denny Cherry
Index, Index Scan, Index Seek, SQL Server, Storage

There are a few things which you will want to look at.  First make sure that you have enough RAM for the database to use.  Without enough RAM in the SQL Server you’ll begin putting extra load on the disks because the same data is being pulled into the buffer cache from the disk over and...


October 15, 2009  11:00 AM

SQL Server gets an ANSI compliant unique index … sort of



Posted by: Denny Cherry
Index, SQL, T/SQL, Unique Index

If you work with any of the other big database platforms you've probably noticed that SQL Server's implementation of a unique index is "different" than the others.  Until now there hasn't been a way to fix that without using a trigger.  Until now...


March 26, 2009  3:00 AM

So really, how many clustered indexes can I create on a table?



Posted by: Denny Cherry
Clustered Index, Index

This used to be a very easy question to answer as the answer was 1. However these days, with some creativity you can get some extra ones.

Bookmark and Share     0 Comments     RSS Feed     Email a friend


February 2, 2009  1:31 PM

Back To Basics: Clustered vs NonClustered Indexes; what’s the difference?



Posted by: Denny Cherry
Back To Basics, Clustered Index, Index, Nonclustered Index

SQL Server has two basics kinds of indexes. They are clustered and nonclustered indexes. There are some fundamental differences to the two which are key to understanding before you can master index tuning.


January 26, 2009  12:00 PM

Back To Basics: What are indexes and what are they used for?



Posted by: Denny Cherry
Back To Basics, Identity theft, Index, Index Scan

A while back someone posted on the ITKE forum asking what Indexes where, and what they were used for. I put up a quick answer, but I felt that it deserved a more in depth blog post; so here it is.


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: