Viewing 15 posts - 10,411 through 10,425 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2014 at 10:33 pm
Moving TempDB is easy. The other three, not so much.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2014 at 1:28 pm
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2014 at 11:44 am
Just use max server memory (and if it's not set, set it to a sensible value)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2014 at 5:22 am
The path you've specified for the mdf file doesn't exist
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2014 at 8:09 am
Viewing 15 posts - 10,411 through 10,425 (of 49,552 total)