Viewing 15 posts - 22,936 through 22,950 (of 49,552 total)
chandan_jha18 (10/15/2011)
Are temp tables bad and should be avoided?
No, there are cases where they are very useful. However in the example I commented on, a temp table is totally...
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 15, 2011 at 6:07 pm
Steve Jones - SSC Editor (10/15/2011)
Not enough of a detailed explanation according to Gail as she was trying to throw a shuriken, or rubber duck, or something at me.
I was...
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 15, 2011 at 1:04 pm
A temp table and 3 updates for what can be done in a single query? Not exactly the best option around for performance...
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 15, 2011 at 12:22 pm
Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1190392-146-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
October 15, 2011 at 11:58 am
derekr 43208 (10/14/2011)
Make sure that you have the same drive structure on the new machine as the old one.
There's no need whatsoever to do that. There is nothing about moving...
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 14, 2011 at 10:57 pm
Ruan, I'll be honest, I think you probably need to get someone in for a few days on this...
The highest wait time is mirroring. That means either the network or...
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 14, 2011 at 10:52 pm
ketan_katkar (10/14/2011)
1. Create new .ndf file for your DB & keep it on "E" dirve.2 Create new .ndf file for your Temp DB & keep it on "E" drive.
Those 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
October 14, 2011 at 10:46 pm
You have GOT to watch this: http://www.youtube.com/watch?v=xC1DIf5hcVw
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 14, 2011 at 10:38 pm
WayneS (10/14/2011)
The THREAD rules!The authors of SQL Server MVP Deep Dives 2 that frequent The Thread all signed my book with notes of The Thread's eternal survival.
You are most 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
October 14, 2011 at 10:32 pm
Ninja's_RGR'us (10/14/2011)
For the 15 posts you said you had troubles finding / pasting the link and were not on your laptop?
iPad. I haven't synced bookmarks and I don't have my...
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 14, 2011 at 10:25 pm
Call Microsoft Customer Support
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 14, 2011 at 10:58 am
Call Microsoft Customer Support.
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 14, 2011 at 10:42 am
Ninja's_RGR'us (10/14/2011)
P.S. What tablet are you using that makes it hard(er) to copy / paste?
Err, my win7 laptop.
It's not copy-paste that's problem, it's that I'm posting in spare minutes.
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 14, 2011 at 10:41 am
Ninja's_RGR'us (10/14/2011)
This is what Gail has in mind :http://sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx
Thank you. It's hard to keep up with SSC while at SQLPass2011
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 14, 2011 at 10:26 am
My bet - excessive VLFs. See Kimberly Tripp's blog.
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 13, 2011 at 11:28 pm
Viewing 15 posts - 22,936 through 22,950 (of 49,552 total)