http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

How long is a piece of string?

There's no simple answer. Depends on the size of the table (in MB), the other activity,...

On 2008 Enterprise you can look at Change Tracking, Change Data Capture and SQL Audit. Haven't actually worked with any of them, so can't really give you an opinion. Play...

1b. Probably, but why would you want to use MAX? Jason posted showing a couple of queries for getting the row counts from sys.partitions.

2. Don't understand the question. Order of...

It doesn't. If you want to know how many rows have...

Very strange. Not sure what's happening there.

I would...

All changes to a database are logged (including schema changes). Since log shipping takes the log backups (which contain all the changes) and restores them on the secondary, all changes...

Are they all part of the same database? The error says that you've got some files from one database, some files from a different database and you're trying to attach...

This is a Microsoft SQL Server forum. You might get...

Anything in particular?

Bru Medishetty (11/17/2009)

---

Database partitioning is available in SQL 2005 / 2008, but it does not partition the processor workload.

Resource Governor a new feature in SQL 2008 can give a similar...

subs99 (11/17/2009)

---

I thought by making a really long original post with all the details I was being nice and clear or whatever.

But it turns out by making a superJumbo-sized post...

Odd. You're absolutely sure this database is in simple recovery?

If you run a manual checkpoint does the log usage drop?

DISTINCT TOP 100? If run without distinct does it really return duplicates? If so, why are there duplicates? If not, remove that distinct, it's expensive.