Viewing 15 posts - 20,671 through 20,685 (of 49,552 total)
To be honest, it works very well. I have 2 clients with all their databases on read committed snapshot and another 2 that I plan to convert over (one after...
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 31, 2012 at 7:53 am
Runs fine on SQL 2008 SP3 too.
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 31, 2012 at 6:51 am
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
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 31, 2012 at 6:10 am
Data caching and plan caching
First execution data has to be pulled from disk and plan has to be compiled. 2nd execution both data and plan come from cache.
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 31, 2012 at 3:46 am
Late I know, but I didn't see this when it was posted
David Moutray (12/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
January 31, 2012 at 1:59 am
DBA Rafi (1/31/2012)
After the sales process, i am seeing some factors which does not change, but more SELECTs on them, likeScenario #2: Static / Hardly-changeable Information (Master tables)
If 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 31, 2012 at 1:47 am
Also exclude the error log. (file name is ERRORLOG)
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 30, 2012 at 3:38 pm
Any time some action within SQL causes corruption it's a bug.
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 30, 2012 at 11:12 am
In short, you don't. You would have to delete the trace and recreate it.
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 30, 2012 at 11:10 am
Wait until the rollback is complete.
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 30, 2012 at 11:09 am
Homework?
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 30, 2012 at 10:18 am
DBA Rafi (1/30/2012)
Because, i have started an exercise to put NOLOCK in all the APPLICABLE (,where all the dirty read is OK) places in project.
Why oh why oh why?????
Are 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
January 30, 2012 at 8:36 am
sqlquest2575 (1/30/2012)
Msg 911, Level 16, State 1, Line 1Database 'test' does not exist. Make sure that the name is entered correctly.
Did the create database throw any error? Which line does...
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 30, 2012 at 8:19 am
drew.allen (1/30/2012)
Separate your database creation script from the rest of your scripts somehow.
It's already separate. There's a GO after the create database, so any statements after that will parse and...
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 30, 2012 at 8:18 am
Start with these
Then buy this: http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/ref=sr_1_2?ie=UTF8&qid=1327932227&sr=8-2
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 30, 2012 at 7:04 am
Viewing 15 posts - 20,671 through 20,685 (of 49,552 total)