Ziljan4 (1/6/2008)

---

Thank You again for clearing some misunderstandings.

So, can I conclude that the only way to resolve the growing log is to take T log back up which truncates...

I don't agree...

Since they didn't say about log backups,...

Or databases per customer. I've seen that before. I haven't yet had the 'pleasure' of working on monthly databases.

Sure. Thing is with the rownumber, you'll only be reading the table once. With exists, you're reading it at least twice.

-- returns 10 rows for the second page of a...

Could you post the definitions of the two tables and all the indexes on them please.

All I can see from the exec plan is that you have two index scans....

Step 4: Rebuild all your indexes to undo the damage that ShrinkDatabase did to them

Turn traceflag 1204 on (DBCC TRACEON (1204)) then run your proc. You'll get a deadlock graph written to the error log that will tell you the two processes involved in...

Could be IO related, could be insufficient memory, could be network speed. Could also be memory and display time on the client. It's about 70 MB of data you're tossing...

The order of expressions in the where clause doesn't make the slightest difference. SQL will do them inn whatever order is most efficient, based on the data and the available...

Hmmm. Sometimes...

It's a pleasure, and thank you for the feedback.

There is no way to update any of the system tables in SQL 2005.

Try running a DBCC CheckDB on that database. I think checkDB checks the system catalogs, so...

With mine, the error is because you didn't create the function DateMonthStarts. It's not an inbuilt SQL function. The contents of the function can be found on the page I...

Have a look at the hash_bytes function. Might do what you want. There's also checksum and checksum_agg

I'm not sure they're sufficient for what you're trying to do, but they might...