Viewing 15 posts - 13,906 through 13,920 (of 49,552 total)
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...
March 13, 2013 at 1:36 am
aurato (3/12/2013)
Would you recommend migrating the databases on this disk to a different drive?
Well, ask yourself, would you leave important information on a drive that's giving repeated problems?
March 12, 2013 at 2:38 pm
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.
March 12, 2013 at 10:45 am
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...
March 12, 2013 at 10:43 am
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.
March 12, 2013 at 10:41 am
Double-check the login's default database. Error message is saying it's not available.
March 12, 2013 at 8:46 am
Please run the following and post the full, complete and unedited output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
March 12, 2013 at 8:39 am
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...
March 12, 2013 at 8:24 am
In short it just doesn't use parameter sniffing to estimate the rows that will be affected by the specific parameter values.
March 12, 2013 at 6:56 am
Tobar (3/12/2013)
But I am still left with my question, better defined now to be sure, why does SQL Server not allow a function as a parameter?
Why can I not create...
March 12, 2013 at 6:35 am
Sen1 (3/11/2013)
I need to write DR/HA proposal any suggestions?
Do you have any HA/DR experience?
March 12, 2013 at 6:01 am
T-SQL syntax rules, the parameter to a procedure cannot be a function.
March 12, 2013 at 5:59 am
KumarSQLDBA (3/12/2013)
March 12, 2013 at 4:47 am
Run DBCC UPDATEUSAGE, see if it fixes anything.
March 12, 2013 at 4:23 am
Viewing 15 posts - 13,906 through 13,920 (of 49,552 total)