Forum Replies Created

Viewing 15 posts - 34,471 through 34,485 (of 49,552 total)

  • RE: Database Engine Tuning Wizard recommendation for creating stats

    Ather M (1/23/2010)

    If I will add stats in database is there any disadvantage of that....like if we add indexes...it takes space....it slowing the insertion..... etc

    No, nothing really. Statblobs are very...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 24, 2010 at 12:45 am

    #1107888

  • RE: Database Engine Tuning Wizard recommendation for creating stats

    DTA will usually recommend multi-column stats. SQL will automatically create single column stats only.

    That said, test out all of its recommendations (including the indexes) before making the changes in production....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 23, 2010 at 3:50 pm

    #1107843

  • RE: 0 allocation, 1 consistency error -- repair_rebuild min repair level didn’t fix

    Paul Randal (1/23/2010)

    Definitely 2000. from the CHECKDB error messages.

    I know. Wanted to know the flavour (patch/hotfix level)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 23, 2010 at 3:44 pm

    #1107842

  • RE: 0 allocation, 1 consistency error -- repair_rebuild min repair level didn’t fix

    SELECT @@version

    ?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 23, 2010 at 2:21 pm

    #1107824

  • RE: HUGE Database Update (> 550 million rows)

    Brian.Dunat (1/23/2010)

    This is the proper clustered index and it makes up the primary key on the table. This is a wealth management database, so the data that will be inserted...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 23, 2010 at 10:45 am

    #1107775

  • RE: HUGE Database Update (> 550 million rows)

    Jeff Moden (1/23/2010)

    When you go to reinstate the index, ask yourself, how many times do you insert into this table and will the inserts be done near the logical end...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 23, 2010 at 9:08 am

    #1107765

  • RE: convert varchar to numeric

    Use REPLACE to remove the commas, then use CAST or CONVERT. Alternatively, you could cast first to the Money data type (providing it has sufficient precision) and then cast to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 23, 2010 at 8:03 am

    #1107755

  • RE: convert varchar to numeric

    CAST or CONVERT. See Books Online (the SQL help file) for details.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 23, 2010 at 7:48 am

    #1107752

  • RE: how to get only duplicate rows from table

    malleswarareddy_m (1/23/2010)

    even i tried like this alo but i have unique identifier for a column name benfiaryid in the above result i want show the unqiue identfier for that colmun.iam...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 23, 2010 at 7:46 am

    #1107751

  • RE: HUGE Database Update (> 550 million rows)

    Brian.Dunat (1/22/2010)

    One other thing that I wanted to see if anyone has some knowledge on is doing these updates as part of a bulk update instead of having each update...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 23, 2010 at 7:10 am

    #1107748

  • RE: Finding duplicate row values

    You have a thread for your question already, don't hijack other people's threads.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 23, 2010 at 7:07 am

    #1107747

  • RE: how to get only duplicate rows from table

    Hint:

    A subquery that groups by whatever column 2 is called and does a filter HAVING COUNT(*) > 1

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 23, 2010 at 7:05 am

    #1107746

  • RE: Introduction to Indexes: Part 3 – The nonclustered index

    Glad you liked them

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 23, 2010 at 1:14 am

    #1107715

  • RE: storeproc is not inserting any data!

    That is almost 800 lines of code. Do you really expect people to debug that volume of code without access to the DB or any of the tables references, or...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 23, 2010 at 1:12 am

    #1107714

  • RE: Restore database failure

    I suspect it has to do with that db coming from a beta version of SQL Server 2005. (RTM was 1399, hence 1187 must have been one of the late...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 23, 2010 at 1:11 am

    #1107713

Viewing 15 posts - 34,471 through 34,485 (of 49,552 total)