Forum Replies Created

Viewing 15 posts - 2,566 through 2,580 (of 49,552 total)

  • RE: Do Not Return Matching Rows

    The Dixie Flatline (8/23/2016)

    Pssst... "MIAMI"

    Also, I'm missing something.

    Why not just select where [Statename] <> 'ALL' ?

    Because he wants the cities where there's no row for that city with 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

    August 24, 2016 at 4:17 am

    #1897131

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (8/23/2016)

    Lynn Pettis (8/23/2016)

    Luis Cazares (8/23/2016)

    Gail, you just made my day with this answer. http://www.sqlservercentral.com/Forums/FindPost1811748.aspx

    I can't stop laughing. 😀

    omg

    congrats. One day I'll get there

    To where? Snarky...

    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

    August 23, 2016 at 3:00 pm

    #1897050

  • RE: How to force query to use certain execution plan?

    I suspect Phil meant to apply the traceflag just to the problematic query, not enable it system-wide.

    https://support.microsoft.com/en-us/kb/2801413

    https://blogs.msdn.microsoft.com/psssql/2015/06/16/identifying-sql-server-2014-new-cardinality-estimator-issues-and-service-pack-1-improvement/

    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

    August 23, 2016 at 2:58 pm

    #1897049

  • RE: Unless the log is being backed up is there a reason for setting a databse to the BULK LOGGED recovery model

    YSLGuru (8/23/2016)

    We don't need to do backups of the log because the entire server is on a DR systems so that if anything happens the entire server is restored. ...

    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

    August 23, 2016 at 2:08 pm

    #1897038

  • RE: Unless the log is being backed up is there a reason for setting a databse to the BULK LOGGED recovery model

    No. Anything that's minimally logged in bulk-logged is minimally logged in simple.

    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

    August 23, 2016 at 2:07 pm

    #1897037

  • RE: Alwayson on WSFC - is shared disk really not needed ?

    szejiekoh (8/23/2016)

    Actually, what i am trying to clarify is that a 2 node WSFC will still need share disk (fileshare aside) for voting/quorum even though always on availability group sitting...

    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

    August 23, 2016 at 1:17 pm

    #1897023

  • RE: Are the posted questions getting worse?

    Luis Cazares (8/23/2016)

    Gail, you just made my day with this answer. http://www.sqlservercentral.com/Forums/FindPost1811748.aspx

    I can't stop laughing. 😀

    I was fully expecting to get a reply like "Tried that and it won't start!!!!"....

    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

    August 23, 2016 at 12:55 pm

    #1897013

  • RE: Database inaccessible, advice appreciated

    HappyGeek (8/23/2016)

    NB the backups were actually there and OK but when a restore was attempted, it still returned the same error.....backups are now continuing fine.

    Backups that are on the same...

    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

    August 23, 2016 at 12:04 pm

    #1896994

  • RE: Converting a XML datatype to varchar(max).

    ben.brugman (8/23/2016)

    Now I want to do some manipulations on the resulting string.

    So I convert the XML string to a VARCHAR(MAX) datatype.

    Why?

    If you want to shred it, why not use XPath...

    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

    August 23, 2016 at 11:45 am

    #1896990

  • RE: Need some help. I may have crashed the instance.

    You can check the previous error log to see why it stopped

    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

    August 23, 2016 at 11:43 am

    #1896989

  • RE: Need some help. I may have crashed the instance.

    Start the service?

    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

    August 23, 2016 at 10:55 am

    #1896973

  • RE: trace is not capturing DeadLock

    Could be the deadlock hasn't reoccured.

    You don'yt need 1204, that the SQL 2000 traceflag for capturing deadlocks, and to be honest you don't need 1222 in SQL 2012, use 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

    August 23, 2016 at 10:32 am

    #1896969

  • RE: Do Not Return Matching Rows

    SELECT CityName FROM @Cities where CityName NOT IN (SELECT CityName from @Cities WHERE StateNAme = 'ALL');

    Edit: And make sure that CityName is not nullable column.

    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

    August 23, 2016 at 10:26 am

    #1896965

  • RE: SQL Server Upgrade from 2008 Standard to 2014 or 2016

    You don't need any exporting, or importing, or discrepency checks. While you can't do an in-place upgrade, that's probably not something that you want to be doing in production. Side-by-side,...

    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

    August 23, 2016 at 10:01 am

    #1896959

  • RE: How to force query to use certain execution plan?

    The USE PLAN hint, but I would recommend you try every other way to get a desired plan shape first. The hint's not one I like using in production.

    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

    August 23, 2016 at 9:57 am

    #1896958

Viewing 15 posts - 2,566 through 2,580 (of 49,552 total)