Viewing 15 posts - 3,241 through 3,255 (of 5,843 total)
Those two queries are NOT the same - one is parameterized and the other is hard-coded. This will absolutely lead to different plans.
Also, the after-some-time plan seems...
July 20, 2011 at 7:18 am
MudLuck (7/19/2011)
I have also read the article and it makes since that at the OS level only one thread can look a file at a time.
There for if...
July 20, 2011 at 7:06 am
I would say to stop using maintenance plans altogether. Get the awesome free mx package from ola.hallengren.com
July 15, 2011 at 8:27 am
I have collected a huge array of tools, scripts, etc. in my 15 years with SQL Server. I REALLY need to do a "tools I use" session for SQL...
July 13, 2011 at 9:29 am
properly designed code is the way to avoid procedure cache bloat. ORMs are HORRIBLE about this, as are poorly coded middle tier constructs (even ADO.NET).
July 13, 2011 at 8:50 am
Perry Whittle (7/12/2011)
RAID10 can offer fast reads depending upon the controller used. Modern RAID10 arrays will read from all online disks to improve performance
Good point Perry, and one which most...
July 13, 2011 at 8:47 am
LutzM (7/13/2011)
Frankie-464050 (7/12/2011)
Thanks for the link. Any way to get around this via hints or ?Yes. Read the article Gail pointed you at. 😉
Use the hard-coded value! ...
July 13, 2011 at 8:45 am
1) definitely beware DTA
2) dbsophic has a tool that is much better. they have a freebie trace analyzer too.
3) The BEST way to accomplish what you want is to...
July 13, 2011 at 8:44 am
get rid of unnecessary data. index btree depth could be reduced 1 or even 2 levels, saving 8-16KB page IO for EVERY INDEX SEEK. Believe you me that...
July 13, 2011 at 8:42 am
MickyD (7/12/2011)
Can someone confirm if I have this correct ?
I want to allocate a specific amount of available memory to 1 SQL instance.
SQL 2005 64 bit
6 instances on the...
July 13, 2011 at 8:38 am
Actually I much prefer FtF for the first stage of any significant engagement too. But for "hey, this one thing is broken and I need help on it now"...
July 12, 2011 at 8:05 am
Stop using maintenance plans. go to ola.hallengren.com and use the FREE and fully documented goodness there! Awesome stuff.
July 12, 2011 at 6:48 am
rfr.ferrari (7/11/2011)
after all comments/posted in this discussion, i have a question to pei zhu and kevin with relation the proposed scene, what i said in begin of discussion, is...
July 12, 2011 at 6:47 am
Viewing 15 posts - 3,241 through 3,255 (of 5,843 total)