Viewing 15 posts - 24,376 through 24,390 (of 49,552 total)
Leave it alone. You have no memory issues and the cache is small. Why do you want to mess around?
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
August 6, 2011 at 4:24 am
Ninja's_RGR'us (8/5/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
August 6, 2011 at 3:51 am
Generally never, unless you have very specific problems and know exactly what you're doing.
The only time you'd consider that is with lots and lots of ad-hoc plans causing problems other...
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
August 6, 2011 at 3:48 am
Ninja's_RGR'us (8/6/2011)
Was it you Gail that said you don't even make 1$ / hour on your articles (this site pays 25$ / article)?
Wasn't me, but it's very true. What Steve...
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
August 6, 2011 at 3:46 am
A PageIOLatch is an IO subsystem wait. Means you're pulling more data than the drives can handle. To fix that you need to reduce the amount of data that 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
August 6, 2011 at 3:35 am
I loved this:
Craig Farrell (8/5/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
August 6, 2011 at 3:32 am
Ninja's_RGR'us (8/5/2011)
And then you do your own work + presentations (at your own expanse, travel, hotel & all). And your blog... and answer e-mails from those blog posts...
And you...
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
August 6, 2011 at 3:30 am
Oracle_91 (8/6/2011)
When does a PFS page actually gets created?
They're regularly spaced through the file, so it'll either be when the file grows or the first time SQL need to allocate...
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
August 6, 2011 at 3:18 am
shrinking causes severe fragmentation. To fix fragmentation, SQL needs free space in the database.
http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
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
August 5, 2011 at 4:37 pm
SQLRNNR (8/5/2011)
GilaMonster (8/5/2011)
Anyone want to 'help' out here? http://www.sqlservercentral.com/Forums/Topic1155386-391-1.aspxp.s. if you go to his blog, several posts have pieces copy-paste from a Microsoft webpage, no attribution
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
August 5, 2011 at 4:28 pm
It was hit "I see that on expert's blogs. Why shouldn't I have it?" that got me.
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
August 5, 2011 at 4:27 pm
meridius10 (8/5/2011)
Can I just have a minimal express version if I'm thinking of doing 70-433 or 70-432?
Express doesn't have a whole lot of features, again, you can, but then there...
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
August 5, 2011 at 4:16 pm
Developer is completely equivalent to Enterprise (for 2008) in all features (there's nothing in Enterprise that's not in Developer), it's just not licensed for production usage.
Or you could use 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
August 5, 2011 at 3:50 pm
Index rebuilds?
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
August 5, 2011 at 3:43 pm
Anyone want to 'help' out here? http://www.sqlservercentral.com/Forums/Topic1155386-391-1.aspx
p.s. if you go to his blog, several posts have pieces copy-paste from a Microsoft webpage, no attribution
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
August 5, 2011 at 3:42 pm
Viewing 15 posts - 24,376 through 24,390 (of 49,552 total)