Forum Replies Created

Viewing 15 posts - 76 through 90 (of 144 total)

  • RE: Too many statistics

    i think you are thinking other way around , PK provide clustred index by default , so while thinking abt PK you should think abt uniqueness of records. then next...


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 29, 2012 at 8:12 am

    #1563813

  • RE: Too many statistics

    Personally I prefer just eyeballing it. Far less effort and more accurate.

    :Wow:

    I've been eyeballing for a good hour now. Even tried tilting my head an closing one eye for a...


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 29, 2012 at 7:42 am

    #1563780

  • RE: Are the posted questions getting worse?

    @Koen Verbeeck

    Mooi man! Good job! Nice read!


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 29, 2012 at 6:04 am

    #1563721

  • RE: Too many statistics

    Ahhh, the dreaded but expected "Depends". :hehe:

    How does one find duplicate statistics?

    I've got a basic start.

    SELECTOBJECT_NAME(S.[OBJECT_ID]), S.Name, SC.*

    FROMSys.Stats S

    JOIN sys.Stats_Columns SC

    ON S.Stats_ID = SC.Stats_ID

    AND S.[Object_ID] = SC.[Object_ID]

    JOIN sys.Columns C

    ON...


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 29, 2012 at 5:24 am

    #1563687

  • RE: Too many statistics

    Thanks for replying.

    So having so many statistics on a table with (36 cols) is normal or at least not unusual?

    No bloat or overhead involved?

    As for the PK, one of the...


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 29, 2012 at 2:24 am

    #1563612

  • RE: Conversion of DTS 2000 Packages to SSIS Pcakages in SQL 2008

    Have you searched at all yourself?

    Try googling "SQL migrate 2000 dts to SSIS"


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 27, 2012 at 8:43 am

    #1562724

  • RE: How to create a marker field based on data

    Wow Sean,

    10 points for effort and patience!


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 27, 2012 at 8:37 am

    #1562718

  • RE: Specify multiple file extensions in maintenance cleanup task

    You don't have to specify an age and you can execute the job immediately.


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 27, 2012 at 8:13 am

    #1562703

  • RE: Specify multiple file extensions in maintenance cleanup task

    I just tried it. Took about 5 mins. 😛


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 27, 2012 at 7:57 am

    #1562697

  • RE: Specify multiple file extensions in maintenance cleanup task

    A task for each type.


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 27, 2012 at 7:57 am

    #1562695

  • RE: Huge difference for same operator in different environment

    Are the phyical file locations the same?

    TempDB and user DBs on different spindles?

    RAID and disks all ok?

    Does your QA enviroment have other instances or DBs sharing the resources?


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 27, 2012 at 7:38 am

    #1562684

  • RE: Backup strategy for replicated DBs

    We'll be making the move to 2012 and availibility groups sometime next year. Hopefully i'll get a 2012 dev environment well before crunch time.

    Thanks for your input! 🙂


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 26, 2012 at 8:08 am

    #1562247

  • RE: Backup strategy for replicated DBs

    Hi Grant,

    Thanks for taking the time to share!!

    Have you ever had to restore a published DB? Did/would you generate the scripts (Via the GUI) for the publications just prior to...


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 26, 2012 at 7:32 am

    #1562235

  • RE: Today's Random Word!

    Third Sleeve


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 23, 2012 at 7:19 am

    #1561868

  • RE: Error in insert query

    Your statement says that you want to enter data into 3 columns, but you are only providing data for 2 columns.

    Because you are using an IDENTITY, then you don't need...


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

    November 23, 2012 at 6:42 am

    #1561861

Viewing 15 posts - 76 through 90 (of 144 total)