Forum Replies Created

Viewing 15 posts - 4,366 through 4,380 (of 5,841 total)

  • RE: Included colums when creating INDEXES.

    I want to add that you should be VERY careful about just implementing all of what the missing index DMVs or DTA give you!! They LOVE to include columns...

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

    November 24, 2009 at 7:31 am

    #1083446

  • RE: Transaction log gorwing tremendously

    2 thoughts:

    Boy, if I had a dollar for every time someone has done this . . . 🙂

    There are so many companies out there using SQL...

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

    November 24, 2009 at 7:27 am

    #1083443

  • RE: Your recent challenge?!

    2 years ago I had a client running year end tax stuff (payroll processing client) against 4900 or so databases on a single server (which was manually report shipped from...

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

    November 24, 2009 at 7:25 am

    #1083441

  • RE: High CPU

    bell282 (11/18/2009)

    well, made some progress.. We have a table with about 300,000 records (and one of the columns is an image)... If we delete all the records out...

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

    November 23, 2009 at 8:03 am

    #1082948

  • RE: SQL Server Deep Dives book, I bought...and you?

    Picked mine up while at PASS recently.

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

    November 23, 2009 at 7:22 am

    #1082927

  • RE: MERGE or not to MERGE

    Dave Ballantyne (11/20/2009)

    TheSQLGuru (11/16/2009)

    Peso-284236 (11/15/2009)

    This may also be useful to know

    http://weblogs.sqlteam.com/peterl/archive/2008/11/24/SQL-Server-2008-with-MERGE-and-triggers.aspx

    I think the trigger issue has the potential to zap a lot of unsuspecting MERGE users.

    Seems a bit...

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

    November 21, 2009 at 9:35 am

    #1082654

  • RE: REPLACE Multiple Spaces with One

    C#Screw: I would check the query plans for each. I wouldn't be surprised that the non-function method uses a scan-based plan thus less IO but longer time while...

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

    November 21, 2009 at 9:33 am

    #1082653

  • RE: Reasonable performance?

    Hey Lynn - CONGRATS ON PASSING THE 10000 POINT MARK!!!! :w00t:

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

    November 21, 2009 at 8:59 am

    #1082648

  • RE: Large Number of Tables (1,090,000)

    Hardware is probably the only viable solution here. Lots of RAM will help to keep more pages of data in cache, but that will not get you very far...

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

    November 21, 2009 at 8:54 am

    #1082647

  • RE: User table-Valued Functions

    MTY-1082557 (11/20/2009)

    In my case I always use Var tables for small amout of data..

    Thank you for the note

    This is not necessarily a good thing. You can have a...

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

    November 21, 2009 at 8:39 am

    #1082646

  • RE: REPLACE Multiple Spaces with One

    Can anyone comfirm if CPU, IO, etc information is accurately tracked and reported via the referenced DMVs when CLR stuff is being executed??

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

    November 20, 2009 at 1:22 pm

    #1082462

  • RE: REPLACE Multiple Spaces with One

    Paul White (11/19/2009)

    Paul White (11/19/2009)

    I must admit I am less than clear how sort order affects nested REPLACEs, but at least REPLACE is documented as being collation-aware so there is...

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

    November 19, 2009 at 4:36 pm

    #1081899

  • RE: Introduction to Indexes

    Douglas Osborne-456728 (11/19/2009)

    Gail,

    I'm pretty sure you haven't answered my question.

    The question is, not is it necessary to have the primary key specified in indexes, but is it redundant?

    Doug

    My vote (although...

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

    November 19, 2009 at 2:17 pm

    #1081853

  • RE: REPLACE Multiple Spaces with One

    I am not sure that blowing out a varchar(4000) conversion for lord knows what is a 'minor plan difference'!! 🙂

    I bet the memory crap is happening for every...

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

    November 19, 2009 at 1:46 pm

    #1081829

  • RE: Introduction to Indexes

    GilaMonster (11/19/2009)

    Do you have queries that filter on the combination of SSN + MyDataID or City + MyDataID?

    p.s. That's a poor choice for a clustered index. See part 2 of...

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

    November 19, 2009 at 1:41 pm

    #1081825

Viewing 15 posts - 4,366 through 4,380 (of 5,841 total)