Forum Replies Created

Viewing 15 posts - 42,331 through 42,345 (of 49,552 total)

  • RE: Transactions Question

    To demonstrate:

    Create table #Errors (id int primary key)

    set nocount on

    go

    -- testing pk violation

    insert into #Errors values(1)

    insert into #Errors values(1)

    print 'pk error thrown'

    go

    -- testing conversion

    insert into #Errors values ('abc')

    print 'conversion 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

    December 16, 2008 at 10:48 am

    #913332

  • RE: Transactions Question

    RBarryYoung (12/16/2008)

    IIRC, if the severity is 16 or greater, and there is no error-handling, then the session is terminated and any outstanding transactions are rolled back.

    If the severity is 15...

    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

    December 16, 2008 at 10:26 am

    #913310

  • RE: Transactions Question

    hawg (12/16/2008)

    He asked what would happen if an error occurred within the transaction without error handling.

    Depends on the error. There are three kinds of errors in SQL. Statement...

    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

    December 16, 2008 at 10:24 am

    #913307

  • RE: SQL 2005 write performance

    leonp (12/16/2008)

    Gail,

    I guess I would want to know about all 3 - memory/disk performance analysis, advice on app and the disk layout (per your convenience).

    Then you're going to have 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

    December 16, 2008 at 9:33 am

    #913254

  • RE: Are the posted questions getting worse?

    Here's another one that needs some help in asking questions. Not a twit, I just don't think he knows what he's after.

    http://www.sqlservercentral.com/Forums/Topic620018-360-1.aspx

    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

    December 16, 2008 at 9:15 am

    #913237

  • RE: SQL 2005 write performance

    leonp (12/16/2008)

    I was just hoping someone took a look at my post and told me what they thought about my problem.

    I'm still not getting what you want.

    All 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

    December 16, 2008 at 8:22 am

    #913180

  • RE: SQL 2005 write performance

    leonp (12/16/2008)

    Was there anything I could have done better to have some one reply?

    I'm not quite sure what you're asking.

    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

    December 16, 2008 at 7:59 am

    #913157

  • RE: Are the posted questions getting worse?

    Grant Fritchey (12/16/2008)

    I actually said to one parent after giving their baton twirling, uh, I mean bo handling, son a low score, "You do know that this is meant 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

    December 16, 2008 at 7:55 am

    #913154

  • RE: SQL Server 2005 SP3

    Also note that the kb article mentioned (and the public url is http://support.microsoft.com/kb/960828/ as not everyone has access to the premier site) is not available at this point.

    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

    December 16, 2008 at 7:38 am

    #913142

  • RE: Trigger and data type

    Asked and partially answered here - http://www.sqlservercentral.com/Forums/FindPost620292.aspx

    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

    December 16, 2008 at 7:37 am

    #913140

  • RE: what is difference between restore and recovery?

    redwinec (12/16/2008)

    Also, recovery allow you go place the database to a point in time.

    That's restore, not recovery. You can, using tran lock backups, restore a database to a point...

    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

    December 16, 2008 at 7:35 am

    #913136

  • RE: Index Seek Vs Index Scan

    Amit Garg (5/12/2006)

    I am looking for some documentation on how to frame a query so that it uses Index seek rather than Indes scan. Exactly how dose SQL Server decides...

    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

    December 16, 2008 at 4:47 am

    #913050

  • RE: The BackUP of the file Group of file is not permitted

    suresh.maddali (12/16/2008)

    I am NEW FOR DBA Please how do i know which files or filegroups are in online?

    No need to repeat yourself... Is there a senior DBA there?

    Query sys.database_files for...

    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

    December 16, 2008 at 4:40 am

    #913044

  • RE: SQL Server 2005 SP3

    It's back. No explanation though. Maybe when the guys in Redmond wake up.

    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

    December 16, 2008 at 4:10 am

    #913033

  • RE: The BackUP of the file Group of file is not permitted

    suresh.maddali (12/16/2008)

    yes database is online....

    Are all the filegroups in the database online and readable?

    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

    December 16, 2008 at 3:26 am

    #913014

Viewing 15 posts - 42,331 through 42,345 (of 49,552 total)