Viewing 15 posts - 2,896 through 2,910 (of 5,843 total)
GilaMonster (6/19/2012)
TheSQLGuru (6/19/2012)
GilaMonster (6/18/2012)
No. It's roughly 20%, but you'll need to test on your largest tables to see exactly.
Hey Gail - do you have a reference for that number you...
June 19, 2012 at 7:59 am
Indianrock (1/19/2010)
June 19, 2012 at 7:48 am
GilaMonster (6/18/2012)
No. It's roughly 20%, but you'll need to test on your largest tables to see exactly.
Hey Gail - do you have a reference for that number you can point...
June 19, 2012 at 7:43 am
Craig hit all the salient points here, as usual. Concurrency is the KILLER in UPSERT scenarios. You CAN handle it yourself, but in order to do so with...
June 19, 2012 at 7:42 am
Sachin Nandanwar (6/17/2012)
I was given a task to optimize this scalar valued UDF which was written terribly with bunch of cursors and no proper indexes on the underlying tables and...
June 19, 2012 at 7:39 am
chris-320654 (6/15/2012)
Rather than running the app...
June 15, 2012 at 9:21 am
Go hit up Amazon and buy Itzik Ben-Gan's Window Function Book: http://www.amazon.com/Microsoft-Server-High-Performance-Window-Functions/dp/0735658366. It is one of the few SQL Server books I have in my library - and if...
June 14, 2012 at 7:46 am
sqldba_newbie (6/12/2012)
my sincere apologies , after tracking back to the code( i didnt write this) i figured that the values are actual differential's from the baseline. Thanks.
Which is actually the...
June 14, 2012 at 7:43 am
Dan Price-242213 (6/11/2012)
June 12, 2012 at 7:57 am
"good enough" values for pretty much ANY counter are VERY dependent on your system and what type of performance you need and are actually getting. Assuming your server can...
June 12, 2012 at 7:54 am
Jeff Moden (6/5/2012)
TheSQLGuru (6/5/2012)
June 5, 2012 at 8:48 pm
You guys and gals please let me know if I need to weigh in with a definitive declaration about how this system should be indexed. 😀
June 5, 2012 at 5:52 pm
I don't have the bandwidth to blow out a big factinternetsales table, but note the following:
1) indexes can change a plan - and sometimes the change may be for the...
June 4, 2012 at 7:36 am
GilaMonster (5/30/2012)
GilaMonster (5/30/2012)
May I suggest that you consider getting someone (a consultant good at optimisation) to redesign and tune the DB?
Agreed. The complexity of this one alone goes way...
May 31, 2012 at 8:02 am
1) Nothing personal, but I ALWAYS question when someone says "indexes are set properly" or something similar.
2) How many rows match > @TranID?
3) Have you checked for massive...
May 31, 2012 at 7:58 am
Viewing 15 posts - 2,896 through 2,910 (of 5,843 total)