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

It's like I said. An address table instead of fields in the person table. That way you can store a single address one time. Then an interim table, a table...

I am not certified, so take my advice with a HUGE grain of salt...

Considering the differences between 2008 & 2012 and the fact that MS has changed the certifications and...

It's basically OK. I'm not crazy about how you've set up the contacts relationship. I would have two different interim tables, one for relations between a person and an address...

Thanks. Jumped right on that.

The best way to track T-SQL commands that have been issued in the past is through an extended event session. They're easy to set up and there's a function to...