Since it's all on the same server you're sharing, by default, the same memory, CPU and tempdb. The one area of separation you can get is with disks. Not knowing...

WayneS (8/26/2011)

---

Grant Fritchey (8/26/2011)

---

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I have...

GilaMonster (8/26/2011)

---

Grant Fritchey (8/26/2011)

---

Work is having me post at another forum, nameless, where I'm the lone voice suggesting that, oh, maybe setting all your databases to simple recovery is not...

I just want to say that I love it here.

Work is having me post at another forum, nameless, where I'm the lone voice suggesting that, oh, maybe setting all your...

SQLRNNR (8/26/2011)

---

Grant Fritchey (8/26/2011)

---

SQLRNNR (8/26/2011)

---

Grant Fritchey (8/26/2011)

---

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid...

skrilla99 (8/26/2011)

---

Grant Fritchey (8/26/2011)

---

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I have...

Gianluca Sartori (8/26/2011)

---

Grant Fritchey (8/26/2011)

---

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I...

SQLRNNR (8/26/2011)

---

Grant Fritchey (8/26/2011)

---

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I have...

Stefan Krzywicki (8/26/2011)

---

Grant Fritchey (8/26/2011)

---

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I...

skrilla99 (8/26/2011)

---

Grant Fritchey (8/26/2011)

---

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I have...

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I have four so far:

Backing...

I'm sorry, but you've completely lost me. What is it you're looking for now?

GilaMonster (8/26/2011)

---

A clustered index (or any other index for that matter) shows null for the stats date if there are no rows in the table, or if the index is...

ananda.murugesan (8/26/2011)

---

Thanks for reply..

This is script for find out last stats updated date.

select a.id as 'ObjectID', isnull(a.name,'Heap') as 'IndexName', b.name as 'TableName',

stats_date (id,indid) as stats_last_updated_time

from sys.sysindexes as a

inner join sys.objects...

SELECT * FROM TABLE without any where clause means that every single row on the table has to get retrieved. Putting an index on it, clustered or not, doesn't change...