Forum Replies Created

Viewing 15 posts - 14,071 through 14,085 (of 49,552 total)

  • RE: Can't Kill SPID “Transaction Rollback in Progress”

    Welsh Corgi (3/3/2013)

    I like the following.

    sysprocesses is deprecated, will be removed in a future version and should not be used. Use sys.dm_exec_requests, sys.dm_exec_sessions and sys.dm_exec_connections instead.

    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

    March 3, 2013 at 10:51 am

    #1592776

  • RE: unexplained deadlock

    aviadavi (3/3/2013)

    I'm using NOLOCK because integrity is not that important for me and again - I want good timing and i want to avoid potential deadlock by not locking 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

    March 3, 2013 at 10:20 am

    #1592772

  • RE: Can't Kill SPID “Transaction Rollback in Progress”

    Welsh Corgi (3/3/2013)

    I certainly could Google Blocking Chains but do you know of a good article? I know you are probably the author. 🙂

    Yes, you could google it. Right now...

    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

    March 3, 2013 at 10:11 am

    #1592770

  • RE: Can't Kill SPID “Transaction Rollback in Progress”

    Welsh Corgi (3/3/2013)

    I have blocking going on between 2 different developers.

    The blocking has been going on for nearly an hour.

    I would have thought that there would have been a deadlock...

    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

    March 3, 2013 at 9:36 am

    #1592766

  • RE: partition_id VS. hobt_id

    They're the same thing. They were added as separate columns to support a feature that was planned, partially added to SQL 2005 and later scrapped.

    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

    March 3, 2013 at 8:17 am

    #1592755

  • RE: Confusion regarding which full-backup file to apply on secondary in Log shipping

    Require, no. Full and log can restore to a point in time. There are advantages and disadvantages to differentials, there are many places where they are useful.

    Consider, for example, 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

    March 3, 2013 at 8:10 am

    #1592753

  • RE: even and odd records

    mehta.saurabhj (3/2/2013)

    GilaMonster (3/2/2013)

    For SQL Server, this works as expected (as long as good performance isn't expected).

    CREATE TABLE student ( name VARCHAR(20), age INT );

    INSERT INTO student

    VALUES ( 'ram',...

    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

    March 3, 2013 at 1:37 am

    #1592734

  • RE: Suspect mode error

    Corruption most likely, meaning something wrong with the IO subsystem. Can't say more without more info.

    btw, checkDB is the last resort for fixing suspect databases, you should rather have restored...

    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

    March 2, 2013 at 1:48 pm

    #1592713

  • RE: even and odd records

    For SQL Server, this works as expected (as long as good performance isn't expected).

    CREATE TABLE student ( name VARCHAR(20), age INT );

    INSERT INTO student

    VALUES ( 'ram', 12 );

    INSERT...

    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

    March 2, 2013 at 12:07 pm

    #1592701

  • RE: even and odd records

    Lynn Pettis (3/2/2013)

    mehta.saurabhj (3/2/2013)

    The sql code to find odd number of records is:

    select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp);

    But if I do the foll code...

    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

    March 2, 2013 at 12:04 pm

    #1592700

  • RE: Confusion regarding which full-backup file to apply on secondary in Log shipping

    anoop.mig29 (3/2/2013)

    And as per my knowledge log transactions are dependent one full database backup files and for in that case LSN number is important.

    Not true.

    Differential backups are dependent 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

    March 2, 2013 at 6:06 am

    #1592669

  • RE: Database in Recovery mode while restoring it

    What exactly, step by step, did you do to that DB?

    Recovery is the last phase of a restore, but I've never seen the state change before.

    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

    March 2, 2013 at 2:38 am

    #1592662

  • RE: Kill alter Index rebuild Jobs

    mickdunde (3/1/2013)

    The affected database is part of a database mirror and therefore in full recovery mode, also edition is standard, so no online rebuild for me. At the moment there...

    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

    March 1, 2013 at 1:51 pm

    #1592566

  • RE: how does sql read tempdb multiple .ldf files

    Multiple tempDB data files with limited growth isn't a bad thing, as long as the total size is enough for the app and as long as all files are 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

    March 1, 2013 at 1:16 pm

    #1592549

  • RE: does index also change the output?

    opc.three (3/1/2013)

    @Gail, In thinking about this a little more, I think the example I gave is just a roundabout way of asking for TOP 1 without an ORDER BY, which...

    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

    March 1, 2013 at 11:48 am

    #1592519

Viewing 15 posts - 14,071 through 14,085 (of 49,552 total)