Forum Replies Created

Viewing 15 posts - 25,771 through 25,785 (of 49,552 total)

  • RE: Transaction Isolation Level examples

    Have you read through the isolation level information in Books Online?

    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

    June 3, 2011 at 3:44 am

    #1333559

  • RE: None of the idenifiers are working in sql server 2008 of below web page.

    Did you check what versions of SQL that kb article applies to?

    From the bottom of the page:

    APPLIES TO

    * Microsoft SQL Server 6.0 Standard Edition

    ...

    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

    June 3, 2011 at 3:43 am

    #1333558

  • RE: What is LOP_BEGIN_XACT

    The log's internal structure and operations are not documented. You'll have to work them out yourself from when they occur and from what little is said in blog 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

    June 3, 2011 at 3:41 am

    #1333557

  • RE: Ghost Records

    Tom.Thomson (6/2/2011)

    I don't like this shiny new terminology introduced for SQL 2008.

    It's not new in 2008. SQL 2000 had ghost records, my guess SQL 7 too since it was 6.5-7...

    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

    June 3, 2011 at 3:17 am

    #1333554

  • RE: Database refuses to auto-increment?? SQL Server Management Studio Express

    talismc (6/2/2011)

    GilaMonster (5/29/2011)

    I appreciate what you're saying Gila Monster, but this isn't the problem that I am having. My code works well and is done accordingly to my clients specifications.

    My...

    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

    June 2, 2011 at 5:35 pm

    #1333489

  • RE: Ghost Records

    SQLRNNR (6/2/2011)

    GilaMonster (6/2/2011)

    SQLRNNR (6/2/2011)

    GilaMonster (6/2/2011)

    cfradenburg (6/2/2011)

    As to why something goes through and cleans up the ghost records instead of just allowing the space get reused, that way the data doesn't...

    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

    June 2, 2011 at 10:50 am

    #1333238

  • RE: is null check in where clause

    Actually, an even better idea...

    Put it in prod and then in 4 or so months call me in to do a performance review... :hehe: :w00t:

    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

    June 2, 2011 at 9:35 am

    #1333187

  • RE: is null check in where clause

    Rich Yarger (6/2/2011)

    I'm going to grab him by the ear to show him your blog. He thinks he is done now and is all happy.

    I have a better idea. Require...

    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

    June 2, 2011 at 9:34 am

    #1333186

  • RE: Ghost Records

    SQLRNNR (6/2/2011)

    GilaMonster (6/2/2011)

    cfradenburg (6/2/2011)

    As to why something goes through and cleans up the ghost records instead of just allowing the space get reused, that way the data doesn't remain 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

    June 2, 2011 at 9:30 am

    #1333178

  • RE: Ghost Records

    cfradenburg (6/2/2011)

    Interesting. What does the ghost cleanup process do then?

    http://www.sqlskills.com/blogs/paul/post/inside-the-storage-engine-ghost-cleanup-in-depth.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

    June 2, 2011 at 9:29 am

    #1333176

  • RE: is null check in where clause

    Rich Yarger (6/2/2011)

    It's funny you mentioned the RECOMPILE option - I asked him about that, but found out that we are using 2005 and not 2008 (so I'm going 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

    June 2, 2011 at 9:26 am

    #1333174

  • RE: is null check in where clause

    Numeric and decimal are the same data type.

    What you are doing will NOT perform well, regardless of whether or not you fix the logic problem. That kind of query suffers...

    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

    June 2, 2011 at 9:15 am

    #1333168

  • RE: Ghost Records

    cfradenburg (6/2/2011)

    As to why something goes through and cleans up the ghost records instead of just allowing the space get reused, that way the data doesn't remain on disk 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

    June 2, 2011 at 9:14 am

    #1333165

  • RE: UAT Testing and reverting back committed transcation

    cheshirefox (6/2/2011)

    Anyone know of an easy way to execute a stored procedure or execute a tsql command that can revert back all committed transactions when the tests are completed.

    Take...

    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

    June 2, 2011 at 5:54 am

    #1333031

  • RE: The query processor ran out of internal resources

    That error is either very, very, very low resources on the server or a complex query. Post the query.

    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

    June 2, 2011 at 4:24 am

    #1332992

Viewing 15 posts - 25,771 through 25,785 (of 49,552 total)