Forum Replies Created

Viewing 15 posts - 1,666 through 1,680 (of 49,552 total)

  • RE: How does a SQL Script Execute

    Not sure I understand your question.

    A script of multiple queries will execute sequentially.

    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, 2017 at 7:06 am

    #1933027

  • RE: 16 inconsistencies found running DBCC checkDB

    Please post new questions in a new thread. Thank 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 13, 2017 at 1:21 pm

    #1932948

  • RE: Availability Group and Confluence

    When you created the SQL logins on the second server, did you specify the same SID and password as the logins have on primary? If not, your database users are...

    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 13, 2017 at 11:23 am

    #1932923

  • RE: Question about indexing

    itmasterw 60042 - Monday, March 13, 2017 10:45 AM

    Okay, this is starting to make more sense, just not sure what you mean 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

    March 13, 2017 at 11:21 am

    #1932922

  • RE: MDOP and Cost Parrellalism Relation

    Having SOS_Scheduler_Yield waits happening doesn't mean that things are waiting for the processor. Having them with long signal waits may do, but the simple presence of the wait does 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 11, 2017 at 1:36 am

    #1932809

  • RE: SQL Server Instance consuming 95% memory

    sqlguy80 - Thursday, March 9, 2017 9:26 PM

    Hi

    I have a  production DB Instance consuming 95% memory,  JUST one database consuming all memory

    All...

    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 10, 2017 at 1:35 am

    #1932657

  • RE: How do I perform restore of DB which does not exist?

    Find the full backup, restore just that with the NORECOVERY option, then restore your log backups. You're getting an error because all you're trying to restore at the moment are...

    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 10, 2017 at 1:30 am

    #1932656

  • RE: How to overcome the identity column "jump 1000" issue

    Grant Fritchey - Thursday, March 9, 2017 6:25 AM

    I've built systems where I only  had the ID columns on every table....

    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 10, 2017 at 12:01 am

    #1932649

  • RE: How to overcome the identity column "jump 1000" issue

    Jeff Moden - Wednesday, March 8, 2017 5:02 PM

    Understood and I said nothing contrary to that.  The questions remains, though.  What do...

    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 8, 2017 at 9:25 pm

    #1932451

  • RE: How to overcome the identity column "jump 1000" issue

    GilaMonster - Wednesday, March 8, 2017 12:16 AM

    Depends on the system and the client's requirements.

    I didn't say we always 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

    March 8, 2017 at 3:07 pm

    #1932424

  • RE: The database XXXX is not accessible (ObjectExplorer)

    Phanit86 - Wednesday, March 8, 2017 8:54 AM

    The SQL Server runs under "LocalSystem". Shall I change it to run under user...

    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 8, 2017 at 8:59 am

    #1932342

  • RE: The database XXXX is not accessible (ObjectExplorer)

    Nothing wrong with the database then. Maybe someone's been fiddling with permissions. have a chat with your DBA.

    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 8, 2017 at 8:37 am

    #1932331

  • RE: Whitespace in 3-part name ignored???

    Eric M Russell - Wednesday, March 8, 2017 6:55 AM


    Sadly, this is T-SQL legal too.


    Oh you can do a...

    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 8, 2017 at 8:34 am

    #1932328

  • RE: Memory Issue - SQL Server 2008 R2

    Setting min server memory and max server memory to the same value is a bad idea. It disables a lot of SQL's automatic memory management, if the OS comes under...

    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 8, 2017 at 8:31 am

    #1932325

  • RE: The database XXXX is not accessible (ObjectExplorer)

    When you query sys.databases, what is the value of the Status_Desc column for that database?

    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 8, 2017 at 7:32 am

    #1932298

Viewing 15 posts - 1,666 through 1,680 (of 49,552 total)