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...

A heap doesn't have statistics, so I'm not sure what you're looking at there.

Clustered indexes should show the last update date. How are you looking at the statistics information?

Christi Wilson (8/25/2011)

---

Can someone point me to a good article on derived tables vs temp tables in regards to performance?

I didn't want to start a whole new thread as...

A CTE is a derived table. So, saying which one is faster or not, is not really possible per se. It depends on how they're put together, how they're called,...

Brandie Tarvin (8/25/2011)

---

Whoot!

Space Tramps is going to be available for order through your local bookstore when it comes out next month.

I HAVE ARRIVED!!!! Finally, a book I've written for that...

GilaMonster (8/25/2011)

---

Kiara (8/25/2011)

---

Sadly, my dojo time is what had to go. I've promised myself when the NoLongerSoSmallPerson is out of high school, I get to go back. And start over....