Viewing 15 posts - 22,891 through 22,905 (of 49,552 total)
There goes the Thread for the night.
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
October 18, 2011 at 12:46 pm
Elliott Whitlow (10/18/2011)
Whether it is SQL 2011 is a good question but the V11 doesn't necessarily relate to 2011.
It's an answered question. Denali is SQL Server 2012 with a release...
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
October 18, 2011 at 12:42 pm
Hmmm... This: http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.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
October 18, 2011 at 12:33 pm
define 'not working'
post the exact code you're running. Did you run Lowell's script? Did it succeed?
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
October 18, 2011 at 11:24 am
MarvinTheAndriod (10/18/2011)
Why not just uninstall and re-install SQL instead, rather than rebuilding the master?
Because it takes longer.
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
October 18, 2011 at 10:59 am
sdownen05 (10/18/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
October 18, 2011 at 10:58 am
Lowell (10/18/2011)
i ran mine on SQL 2005/2008; the views may report different results between versions, i guess.how about ....WHERE name like '_WA_Sys_%'
That will only catch the auto-created stats, 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
October 18, 2011 at 10:05 am
Be honest, don't exaggerate your skills, don't claim to know stuff you don't.
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
October 18, 2011 at 10:04 am
Lowell's code is one way, you can also use the status column. Status is 8388672 for statistics and other values for indexes. Also filter for indid>0
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
October 18, 2011 at 10:03 am
On 2008 it'll just fail quietly. There was a traceflag to make it fail on 2005 as well, don't recall offhand.
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
October 18, 2011 at 9:55 am
Are you on SQL 2000?
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
October 18, 2011 at 9:54 am
SQLDCH (10/18/2011)
I have a database that takes over 20 mins to come back online after a reboot. It remains in the "restoring" state and is inaccessible.
Restoring or recovering?...
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
October 18, 2011 at 9:45 am
Stefan Krzywicki (10/18/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
October 18, 2011 at 9:40 am
The first 2 are not the same.
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
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
October 18, 2011 at 8:45 am
Sean Lange (10/18/2011)
I pretty much started it and you are right. It was unprofessional.
That said, it was a little ironic, and it's something I keep seeing here, twitter and SQLTeam....
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
October 18, 2011 at 8:42 am
Viewing 15 posts - 22,891 through 22,905 (of 49,552 total)