Forum Replies Created

Viewing 15 posts - 27,376 through 27,390 (of 49,552 total)

  • RE: SQL Blog

    To be honest, writing alone is easier than writing collaboratively. Alone you only have to satisfy yourself.

    If you're thinking about a blog, try writing blog-type posts for 2 or 3...

    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

    March 15, 2011 at 2:54 am

    #1298723

  • RE: SQL Blog

    Write about what excites you. If writing is a chore, it will show

    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

    March 15, 2011 at 2:20 am

    #1298712

  • RE: Trace Flags Deadlocks - Am i missing something?

    sqldba_icon (3/14/2011)

    i) trace 1222, will enable XML deadlock graph in sql server. Do i need to restart the server?

    Depends how you enable it. If you use TRACEON, no, if...

    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

    March 15, 2011 at 12:04 am

    #1298681

  • RE: Need Best Maintenance plan

    And books online is your friend

    http://msdn.microsoft.com/en-us/library/ms176064%28v=SQL.100%29.aspx

    DBCC CHECKDB

    Checks the logical and physical integrity of all the objects in the specified database by performing the following operations:

    *...

    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

    March 15, 2011 at 12:01 am

    #1298680

  • RE: REPLICATION FOR SQL2008

    jolan.mahinay (3/13/2011)

    thanks gila but the problem is if we have an additional tables and the replication is already set then we have to reinitialize again the replication to capture the...

    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

    March 14, 2011 at 2:53 pm

    #1298576

  • RE: Locked tables clarification

    No. It's an isolation level. Have a read through Books Online on Snapshot and Read Committed snapshot and see which would work better for you.

    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

    March 14, 2011 at 8:44 am

    #1298365

  • RE: Locked tables clarification

    It may be that the entire table will be locked, it may be that rows or pages will be.

    Consider snapshot isolation level (or read committed snapshot). Allows writers to not...

    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

    March 14, 2011 at 8:19 am

    #1298345

  • RE: Restrict access to instance

    mflora (3/14/2011)

    The problem we are having is some connections come right back and take the single connection up and the SQL job account cannot connect to the DB.

    Any more thoughts?...

    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

    March 14, 2011 at 8:10 am

    #1298338

  • RE: if database crashes how to recover in sql server 2008

    There are so many ways things could go wrong...

    If you have backups, full and log, you can recover at least to the last log backup. If the DB is 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

    March 14, 2011 at 6:47 am

    #1298287

  • RE: Need Best Maintenance plan

    Maybe.

    Not an easy question to answer.

    If you have reason to believe that the auto update stats is not adequate, and the database is small enough that the update stats won'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

    March 14, 2011 at 5:21 am

    #1298260

  • RE: History of trigger

    Lowell (3/14/2011)

    just confirming: looks like the disable of a trigger does not count as a DDL event, so it is not tracked int eh default trace; i created both ...

    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

    March 14, 2011 at 5:19 am

    #1298259

  • RE: Shrinking a TLog while Mirroring

    Please note: 4 year old thread.

    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

    March 14, 2011 at 4:39 am

    #1298251

  • RE: Database Mirroring and Log Files

    Please note: 2 year old thread

    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

    March 14, 2011 at 4:09 am

    #1298247

  • RE: string Comparison.

    Henrico Bekker (3/14/2011)

    try the following:

    select LEN(string2),len(RTRIM(LTRIM(string2))) from yourtablename

    and compare the length it records.

    However note (from Books Online)

    LEN (Transact-SQL)

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

    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

    March 14, 2011 at 3:58 am

    #1298242

  • RE: string Comparison.

    JohnyRotten (3/14/2011)

    Since when is this true?

    SELECT 1 WHERE 'test' = 'test '

    In SQL always.

    SQL ignores trailing spaces when doing string comparisons. If it didn't, there...

    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

    March 14, 2011 at 3:57 am

    #1298241

Viewing 15 posts - 27,376 through 27,390 (of 49,552 total)