amoericke (12/14/2009)

---

I’ve got a database that is logging customer activity (24x7 environment), and is retaining 7 days of data. There is a delete that runs nightly, deleting the oldest...

Partially. Pre-SQL 2008 a heap can't be rebuilt except by creating a cluster on it. A heap can still have the 10% avg usage of pages if the rows deleted...

I don't think this is a stats problem. If it was, the proc would have run slow everywhere. Slow from some places and fast from others is not a symptom...

Then there was some kind of network glitch between the client and server. The error is a...

Why the subquery at all?

UPDATE SomeTable SET Column = TextColumn

FROM SomeTable INNER JOIN OtherTable ON <join condition here>

WHERE OtherID = @ID

AND WHERE SomeID = 1 --...

Should you be trying to avoid it with the row counts that you mentioned?

http://sqlinthewild.co.za/index.php/2009/11/24/the-most-optimal-join-type/

If the row counts were...

Don't understand your question. It's a scalar function that takes 3 parameters and returns a value.

Paste it into a management studio query window and do a syntax check. That should give you a message saying what's wrong and on what line.

bkeahl (12/14/2009)

---

I guess I'll write code that builds the field list based on the source database so it can dynamically build the select fields list and use Group By ......

Consequences of turning auto-shrink off - improved performance. Read the following, and then read the two blog posts that it links to (at the bottom)

http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/

It may well do. Say those deletes have been spread out over the table. You may have large portions of...

Firstly you shouldn't be using select *, no matter the number of columns. You're risking the app possibly breaking if a column is added in the future. Just specify...

Have you rebuilt all the indexes on the tables that rows were deleted from?

one-1016367 (12/14/2009)

---

I'd be happy to share them - but again, how is that relevant when the indexes are working just fine when the SP are run manually, and were also...

Doesn't matter if it's before or after, unless it's doing a...