The secondary server should also be fragmented like the primary. Your updates, deletes, inserts are being transfered via logshipping to the secondary. Page splits that occur in primary...

Elliott Whitlow (9/22/2011)

---

I would create templates for sprocs, views, function and provide them to the DB developers. These templates would include the drop then create as well as the...

Thanks for all the good suggestions.

Tony++ (9/22/2011)

---

Meals - questionable depending on the dollar value. Wine, tickets = out of the question.

However, a squishy stress ball with the vendor's logo might work. Or a...

notoriousdba (9/22/2011)

---

I'd typically use a temp table to pass a bunch of results to another sp, the way Ninja's_RGR'us suggested. But if you're stuck on passing the data in as...

Grant Fritchey (9/22/2011)

---

GilaMonster (9/22/2011)

---

EXEC TotalChangeOfSubject

SQL Server MVP Deep Dives 2 will soon be available for pre-order and early access via Manning publishers: http://www.manning.com/delaney/

Chapter 8: "The how and why of Page...

GilaMonster (9/22/2011)

---

EXEC TotalChangeOfSubject

SQL Server MVP Deep Dives 2 will soon be available for pre-order and early access via Manning publishers: http://www.manning.com/delaney/

Chapter 8: "The how and why of Page Restores", Grant...

The error indicates that the package is 2008 and trying to run on a lower version of SQL. Could you confirm your package is 2005 and not 2008R2?

Jake Long?

Wooshoo Panda

If you are retrieving this from a SQL database, then why not do this calculation in SQL at the same time as retrieval?

I tend to agree with Celko on this one. This is a prime candidate for a redesign.

That said, what are the differences between the two tables? How many...

Could you explain a little more what you mean by partial data?

Is it that you are trying to fetch 10 columns and only 9 return?

Or is it that you are...

Jim Murphy (9/21/2011)

---

Boy, I tune back in after a brief outage and the whole world is upside down.

Y'all are speaking French, working in Oracle and Celko is offering...

Thanks for the question.