Forum Replies Created

Viewing 15 posts - 31,381 through 31,395 (of 49,552 total)

  • RE: Recover data of a Dropped Table

    Please note: Year old thread.

    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

    August 6, 2010 at 2:30 pm

    #1203789

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (8/6/2010)

    I am in the middle of an issue you just described. IT and the business were at extreme odds when I was hired here. The business didn't...

    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

    August 6, 2010 at 2:30 pm

    #1203788

  • RE: Cumulative or Current - sys.dm_io_virtual_file_stats

    Cumulative since (I believe) the file was opened

    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

    August 6, 2010 at 2:25 pm

    #1203786

  • RE: SQL SErver Query Plans

    Cross apply to sys.dm_exec_query_plan to get the XML. Could be set options were different.

    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

    August 6, 2010 at 2:25 pm

    #1203785

  • RE: Bizarre execution plan issue...

    Swirl80 (8/6/2010)

    Yes you can get a plan as i also stated in my original post that i can get one if i drop and create the procedure again but after...

    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

    August 6, 2010 at 8:12 am

    #1203541

  • RE: Restore to new column lenght

    smitty-1088185 (8/6/2010)

    My college professor told me that the varchar data type doesn't take up disk space but it does affect memory allocation. Is that not true?

    No. Pages in memory...

    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

    August 6, 2010 at 8:08 am

    #1203540

  • RE: Are the posted questions getting worse?

    Whispers.

    What are circus peanuts?

    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

    August 6, 2010 at 6:42 am

    #1203456

  • RE: Curiosity

    sivaprasad (8/6/2010)

    3. Corrects pages and row count inaccuracies in the catalog views

    DBCC UPDATEUSAGE(dbname,"tablename")

    Not needed on SQL 2008. There were errors in the algorithms...

    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

    August 6, 2010 at 6:41 am

    #1203454

  • RE: How to find the values that are passed to the parameters of a stored procedure which participates in deadlock

    Grant Fritchey (8/6/2010)

    If you're experiencing lots of deadlocks, usually, it's your TSQL code.

    Or your indexes. Or both.

    If what you mean is single column indexes on each column, that's far...

    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

    August 6, 2010 at 6:40 am

    #1203453

  • RE: Reindexing and truncate

    If the data is growing, you're going to either need to archive and delete data or provide more disk space. Shrink isn't compression. It's not going to reduce the size...

    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

    August 6, 2010 at 5:00 am

    #1203386

  • RE: Performance Issue in Insert Values

    Brandie Tarvin (8/6/2010)

    GilaMonster (8/6/2010)

    Not permitted (except row overflow of variable-length data types). A row must be on a single page, that's why there's the 8060 byte limit on the size...

    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

    August 6, 2010 at 4:59 am

    #1203383

  • RE: Reindexing and truncate

    Why do you need to reduce the size of the DB?

    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

    August 6, 2010 at 4:49 am

    #1203379

  • RE: Reindexing and truncate

    No, no, no! Don't regularly shrink your database. You're hurting performance for no good reason. Databases grow. It's normal. It's expected. Shrinking them is just going to force a grow...

    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

    August 6, 2010 at 4:39 am

    #1203373

  • RE: Performance Issue in Insert Values

    Brandie Tarvin (8/6/2010)

    I have to wonder how many times a single record is split because not all the data will fit on a page.

    Not permitted (except row overflow of variable-length...

    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

    August 6, 2010 at 4:35 am

    #1203369

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (8/6/2010)

    GilaMonster (8/6/2010)

    Jack Corbett (8/5/2010)

    AHHHHHH! You said a swear word!!! Access.

    There's nothing wrong with Access when used appropriately. The problem is it's seldom used appropriately.

    Access is often a trojan...

    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

    August 6, 2010 at 4:20 am

    #1203352

Viewing 15 posts - 31,381 through 31,395 (of 49,552 total)