Forum Replies Created

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

  • RE: SQL jobs Dead Locks Issue

    Post the deadlock graph please.

    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 3, 2012 at 4:16 pm

    #1468566

  • RE: Syntax help on how to change a column from asc to desc?

    I'm not talking about a performance improvement from the use of the RANK. Have you seen and verified a performance improvement solely from changing the column in the index from...

    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 3, 2012 at 2:26 pm

    #1468522

  • RE: Point in Time recovery of data between times

    Lynn Pettis (4/3/2012)

    Take a t-log backup, restore the last full backup to another server, then load all t-log backups using the STOPAT clause on the last t-log to recover 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 3, 2012 at 2:14 pm

    #1468513

  • RE: Syntax help on how to change a column from asc to desc?

    D-SQL (4/3/2012)

    We are changing a few thinks to use RANK and it's going to help our performance by 3 times.

    Are you sure about that? Have you tested and seen a...

    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 3, 2012 at 2:05 pm

    #1468505

  • RE: Syntax help on how to change a column from asc to desc?

    D-SQL (4/3/2012)

    Most of the tables have a composite PK, and usually the last column in the key is EffectiveDate. All tables have an EffectiveDate column but we don’t really use...

    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 3, 2012 at 1:26 pm

    #1468465

  • RE: Syntax help on how to change a column from asc to desc?

    Can you explain in more detail what you're trying to do? Columns by themselves don't have an ascending or descending property.

    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 3, 2012 at 12:45 pm

    #1468427

  • RE: Point in Time recovery of data between times

    As Lynn said:

    If you lost the mdf/ndf file(s) but still had access to the ldf (t-log) file, you could complete a tail log backup and recover the data up 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 3, 2012 at 12:27 pm

    #1468423

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/3/2012)

    Some people really shouldn't be allowed near SQL Server systems.

    Wasn't me. Haven't been near a real server all day.

    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 3, 2012 at 12:22 pm

    #1468420

  • RE: Catching the culprit!!

    Evil Kraig F (4/3/2012)

    mathew.walters (4/3/2012)

    Evil Kraig, your statement is incorrect, the host_name() function retrieves the host name of the machine making the request, I have used it in the past...

    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 3, 2012 at 11:32 am

    #1468377

  • RE: Query Optimization

    You're unlikely to get much more optimal than a seek on the clustered index.

    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 3, 2012 at 10:48 am

    #1468350

  • RE: Deadlocks keep coming back...

    Well the deadlock is a result of the serialisable isolation level. The select takes locks on a lot of rows, two or more of those can run concurrently that's not...

    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 3, 2012 at 10:44 am

    #1468347

  • RE: Deadlocks keep coming back...

    Can you post all the statements from when the transaction starts to when it commits?

    Is there any particular reason you're running in serialisable isolation 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

    April 3, 2012 at 10:13 am

    #1468331

  • RE: Deadlocks keep coming back...

    What runs before those updates in the transaction?

    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 3, 2012 at 9:11 am

    #1468287

  • RE: Correcting bad autogrowth settings

    There are tools that claim to be able to defrag files while open. Some even can do what they claim. However if you use one and it's not written 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 3, 2012 at 9:05 am

    #1468280

  • RE: Database in Suspect mode with error in recovery phase

    gupta.rohit (4/3/2012)

    GilaMonster (4/3/2012)

    The only repair level that is supported in emergency mode is repair_allow_data_loss

    I recommend restoring from backup, I highly doubt that is repairable seeing as the error is on...

    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 3, 2012 at 8:59 am

    #1468277

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