Thanks for the lovely article... this is my first effort at SSIS.

I am trying to do the same steps, in this second article, but on our databases. I...

Two very good idea's. Since I have very limited powershell skills, I think the second is what I will do.

Thanks

Thanks, I just noticed that I left one key fact out.

The trace runs for a set amount of time then stops, and SQL server removes it from sys.traces. So...

Thanks for your help.. BTW I put a covering index into place, but the job that inserts data into that table grew from 30min to 90min (give or take a...

Thanks... BTW it is an inner join. I have already sent a request off to the software company to see if we can create a PK. Currently there is not...

Thanks. The windows folks have locked me out of that folder, so I have requested the setting to be raised. Of course once we go live, this will likely only...

The App manager said it was not needed and should be deleted. Thanks for telling me what it is for, I will push back.

Thanks,

David

Thanks.. man I can not tell you how many times I read through that and did not see the problem.

Thanks I will try and see what I get, but not sure that it will show much if I am just checking for deadlocks. All the job (at that step...

GilaMonster (1/9/2013)

---

dwilliscp (1/9/2013)

---

I was trying to find a better approach than what I am currently doing... that is starting with the query, pulling the top 10 and looking at what...

Oh, one other side note. (this has not happend yet, since there were almost no indexes) But I like to only have about 3 Non-Cluster indexes on tables, unless they...

SQLRNNR (1/7/2013)

---

dwilliscp (1/7/2013)

---

SQLRNNR (1/7/2013)

---

dwilliscp (1/7/2013)

---

GSquared (1/7/2013)

---

"When to index" isn't a question of the query. Not really. It's a question of what you're trying to do.

There's no way to...

SQLRNNR (1/7/2013)

---

dwilliscp (1/7/2013)

---

GSquared (1/7/2013)

---

"When to index" isn't a question of the query. Not really. It's a question of what you're trying to do.

There's no way to tell, from...

Oh, on a side note... I do go through and look for indexes that have user updates, but no user seeks + user scans + user lookups. And pass that...

GSquared (1/7/2013)

---

"When to index" isn't a question of the query. Not really. It's a question of what you're trying to do.

There's no way to tell, from what you...