Very nice article and good explanation. Can you please add your thoughts related to performance and is this the recommended way to do it?

GilaMonster (10/6/2013)

---

Drop the clustered index = recreate the entire table and rebuild all nonclustered indexes

Create the clustered index = recreate the entire table (again) and rebuild all nonclustered indexes (again)

Given...

GilaMonster (10/6/2013)

---

If you disable the clustered index, the entire table is inaccessible (can't be read or modified), so you can't do that before a load or the load will fail.

As...

curious_sqldba (10/5/2013)

---

I am trying to understand why are my stats still stale, below are the steps involved in the process:

i) Disable all indices (clustered and non-clustered)

ii) Load all the data...

GilaMonster (9/26/2013)

---

Primary purpose of an index is to reduce the number of rows in consideration for a query as early as possible. Which reduces row count, a filter or a...

GilaMonster (9/26/2013)

---

Primary purpose of an index is to reduce the number of rows in consideration for a query as early as possible. Which reduces row count, a filter or a...

Can i check that from an execution plan?

nope

I guess i could . I am trying to replay transactions from prod to my test, but then i cant replay or wont have any value to the one's which...

Thanks . Then comes my second question, is there any way ONLY to filter on "Reads" in profiler, i mean i basically want queries thats DONT change the data...

Leo.Miller (1/13/2011)

---

Reducing READS tends to...

Incase if someone else is looking for an answer hopefully this might help. Jonathan Kehayias explained me in detail, below is the script from our email conversation.

There is a ProfilerSpecialEvents.XML.profiler...

//Ravi (9/10/2013)

---

The "Duration" column in the Profiler. In SQL 2008, it shows the timings in Microseconds (i.e. divide by a million to get seconds) and in SQL 2005, it...

I would also like to know. I am not sure how to analyse the execution timings?

http://www.sqlstress.com/ - Doesn't support custom script.

http://www.datamanipulation.net/sqlquerystress/ - Very good simple tool, i was looking for some more detail output.

dvdstore - Link...