Forum Replies Created

Viewing 15 posts - 2,896 through 2,910 (of 5,841 total)

  • RE: ALTER INDEX ..... SORT_IN_TEMPDB

    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...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 19, 2012 at 7:43 am

    #1502842

  • RE: Is MERGE always the way to go for upserts?

    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...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 19, 2012 at 7:42 am

    #1502841

  • RE: High Page reads or high Execution time

    Sachin Nandanwar (6/17/2012)

    Hi,

    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...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 19, 2012 at 7:39 am

    #1502838

  • RE: Performance tuning for ORM application for 2008R2 migration

    chris-320654 (6/15/2012)

    I have encouraging news! The CPU powersaving mode was enabled and setting this to High Performance mode did improve performance significantly on the new box.

    Rather than running the app...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 15, 2012 at 9:21 am

    #1501740

  • RE: Cumulative Total

    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...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 14, 2012 at 7:46 am

    #1501011

  • RE: sys.dm_io_virtual_file_stats - doesn't looks like it is cummulative

    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...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 14, 2012 at 7:43 am

    #1501006

  • RE: Table Valued Function for Active Directory group membership

    Dan Price-242213 (6/11/2012)

    I tried implementing a similar function but there seems to be issues with linked server LDAP queries. It was taking a long time to execute the openquery...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 12, 2012 at 7:57 am

    #1499808

  • RE: Memory Utilization Advise

    "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...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 12, 2012 at 7:54 am

    #1499805

  • RE: Total / average function advice

    Jeff Moden (6/5/2012)

    TheSQLGuru (6/5/2012)

    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. ...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 5, 2012 at 8:48 pm

    #1497378

  • RE: Total / average function advice

    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. 😀

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 5, 2012 at 5:52 pm

    #1497355

  • RE: Strange behaviour on Adventure Works DW

    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...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    June 4, 2012 at 7:36 am

    #1496475

  • RE: Perfomance issue with storeprocedure

    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...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 31, 2012 at 8:02 am

    #1495239

  • RE: How to increase performance of the query

    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...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 31, 2012 at 7:58 am

    #1495227

  • RE: identity gaps

    The single best way to "limit the identiy burn outs" is to stop seeding them at 1!! Always start identities at the LOWEST number available for the numeric type...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 31, 2012 at 7:54 am

    #1495224

  • RE: Proc Optimization

    try running sp_whoisactive (freebie from sqlblog.com) while the stuck one is hung. Actually I would run it while you have all the concurrent runs going on. I wonder...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 30, 2012 at 8:39 am

    #1494712

Viewing 15 posts - 2,896 through 2,910 (of 5,841 total)