Forum Replies Created

Viewing 15 posts - 7,891 through 7,905 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (9/10/2014)

    GilaMonster (9/10/2014)

    Stefan Krzywicki (9/10/2014)

    Date columns as a varchar(7). What are you even putting in there? Still better than the date columns as Timestamp I guess.

    Well, months have no...

    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

    September 10, 2014 at 10:03 am

    #1744486

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (9/10/2014)

    Date columns as a varchar(7). What are you even putting in there? Still better than the date columns as Timestamp I guess.

    Well, months have no more than 31...

    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

    September 10, 2014 at 9:06 am

    #1744455

  • RE: Rebuild index and update statistics.

    dinsab11 (9/10/2014)

    I have rebuild index job setup every week. Questions:

    1. Do I need to run update statistics?

    You don't have to, but it's a damn good idea. Column statistics...

    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

    September 10, 2014 at 9:04 am

    #1744454

  • RE: Need help with performance issue with a script

    Statistics would be the next thing to check. After that, the execution plan. After that, whatever the execution plan shows.

    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

    September 10, 2014 at 8:40 am

    #1744444

  • RE: Log Shipping destination stuck on "restoring..."

    A log shipping secondary is supposed to be in the restoring state.

    If it wasn't, then further log backups wouldn't able to be restored and the log shipping would be...

    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

    September 10, 2014 at 7:44 am

    #1744427

  • RE: How to create a variable in select query and use it in the where clause to pass the paramaeter

    What error?

    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

    September 10, 2014 at 4:34 am

    #1744376

  • RE: Deadlock file location

    Don't use traceflag 1204 on SQL Server 2005 or above. If you want to use a deadlock traceflag, use 1222. But in SQL 2012 you don't need to use either...

    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

    September 10, 2014 at 4:29 am

    #1744371

  • RE: Reduce locking for Insert statement?

    Kinda hard without more information.

    From the looks of that code, it should take single-row locks on the two tables (locking the inserted rows) and hold them until the end of...

    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

    September 10, 2014 at 3:49 am

    #1744358

  • RE: When we need to use SET XACT_ABORT ON in Sql server procedures?

    kbhanu15 (9/10/2014)

    My question is

    1. When we will use SET XACT_ABORT ON in my procedures ?

    a)if we have transactions in our proc then ...

    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

    September 10, 2014 at 3:46 am

    #1744356

  • RE: When we need to use SET XACT_ABORT ON in Sql server procedures?

    In short, if you don't have explicit transactions (BEGIN TRANSACTION ...), there's no reason to have xact abort on. Xact abort defines whether an explicit or implicit transaction rolls back...

    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

    September 9, 2014 at 8:01 am

    #1744138

  • RE: How to see my previous ask questions on this website?

    Above the blue bar with the forum name is a series of links. The last one "My Posts" will show you all of your posts.

    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

    September 9, 2014 at 7:55 am

    #1744133

  • RE: When we need to use SET XACT_ABORT ON in Sql server procedures?

    Eirikur Eiriksson (9/9/2014)

    The procedure is either in an explicit or an implicit transaction, if the transaction isn't set explicitly by BEGIN TRANSACTION, it will be set automatically as an implicit...

    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

    September 9, 2014 at 7:52 am

    #1744130

  • RE: Concurrent Stored Procedures

    pgmoschetti (9/9/2014)

    - the four SQLExec are issued on four different threads

    Then they will be run in parallel because SQL will just see 4 connections and 4 separate requests

    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

    September 9, 2014 at 7:48 am

    #1744129

  • RE: Lock Escalation in Sql Server 2014

    skavijay (9/8/2014)

    But after knowing this disable option just want to know expert opinion whether that might helpful to me or not?

    No idea at all, because you haven't given any information...

    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

    September 9, 2014 at 4:38 am

    #1744067

  • RE: Bad storage array? Corruption?

    Can you try running a checkDB with Tablock (will need exclusive access)?

    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

    September 8, 2014 at 9:29 am

    #1743900

Viewing 15 posts - 7,891 through 7,905 (of 49,552 total)