Yeah, most people aren't convinced until something fails catastrophically. Make sure your backups are good.

Also, it isn't necessarily the physical drive. Could be the firmware, drives, switch, cache, any filter...

Well, ask yourself, would you leave important information on a drive that's giving repeated problems?

IO subsystem problems in almost all cases. Could be as simple as a write cache that's not battery backed, could be misbehaving filter drives in the IO stack, etc.

Is the user a member of any groups that have logins in the database with different default databases?

In fact, check all the logins, see if any have a default database...

Drop the indexes 'IX_Advertise_BrandCopy_Price_Stock' and 'IX_ITEMS_ADVFLAG_PARETN_PRICE_STOCK' (on the table 'Items') and recreate them. Don't rebuild them, drop and recreate.

Double-check the login's default database. Error message is saying it's not available.

Please run the following and post the full, complete and unedited output.

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

Sounds like you're trying to do this:

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

If you are, optimise for unknown is not going to help much. All it does is have the optimiser make row estimations based just...

In short it just doesn't use parameter sniffing to estimate the rows that will be affected by the specific parameter values.

Why can I not create...

Do you have any HA/DR experience?

T-SQL syntax rules, the parameter to a procedure cannot be a function.

KumarSQLDBA (3/12/2013)

---

There's a special case where a backup that has to pick up bulk-logged extents will take a file lock which could block a checkpoint operation – but DML is...

Who are you protecting the data against?

Run DBCC UPDATEUSAGE, see if it fixes anything.