http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/

Easiest thing, go look at the Microsoft exam certification page where they describe all the exams, list all the exam paths and all the certifications.

I think it's 3, but I'm...

Maybe, maybe not. Depends on what the root cause is.

*sigh*

If you're regularly moving millions of rows from one table to another, have you considered partitioning? One of its main features is exactly that.

No, not at all.

They're two ways of stating the same thing, they perform and execute identically.

You mean your log backups? No, they won't just pick up again, yes, they...

WolfgangE (6/20/2013)

---

A table is stored on pages, the pages are stored on the disk. The clustered index defines the sort order in which the pages are stored on the disk.

In...

You mean 'don't reset the differential base', because that's all that a normal...

Look at the definition of the views (sp_helptext). Check the queries, what do they do?

Have you updated statistics since upgrading? Have you rebuilt indexes since upgrading.

Check the definition of the views. What filters are on the selects?

Not without AWE enabled,...

A restore will always recreate the database in exactly the same state it was at the time of backup. If the restore restored 4 tables, then the database at the...

Could you run the exact command I gave you please?

I don't have the time or patience to read over thousands of lines of the x rows in y pages...

Please note: 4 year old thread.