Apparently Gail Shaw has given massive amounts of contributions in this regard and this article talks in depth about general performance tuning.

I think my issue was included in this article...

Thanks Kevin

I think I should also get the devs to understand this topic.

Index added was non clustered index. Table was already clustered on auto increment ID as int.

The function in the WHERE clause was returning an integer based on if the record...

Just to reiterate or beat a dead horse, is_auto_close_on = 1 is bad.

As soon as no connections to db, db closes.

When connection is opened, then db has to start and...

Thanks guys.

I did a test and checked the index size when only [col2] and also when index = [col2,RID].

They are almost the same size where RID is clustered. difference...

great, then I can log a defect against all those indexes which explicitly include a clustered column as part of the non clustered index.

frfernan (9/29/2011)

---

I usually try to avoid non-unique indexes, adding the primary key after the key fields; in this case, an index (Col2, Col3, RID) has sense for me. It is...

VS2010 Load Test using WebTest

Basically, you create a functional test sample of work.

Since my application is a webApp, I then have to extract a value from the querystring which I...

Thanks Gail

Thanks Gail.

Would you even consider this as a way to do avoid a lookup to the table for col2,and 3?

That's a very interesting point and worth investigating. I was looking at some of the indexes on Friday; one of which has two columns that are bits. Is it...

Firstly, here is a script which should list all tables and records which are duplicated, PK is removed from this comparison.

So the script will dynamically group by all the columns...

Reevaluate indexes. You may be carrying unnecessary baggage.

Run a script to start with, find duplicate indexes. Drop them.

Then look at the usage of remaining indexes.

If you have only updateson the...

My reason for creating a clustered index on RID is that

Where using the non clustered index for joins or queries, if the RID was an output of the query or...

Excluded tables with primary keys, since they enforce unique constraint even if the index is not set as unique.

Additionally, this will run on the entire database.

The table name has been...