Forum Replies Created

Viewing 15 posts - 26,806 through 26,820 (of 49,552 total)

  • RE: DBCC CheckDB runs slow, doesn't seem to use TempDB, and waits on RESOURCE_SEMAPHORE

    CheckDB doesn't use TempDB except for indexed view checks. It creates a database snapshot and checks that. No locks unless you specify WITH TABLOCK

    Often an increased duration means it's found...

    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

    April 8, 2011 at 3:23 pm

    #1309454

  • RE: Deadlocks from MSIS account

    Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.

    DBCC TRACEON(1222,-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

    April 8, 2011 at 1:50 pm

    #1309388

  • RE: Very Slow Lookup on Primary Key (Clustered)

    Tom West (4/8/2011)

    Looking at the execution plan, the primary key scan on the 1st query brings back 10 records, but the second query brings back 57 million.

    I'm guessing...

    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

    April 8, 2011 at 9:14 am

    #1309241

  • RE: Copy over database to a new server

    Huh?

    2 days to detach and attach? They're both near instant operations. Do you mean 2 days to copy?

    That must be one really large DB. A 1.2 TB DB that I...

    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

    April 8, 2011 at 9:09 am

    #1309240

  • RE: Copy over database to a new server

    Backup, restore.

    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

    April 8, 2011 at 8:41 am

    #1309222

  • RE: logical_reads

    Does just the select portion run to completion (run it from SSMS)? If so, post the execution plan and IO statistics (SET STATISTICS IO ON). If not, post the estimated...

    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

    April 8, 2011 at 8:39 am

    #1309220

  • RE: It's possible to repair a master.mdf with another sql instance or SQLServer??

    Madness.

    Repairing master (even a copied master) is unlikely to work. Most of master are system objects (all of master should be) and if there's something wrong severe enough to prevent...

    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

    April 8, 2011 at 12:23 am

    #1308983

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/7/2011)

    GilaMonster (4/7/2011)

    GSquared (4/7/2011)

    Wayne, it was a good question (should I be smug that I got it right, or just ... nah ... I'll be smug about it).

    San's making the...

    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

    April 7, 2011 at 12:53 pm

    #1308776

  • RE: Are the posted questions getting worse?

    GSquared (4/7/2011)

    Wayne, it was a good question (should I be smug that I got it right, or just ... nah ... I'll be smug about it).

    San's making the classical mistake...

    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

    April 7, 2011 at 12:30 pm

    #1308757

  • RE: Builtin\Administrators and Local Admin

    If builtin\Admins is a login and sysadmin, all local and domain admins are sysadmin. Remove it, just make sure you have another administrative login first.

    If it makes you feel better,...

    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

    April 7, 2011 at 11:33 am

    #1308712

  • RE: Logged Operations

    CirquedeSQLeil (4/7/2011)

    D'oh. See I'm still learning. Can we call it moderately but not heavily logged? 😀

    You can call it anything you like. :hehe:

    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

    April 7, 2011 at 11:06 am

    #1308696

  • RE: Are the posted questions getting worse?

    WayneS (4/7/2011)

    GilaMonster (4/7/2011)

    WayneS (4/7/2011)

    I'm surprised that all of the options had some answers, and that only 10% have correct answers. The griping seems to be coming from those looking 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

    April 7, 2011 at 10:54 am

    #1308684

  • RE: Logged Operations

    CirquedeSQLeil (4/7/2011)

    I knew table variables and truncates were minimally logged and thought version store was too. I learned something new.:-D

    Table variables aren't minimally logged. They are fully...

    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

    April 7, 2011 at 10:52 am

    #1308680

  • RE: Are the posted questions getting worse?

    WayneS (4/7/2011)

    I'm surprised that all of the options had some answers, and that only 10% have correct answers. The griping seems to be coming from those looking to bash the...

    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

    April 7, 2011 at 10:42 am

    #1308674

  • RE: Logged Operations

    Bill Sheets (4/7/2011)

    Are inserts into a table variable really logged?

    Yup, absolutely, as proven here: http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/

    It doesn't look like it to me. I guess you can say that...

    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

    April 7, 2011 at 10:40 am

    #1308671

Viewing 15 posts - 26,806 through 26,820 (of 49,552 total)