Forum Replies Created

Viewing 15 posts - 4,711 through 4,725 (of 5,841 total)

  • RE: Writing Dynamic Stored Procedure

    Steve Jones - Editor (6/1/2009)

    TheSQLGuru (6/1/2009)

    Believe it or not Steve I have had not one but TWO hiring managers tell me in the last few months that my rate was...

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

    June 1, 2009 at 1:57 pm

    #1003008

  • RE: Writing Dynamic Stored Procedure

    Chris Harshman (6/1/2009)

    TheSQLGuru (6/1/2009)

    1) if you don't have indexes on fields that you are searching for then you have bigger problems than writing bad code.

    2) If you are...

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

    June 1, 2009 at 12:32 pm

    #1002964

  • RE: Writing Dynamic Stored Procedure

    Noel McKinney (6/1/2009)

    Chris Harshman (6/1/2009)

    With everyone getting into their religious entrenched positions ...

    So far it isn't too religious, nobody has brought up parameter sniffing yet.

    Actually I did in my "Time...

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

    June 1, 2009 at 9:36 am

    #1002848

  • RE: Writing Dynamic Stored Procedure

    Chris Harshman (6/1/2009)

    With everyone getting into their religious entrenched positions on what way is the “best” way to handle this, I think we all need to take a step back...

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

    June 1, 2009 at 9:12 am

    #1002821

  • RE: Writing Dynamic Stored Procedure

    Steve Jones - Editor (6/1/2009)

    I'm not a big fan of dynamic SQL, actually I hate it, but we try to present multiple points of view, and this is not a...

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

    June 1, 2009 at 8:49 am

    #1002805

  • RE: Writing Dynamic Stored Procedure

    Personally I hope lots of people keep on doing this because due to the staggeringly-horrible performance this type of query can have there will be more opportunities for me to...

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

    June 1, 2009 at 6:25 am

    #1002692

  • RE: TempDB and SQL Error 845

    Uncle Moki (5/28/2009)

    GilaMonster (5/28/2009)

    I'd be quite willing to bet that the problem will be back next month.

    In a way, I hope you are right....even if only in the name...

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

    May 29, 2009 at 10:09 am

    #1002157

  • RE: Query Timeout

    Topical and timely words to the wise from Bart Duncan (someone who REALLY knows what is going on with SQL Server) and isn't just a pretender like myself! :w00t:

    http://blogs.msdn.com/bartd/archive/2009/05/03/sometimes-the-simplest-solution-isn-t-the-best-solution-the-all-in-one-search-query.aspx

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

    May 27, 2009 at 2:07 pm

    #1000984

  • RE: Query Timeout

    Short-circuiting in this case has nothing to do with a programming language but rather how the sql query optimizer was coded. If it was designed/programmed to do short-circuiting then...

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

    May 27, 2009 at 10:07 am

    #1000786

  • RE: Query Timeout

    GilaMonster (5/22/2009)

    TheSQLGuru (5/21/2009)

    I do not often waste my time coming up with such permutations as you did (or solving them) that are not relevant to the post. ...

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

    May 22, 2009 at 11:24 am

    #999037

  • RE: Query Timeout

    Gianluca Sartori (5/21/2009)

    Thinking on the performance side, I can only agree with you, but you can't forget that performance is just one of the qualitites of a good software: what...

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

    May 21, 2009 at 11:42 am

    #998433

  • RE: Query Timeout

    ORIGINAL CODE:

    select distinct @Result = sum( column1 )

    from table (nolock)

    where ((column2 = @param1) or (@param1 = 0))

    1) why do you have distinct? you are doing a SUM, which can...

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

    May 21, 2009 at 9:35 am

    #998359

  • RE: SQL Server grabbing memory well beyond limit set in Max Memory

    Amy Russell (5/19/2009)

    We are definitely experiencing performance problems because the lack of memory for everything else on that box (backup, AV, etc.) causes the OS to page SQL Server out...

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

    May 19, 2009 at 4:44 pm

    #997310

  • RE: What solution for 30 million users

    As an independent consultant (and knowing that you are newly so), let me paraphrase Robert Duvall in "Apocalypse Now": I love the smell of a train wreck in the...

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

    May 19, 2009 at 9:20 am

    #997094

  • RE: What solution for 30 million users

    GilaMonster (5/19/2009)

    Chris (5/19/2009)

    Forgive me if I'm stating the obvious, but I suspect this was an interview question/homework assignment rather than a "real" problem.

    I almost hope it is.

    I wish it wasn't...

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

    May 19, 2009 at 7:53 am

    #996974

Viewing 15 posts - 4,711 through 4,725 (of 5,841 total)