Fal (8/22/2013)

---

Speaking of fruit. The missus and I are getting a new kitchen in and are trying to finalise a few issues.

We were thinking of getting a stone benchtop,...

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

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

There is no consistency check performed at startup or automatically at any other time. The only time SQL performs a consistency check...

A clustered SQL Server's database files must always...

If those inactive databases are never used, you can take them offline. If they're offline, SQL won't open or recover them on startup.

Still, with thousands of databases you're looking at...

Ordinal position is the position within the create table statement and in the metadata, hence the default position when doing a select *. That's it. It has no bearing on...

Log backups as well?

Is once a month often enough? Do you retain all your backups (full and log for month)? If not, what do you plan to do if the CheckDB picks up...

Restore from a clean backup. That's not repairable.

If you have an unbroken log chain from the clean backup then you won't lose any data (you can take a tail-log backup...

What are you partitioning for? What's the goal?

Backups do not automatically fail. You have to explicitly add the option to the backup statement to check the checksums. Maintenance plans don't allow that option and most people don't...

Having 10MB as the target number does not mean that the log will shrink to 10MB, only that 10MB is the minimum. If say the log has 25MB of log...

First problem there, the database snapshot for CheckDB can't be created. Is that an NTFS drive, does the SQL Server service account have full permissions to the folder with the...

Sounds right, but check with a sysadmin.

No.

Well, you can do it, but it will give you absolutely no knowledge about whether the database...