Read uncommitted is pretty dangerous for any number of reasons.

Most systems I work with are Read_Committed for all the details provided above. Some of the newer systems under development in...

view server state is not the same as sysdmin. It allows the user to view server level objects, not manipulate them. There is also a view database state. You could...

It does sound like a permissions issue. I've never had any problem working with 2005 from the 2008 SSMS. It is possible that SSMS tries to do things in 2008...

Robert Frasca (5/5/2010)

---

My experience is that function references in the FROM clause, i.e. inner joins, usually dramatically outperform function references in the WHERE clause because the WHERE clause must execute...

kinzent (5/5/2010)

---

Grant Fritchey (5/5/2010)

---

First you need to identify if you are seeing blocking as the primary source of your performance problems. The best way to do this is to monitor...

Chris Morris-439714 (5/5/2010)

---

GabyYYZ (5/5/2010)

---

Steve Jones - Editor (5/5/2010)

---

Gianluca Sartori (5/5/2010)

---

Today I ran across the strangest threads I've ever seen here on SSC:

Want to buy a Ford car?

A sad story from...

First you need to identify if you are seeing blocking as the primary source of your performance problems. The best way to do this is to monitor the wait states...

Since this is homework, you need to show the work you've done already.

In order for someone to really help they're going to need to see the structure of the tables...

Roy Ernest (5/5/2010)

---

Grant Fritchey (5/5/2010)

---

Roy Ernest (5/5/2010)

---

Yes yes Yes...!!!

My article is out on SQL Server Standard in SQLPass site. I have been waiting for this day. Happy day for me....

Darn, I knew...

mbricker-600840 (5/5/2010)

---

Too late!! Our company already hired some...

There isn't a way to get the list of unused objects directly. You can only try to determine the objects that are in use. Depending on the method you use,...

To my knowledge, you can't. It's dependent on the system fonts running from the...

Thanks for posting back with what solved the issue. It's helpful for us and for anyone else that finds this in the...

GilaMonster (5/5/2010)

---

Yes, you can use the missing index DMVs, however less logic goes into producing those recommendations than the recommendations produced by DTA. Neither should be trusted without verification, all...