Viewing 15 posts - 10,411 through 10,425 (of 49,566 total)
sqlnaive (1/14/2014)
My question is whether should it work like this or not ?
Should work. Try printing out the generated dynamic SQL and looking at the one that breaks and seeing...
January 15, 2014 at 2:53 am
Backup history is in MSDB, in the table BackupHistory, restore history is in MSDB in the table RestoreHistory.
Mailed notifications you'd have to implement yourself afaik.
January 15, 2014 at 2:32 am
smallmoney (1/14/2014)
Is it true that you can only have mdf files in the Primary Group?
No. You could call a database file Readme.txt if you like, SQL won't care. The file...
January 15, 2014 at 12:17 am
None.
Seriously, don't change anything unless you have a specific reason to change it. Most of the defaults are good. You've already changed max server memory which is one of the...
January 15, 2014 at 12:16 am
Lynn Pettis (1/14/2014)
Just verifying that 824 errors usually point to a possible I/O Subsystem issue.
Almost definite. Something changed values on that page on disk after SQL wrote it out, before...
January 14, 2014 at 10:33 pm
Moving TempDB is easy. The other three, not so much.
January 14, 2014 at 1:28 pm
January 14, 2014 at 11:44 am
Just use max server memory (and if it's not set, set it to a sensible value)
January 14, 2014 at 6:26 am
Please run the following and post the full and complete, unedited output
DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a clean backup and an unbroken log chain from that...
January 14, 2014 at 5:22 am
The path you've specified for the mdf file doesn't exist
January 13, 2014 at 11:53 pm
Use the nolock hint or read uncommitted isolation level (same thing). Any queries running under that isolation level read the dirty (uncommitted) data
January 13, 2014 at 11:45 pm
It's only necessary for 32 bit. If you're still running 32 bit SQL now, it's well past time to reconsider and install the 64 bit version instead
January 13, 2014 at 11:43 pm
mxy (1/13/2014)
our application uses lot of dynamic sql, since sql cannot reuse the execution plan
Why can't SQL reuse the execution plans?
If you're properly parameterising your Dynamic SQL (necessary for...
January 13, 2014 at 11:40 pm
Yes, it will be usable.
Maybe speak with whoever is responsible for the SAN, they'd know the most about it. Or contact the storage vendor
January 13, 2014 at 2:47 pm
The only time I'll use three-part naming is when I know that I need to be crossing databases. Otherwise 2-part naming's fine.
January 13, 2014 at 8:09 am
Viewing 15 posts - 10,411 through 10,425 (of 49,566 total)