Forum Replies Created

Viewing 15 posts - 24,571 through 24,585 (of 49,552 total)

  • RE: Rollback or committed

    Depends. Unless the whole lot are run in a transaction (unlikely and probably silly) any statements that finished would have committed any that hadn't finished would rollback.

    CheckDB doesn't rollback because...

    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

    July 31, 2011 at 1:34 pm

    #1361325

  • RE: Are the posted questions getting worse?

    Major kudos to the Win 7 developers. Replaced the motherboard, processor and memory of my desktop and when I switched it on, windows booted straight to the desktop, no errors,...

    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

    July 31, 2011 at 11:51 am

    #1361319

  • RE: dynamic data types

    Is this unicode or ASCII data? If ASCII, use VARCHAR(MAX), asn NVARCHAR(MAX) is for unicode and takes 2 bytes per character

    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

    July 31, 2011 at 4:14 am

    #1361302

  • RE: query gets executed successfully database created bt no user,schema,table created even executed successfully.i hv also refreshed it.

    There's a Create Database DIPANJALI1DB, but there's no USE DIPANJALI1DB, so all of your objects got created in master.

    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

    July 31, 2011 at 2:33 am

    #1361295

  • RE: Clustered Index Tables and Heap Tables

    Gabriel P (7/30/2011)

    GilaMonster (7/30/2011)

    An IAM is a page that contains a bitmap for extent allocations for an index. I assume you mean the pages themelves...

    I am visually trying 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

    July 30, 2011 at 10:21 am

    #1361241

  • RE: Rebuilding master db rebuild all system db ?

    Yes

    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

    July 30, 2011 at 8:43 am

    #1361228

  • RE: Clustered Index Tables and Heap Tables

    Gabriel P (7/30/2011)

    1) What is the data structure of the IAM that holds all the rowid's for a heap? Is it just a singly linked list? Can this list get...

    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

    July 30, 2011 at 8:43 am

    #1361227

  • RE: IO preferable number for Execution Query

    Errr, what are you asking?

    Where did those numbers come from? Is there a problem?

    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

    July 30, 2011 at 6:58 am

    #1361215

  • RE: Database Full backup size increased

    Did you bother to investigate the cause of the large log before taking what were possibly useless steps?

    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

    July 30, 2011 at 6:56 am

    #1361214

  • RE: Speeding up database access Part 2 - Pinpointing Other Bottlenecks

    pkrudysz (7/30/2011)

    I totally disagree with people saying that PLE (Page Life Expectancy) of 300 is an irrelevant number and how we should all watch our servers and look for deviations...

    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

    July 30, 2011 at 6:55 am

    #1361213

  • RE: behaviour of LEN()

    As clearly documented in Books Online:

    Returns the number of characters of the specified string expression, excluding trailing blanks.

    Note:

    To return the number of bytes used to represent an expression,...

    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

    July 30, 2011 at 4:40 am

    #1361202

  • RE: Manual Shrink works, Schedule Job Shrink bombs

    That is not how SQL databases should be backed up. A file-level copy of the data and log files will very likely be useless. The files are locked open by...

    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

    July 29, 2011 at 2:31 pm

    #1361128

  • RE: Why this query works ? It has syntax error already. (about attacks)

    aykut canturk (7/29/2011)

    this is how my friend's web site hacked. they wrote that command on url. I know how they did it, but this is not the issue of this...

    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

    July 29, 2011 at 2:28 pm

    #1361126

  • RE: Can we Create Trigger on Stored Procedure in SQL Server 2008

    guptaprashant1982-1107326 (7/29/2011)

    Can we Create Trigger on Stored Procedure in SQL Server 2008:-)

    Create a trigger on a stored proc or create a trigger in a stored proc?

    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

    July 29, 2011 at 1:55 pm

    #1361108

  • RE: Are the posted questions getting worse?

    Tom.Thomson (7/29/2011)

    GilaMonster (7/29/2011)

    If I want to work away from my desktop then, depending one what I'm likely to be doing, I'll pack iPad or laptop. iPad for writing, reading, annotating...

    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

    July 29, 2011 at 1:52 pm

    #1361105

Viewing 15 posts - 24,571 through 24,585 (of 49,552 total)