I would not call the table 'interim." That is a term that describes the function of the table. The table is for the many-to-many join. Many people can have many...

GilaMonster (4/24/2012)

---

Final? <sob>

If it finishes where...

GilaMonster (4/24/2012)

---

Grant Fritchey (4/24/2012)

---

I enjoyed it. A lot. The first third was better than the last two thirds. It's a first novel & you can tell, but it was still...

GilaMonster (4/24/2012)

---

Intriguing... I loved...

GilaMonster (4/24/2012)

---

#declare NewTopic;

Grant, you mentioned the other day that you'd finished the book "Temporary Duty" This one http://www.amazon.com/Temporary-Duty-ebook/dp/B00531CPHC/? Good? Recommended?

Looking for some good sci-fi again (space ships, interstellar travel, etc)....

GilaMonster (4/24/2012)

---

#declare NewTopic;

Grant, you mentioned the other day that you'd finished the book "Temporary Duty" This one http://www.amazon.com/Temporary-Duty-ebook/dp/B00531CPHC/? Good? Recommended?

Looking for some good sci-fi again (space ships, interstellar travel, etc)....

Jack Corbett (4/24/2012)

---

Grant Fritchey (4/24/2012)

---

Kiara (4/24/2012)

---

Lynn Pettis (4/24/2012)

---

Nope, too much fun watching now. I can even answer his question on why he keeps getting...

Kiara (4/24/2012)

---

Lynn Pettis (4/24/2012)

---

Nope, too much fun watching now. I can even answer his question on why he keeps getting the same value for @qtd on...

Only one comment. Both plans show the reason for early termination within the optimizer as Timeout. That means that neither plan can be trusted. Did the optimizer come up with...

My threshold on cursors is simple, "As close to zero as possible"

Yeah, I've used cursors for maintenance scripts because you can't do batch backups or batch statistics updates (well, I...

Simha24 (4/24/2012)

---

Ex :

SELECT i.name AS IndexName,SUM(s.used_page_count) * 8 AS IndexSizeKB

FROM sys.dm_db_partition_stats AS s JOIN sys.indexes AS i ON s.[object_id] = i.[object_id] AND s.index_id =...

Wait, partitioned?

Why not use the moving partition approach then? You don't delete anything. That's exactly what partitions are all about.

How big are those indexes. If they're less than 8 pages in size, defragmenting might not work at all. I would suggest setting a low limit on defragmenting indexes. Somewhere...

Based on that plan you're still doing a loop.

But, based on the plan, you're getting a table scan for each delete. The predicate is here: [MIS].[dbo].[LIV_CSS_DP_Counts].[day]=[@todelete]

That suggests that an index...

The others are 100% correct. Nothing happens to those data types. But, to be sure what is going to happen to your databases when upgrading from 2000, you should run...