Viewing 15 posts - 24,886 through 24,900 (of 49,552 total)
Did you look in Books Online for what the defaults are?
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
July 15, 2011 at 5:11 am
You can run it if you want, though running it with NORECOMPUTE means that you do not EVER want that statistic to be automatically updated. If you've been updating your...
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
July 15, 2011 at 4:10 am
That's incredibly unusual. You can't get single-core processors for servers. It's probably a virtual machine and that's messing up winaudit. If that's the case, you'll have to speak to 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
July 15, 2011 at 2:35 am
If it's a web app (you can't count users) it has to be processor licensing. Note that's processor, not core. Two quad-core CPUs require 2 processor licenses, not 8.
As 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
July 15, 2011 at 2:09 am
Possibly they haven't been needed since. Stats are updated the first time that they are used after the 20% threshold is reached. If no query has tried to use them...
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
July 15, 2011 at 2:04 am
You shouldn't have a shrink job. The recommended practice with the log is to back it up regularly, let it reach the size it needs to be for regular operations...
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
July 15, 2011 at 1:43 am
Here you go: http://sqlblog.com/blogs/paul_white/archive/2011/07/07/bitmap-magic.aspx
A parallel query that runs faster than the serial query and uses less CPU. You're welcome.
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
July 14, 2011 at 3:04 pm
Even a shut down of SQL won't do it. (actually, that should be 'especially' a shut down won't do it.)
You'd need to make sure that there are no active transactions,...
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
July 14, 2011 at 12:43 pm
You need to restore the next log backup in the chain. That's what the message is telling you, that you need a further roll forward to bring the DB to...
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
July 14, 2011 at 11:52 am
Steve Jones - SSC Editor (7/14/2011)
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
July 14, 2011 at 10:08 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1141896-391-1.aspx
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
July 14, 2011 at 10:07 am
Then there's probably no problem here. If the backups are succeeding and the log is not growing, there's no problem. Wait reuse reasons are normal, as long as they're not...
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
July 14, 2011 at 9:47 am
What does SELECT @@version return?
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
July 14, 2011 at 9:22 am
It might be in the default trace. Other than that, no way.
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
July 14, 2011 at 9:17 am
mortalic (7/14/2011)
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
July 14, 2011 at 9:17 am
Viewing 15 posts - 24,886 through 24,900 (of 49,552 total)