Forum Replies Created

Viewing 15 posts - 6,226 through 6,240 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Does this answer your question?

    Those are two instances on the same server, one 2012 and one 2014 and I opened both from the same SSMS 2014

    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

    April 8, 2015 at 9:01 am

    #1789566

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/8/2015)

    And on another note, back to SQL 2012 SSMS, does anyone know if that annoying bug with Job Activity Monitor was fixed? The one that puts the big...

    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

    April 8, 2015 at 8:58 am

    #1789564

  • RE: Are the posted questions getting worse?

    On the subject of reading...

    https://www.thedodo.com/pets-interrupting-reading-968102862.html

    And can we please leave the politics somewhere else?

    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

    April 8, 2015 at 8:44 am

    #1789560

  • RE: Datetime conversion

    Specify the correct format code for the CONVERT, the one that corresponds to the format of datetime you're passing.

    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

    April 8, 2015 at 7:35 am

    #1789532

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/8/2015)

    Koen Verbeeck (4/8/2015)

    Grant Fritchey (4/8/2015)

    Probably get in a little trouble for this, but since I know that many of you are both SF fans and, let's just say,...

    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

    April 8, 2015 at 7:28 am

    #1789528

  • RE: Are the posted questions getting worse?

    I use SSMS 2014 exclusively now, because I'm working on SQL Server 2014 and previous versions of SSMS don't work well up-version. The biggest annoyance is the help file. 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

    April 8, 2015 at 7:09 am

    #1789517

  • RE: Are the posted questions getting worse?

    dwain.c (4/7/2015)

    I just posted this to "The Worst Comments" discussion thread:

    dwain.c (4/7/2015)

    -- Some nitwit posting under the moniker of Dwain.C with a big fish for an avatar

    -- gave me 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

    April 8, 2015 at 6:46 am

    #1789501

  • RE: How to eliminate OR condition

    koti.raavi (4/7/2015)

    Index1: ID (PK-Clustered Index)

    Index2: ID,Member_ID,Memeber_Name

    Index2 is near-useless. It's redundant with the primary key and is extremely unlikely to be used much.

    The index that the missing index suggestions are suggesting...

    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

    April 8, 2015 at 4:19 am

    #1789475

  • RE: CTE Syntax

    Hugo Kornelis (4/8/2015)

    Eirikur Eiriksson (4/5/2015)

    Try out this keyboard sequence:

    😎

    1. CTRL + H

    2. [

    3. TAB

    4. ALT + A

    5. ENTER

    6. ...

    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

    April 8, 2015 at 3:47 am

    #1789467

  • RE: Deadlock Issue

    Yes, those are ALTER VIEW statements running. Whoever told you the views don't get altered is mistaken. The locks involved are Schema Modification locks, those are taken when an object...

    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

    April 8, 2015 at 2:57 am

    #1789461

  • RE: How to eliminate OR condition

    On the indexing side: http://sqlinthewild.co.za/index.php/2011/05/03/indexing-for-ors/

    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

    April 8, 2015 at 2:54 am

    #1789460

  • RE: Running Ola script and getting error

    Sossoliso (4/7/2015)

    -databasename, "-" should be "--" for comment

    No, because it's not a comment.

    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

    April 7, 2015 at 6:07 am

    #1789162

  • RE: Are LSNs recycled

    I had to double-check to be sure.

    The key is that when a VLF is reused, it's sequence number increases so it never has the same sequence number as a previous...

    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

    April 7, 2015 at 4:12 am

    #1789138

  • RE: Am looking to rent server time and instances for practice

    Also look at Microsoft's Azure offering.

    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

    April 7, 2015 at 4:01 am

    #1789135

  • RE: DBCC CHECKDB - SCript Review and suggestions

    Seconding the recommendation to use Ola's script. He's done all the hard work, his stuff works, it works well, it's easy to use.

    Couple things about your code:

    TABLOCK WILL CAUSE DBCC...

    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

    April 7, 2015 at 2:56 am

    #1789129

Viewing 15 posts - 6,226 through 6,240 (of 49,552 total)