Kit G (7/9/2010)

---

Cool. Should there be an evil laugh after "But now I have a plan"? :w00t: This is after all, The Thread....

I'd be interested in seeing it too (unless you already sent it to me & I lost it, entirely possible). We've been getting great results with our indexes, but we...

lverea-783150 (7/9/2010)

---

Hello:

I 'm starting to manage a very big non-documented database created by another people.

I wish to know if there is a way (an script or something like that) to...

Yes!

More detailed, it depends.

Even more detailed, assuming a covering index, meaning an index that can satisfy all the requirements of...

Sorry, nothing built in for that. You'll have to roll your own.

I'd take a look at the sys.dm_tran_locks dynamic management view. You could also use sys.dm_exec_requests to see which sessions are blocked, but just to see all locks, the first DMV...

The industry had respect for the traditional DBA?

There are a lot of products and processes out these days, specifically targeted at eliminating the need for DBA's. For some reason we've...

aravind-305595 (7/9/2010)

---

Hi, Thanks all. I thought to re-write that piece of code with suggestion given in this forum. Now I face another issue with the joins, my code looks like,

update...

oliver.morris (7/9/2010)

---

Hi,

Thank you for your continued support. I already have Alastair's superb book.

I have attached the 3 execution plans to for the 3 queries in your post. They all use...

Not that I'm aware of, but then I miss the hardware/server stuff sometimes.

Tom Robertson (7/8/2010)

---

I hear what you are saying with not having a great comparison, but I really think the hardware is not the issue.

the reason I think that is because

A)...

Sharepoint most definitely has to run as 'sa.' I've never seen anything to suggest otherwise and everything I've seen it do on the server pretty much suggests that's how it...

I wish I could say yes so you'd buy a copy, but no, it doesn't cover spatial queries. If you don't have a copy of Alastair Aitchison's excellent book, I'd...

Tom Robertson (7/8/2010)

---

Thanks for the ideas guys,

I neglected one important piece of info. The development workstations are running sql 2008, database is in 2005 mode

production servers(I've tested 3 different ones...

You're basically completely out of luck.

You might be able to query the cache to see which procedures might have a last run time near the time of the data loss...