Forum Replies Created

Viewing 15 posts - 20,011 through 20,025 (of 49,552 total)

  • RE: Erratic SP Performance

    Ouch.

    So tempDB is reaching almost 500MB in 1MB chunks (well, to start with). Not pretty. Set the default size of TempDB to something in the general vecinity of 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

    February 29, 2012 at 10:19 am

    #1453291

  • RE: SQL Server Agent Job execution order

    A step has to complete totally before the step is complete and the next one can start.

    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

    February 29, 2012 at 6:51 am

    #1453134

  • RE: how to use syscomments table

    Don't. Use sys.sql_modules.

    syscomments has been deprecated for 7 years.

    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

    February 29, 2012 at 6:17 am

    #1453120

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (2/29/2012)

    Koen Verbeeck (2/28/2012)

    Some try to add my to their LinkedIn network with "Person X has indicated that you are a Friend". Euh.... no.

    That one is annoying me.

    Likewise....

    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

    February 29, 2012 at 6:15 am

    #1453117

  • RE: Can locks in a table block other tables

    sqlnaive (2/29/2012)

    If you have turned both of those off, the only lock that can be taken is a full table lock, so if SQL even wants one row in 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

    February 29, 2012 at 6:14 am

    #1453116

  • RE: What happen when any user has taken .trn backup from primary database during the processing of the log shipping ?

    You should be able to, yes. Straightforward, standard restore of the differential with either norecovery or standby, whichever you are using for the log shipping.

    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

    February 29, 2012 at 6:13 am

    #1453115

  • RE: Deadlock - What does KEY: 5:72057594047561728 (d100894c8261)"

    Yup, that's pretty much what I would have suggested.

    Appropriate index means less reads so less locks and less duration to the locks to be held.

    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

    February 29, 2012 at 6:11 am

    #1453113

  • RE: New Version of sqlserver

    Gianluca Sartori (2/29/2012)

    GilaMonster (2/29/2012)

    Gianluca Sartori (2/29/2012)

    SQL Server 2012 will be out in some days.

    The marketing launch event is in a couple of days. Availability of the bits, probably not so...

    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

    February 29, 2012 at 2:12 am

    #1452983

  • RE: Are the posted questions getting worse?

    There are some fun easter eggs. He'll be UDP Broadcaster in a sec iirc. (1434)

    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

    February 29, 2012 at 2:10 am

    #1452979

  • RE: Can locks in a table block other tables

    Jayanth_Kurup (2/29/2012)

    @Gail , what if we use a lock hint ?

    What do your tests say?

    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

    February 29, 2012 at 2:09 am

    #1452978

  • RE: New Version of sqlserver

    Gianluca Sartori (2/29/2012)

    SQL Server 2012 will be out in some days.

    The marketing launch event is in a couple of days. Availability of the bits, probably not so much.

    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

    February 29, 2012 at 1:54 am

    #1452968

  • RE: Can locks in a table block other tables

    sqlnaive (2/29/2012)

    I found that in primary index ALLOW_ROW_LOCKS and ALLOW_PAGE_LOCKS were ON. Now that I have put it off there is no blocking at all.

    So on most frequently used...

    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

    February 29, 2012 at 1:52 am

    #1452967

  • RE: Deadlock - What does KEY: 5:72057594047561728 (d100894c8261)"

    KEY is the type of lock being taken, it's a key lock, so a lock on an index row

    5 is the database id

    72057594047561728 is the partition id, a pointer 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

    February 29, 2012 at 1:51 am

    #1452964

  • RE: Need answers for interview questions...

    Jayanth_Kurup (2/29/2012)

    To the others, I was wondering if we all would have been a bit more helpful if the questions were posted one at a time under a heading other...

    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

    February 29, 2012 at 12:58 am

    #1452939

  • RE: Need answers for interview questions...

    Jeff Moden (2/28/2012)

    satishm94 (2/28/2012)

    Hi.

    actually i have 70 questions with me and i googled everything and foundout the answers..

    and

    i did found answers for some of the questions i posted but 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

    February 29, 2012 at 12:54 am

    #1452938

Viewing 15 posts - 20,011 through 20,025 (of 49,552 total)