Forum Replies Created

Viewing 15 posts - 22,216 through 22,230 (of 49,552 total)

  • RE: Multi Part identifier could not be bound

    SQL Kiwi (11/14/2011)

    Error handling in T-SQL is a bit of a mess, overall.

    That's the understatement of the month. My current pet favourite - non-fatal errors (ie not sev...

    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

    November 14, 2011 at 10:15 am

    #1407380

  • RE: Help with a Select against sys.databases

    Do note that Lowell's code is a just a snippet, not the full code necessary.

    Msg needs to come from the EventData function, it may need some XQuery. In short, completion...

    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

    November 14, 2011 at 9:57 am

    #1407360

  • RE: what is the use of : WITH (NOLOCK, READUNCOMMITTED)

    To explain... I have a browser plugin that stores snippets of test. So common replies aren't typed, they're just auto-inserted.

    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

    November 14, 2011 at 9:43 am

    #1407341

  • RE: Does the full backup clear/truncate the t-log?

    JakeSA (11/14/2011)

    None of the database options (configurable in SSMS or sp_configure or sp_dboption) are applicable to the log file. They are applicable to the data (MDF and NDF) files...

    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

    November 14, 2011 at 9:40 am

    #1407333

  • RE: Does the full backup clear/truncate the t-log?

    JakeSA (11/14/2011)

    Or maybe you mean that inactive logs entries are marked as having been backed up in a t-log backup so that they can be overwritten?

    I mean exactly what 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

    November 14, 2011 at 9:37 am

    #1407328

  • RE: what is the use of : WITH (NOLOCK, READUNCOMMITTED)

    Sean Lange (11/14/2011)

    Funny how we all post the same link and type pretty much the same thing on this topic 2-3 every week.

    Type?

    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

    November 14, 2011 at 9:32 am

    #1407318

  • RE: ASYNC_NETWORK_IO, TRACEWAIT wait types

    What's the question here?

    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

    November 14, 2011 at 9:32 am

    #1407317

  • RE: dbcreator server role has permission to change sa password?

    Someone who solely has the db_creator role does not have the rights to change the sa password (and there's no mechanism at all to see passwords, they're stored hashed)

    I created...

    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

    November 14, 2011 at 9:30 am

    #1407313

  • RE: SORT_IN_TEMPDB = OFF but tempdb still grows during index rebuild

    Doing your rebuilds 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

    November 14, 2011 at 9:24 am

    #1407305

  • RE: Does the full backup clear/truncate the t-log?

    JakeSA (11/14/2011)

    My understanding is only the t-log backup will truncate the log and delete the inactive log entries in the t-log, but I still encounter DBAs who say the full...

    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

    November 14, 2011 at 9:22 am

    #1407302

  • RE: Help with a Select against sys.databases

    Jpotucek (11/14/2011)

    The DDL Triggers emails me when Database is created. Doesnt' tell me which Database - just which Instance the database was created in.

    I would 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

    November 14, 2011 at 9:18 am

    #1407296

  • RE: what is the use of : WITH (NOLOCK, READUNCOMMITTED)

    See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.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

    November 14, 2011 at 9:14 am

    #1407289

  • RE: Help with a Select against sys.databases

    What do you need the query for? The DDL trigger?

    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

    November 14, 2011 at 8:27 am

    #1407213

  • RE: Why is "Select *" bad in any SQL code?

    Let me give you an example and you tell me.

    SELECT * INTO #Temp

    FROM TableWith50ColumnsAnd5MillionRows

    -- update that uses 2 columns from #temp

    -- update that uses 3 columns from #temp

    -- select 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

    November 14, 2011 at 8:20 am

    #1407206

  • RE: DB mirroring and Log backup chain

    Yup.

    But if you don't do log backups, it will mess up your principal. Log full errors aren't fun and the only thing that marks the log reusable in full recovery...

    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

    November 14, 2011 at 8:18 am

    #1407202

Viewing 15 posts - 22,216 through 22,230 (of 49,552 total)