Forum Replies Created

Viewing 15 posts - 1,996 through 2,010 (of 49,552 total)

  • RE: Modifying a system stored procedure

    You can't change the system procedures.

    You're getting the error because they're not stored in master, they're stored in the hidden resource 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

    December 15, 2016 at 2:33 am

    #1918095

  • RE: Backup SQL2008 db into new SQL 2016 Is this possible?

    sgmunson (12/14/2016)

    Well... I guess I should Google something I don't know the answer to, as I found information that is suggestive that even SQL 2005 is supported.

    Yes it...

    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

    December 15, 2016 at 2:19 am

    #1918091

  • RE: Backup SQL2008 db into new SQL 2016 Is this possible?

    Markus (12/14/2016)

    My question is can I backup/restore a SQL2008 database into SQL 2016?

    Yes

    From the searches I have done I think that is possible.... 2005 no but I think 2008...

    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

    December 14, 2016 at 6:34 am

    #1917857

  • RE: Performance

    kevaburg (12/14/2016)

    GilaMonster (12/14/2016)

    Austin_123 (12/13/2016)

    In our day to day operation If I restore a database from PROD to QA with same SQL edition and version then should we not required...

    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

    December 14, 2016 at 6:20 am

    #1917849

  • RE: Performance

    Austin_123 (12/13/2016)

    In our day to day operation If I restore a database from PROD to QA with same SQL edition and version then should we not required to run...

    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

    December 14, 2016 at 3:37 am

    #1917814

  • RE: Are the posted questions getting worse?

    Phil Parkin (12/13/2016)

    Who's got the ball?

    No idea, but I think I'm going to need it later.

    http://www.sqlservercentral.com/Forums/Topic1842692-391-1.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

    December 14, 2016 at 2:36 am

    #1917800

  • RE: Bitwise & NULL

    Hey. Long time no see. How's things going?

    Sioban Krzywicki (12/13/2016)

    I want to use a bitwise column because

    I'm going to recommend against that. I'm busy (trying to) fix 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

    December 14, 2016 at 2:35 am

    #1917799

  • RE: Log waits

    Can you explain what's wrong in more detail please? Not sure what you're looking at there or why.

    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

    December 14, 2016 at 2:31 am

    #1917798

  • RE: GROUP BY in SQL Server 2014

    Gut feel: there's a TOP without an ORDER 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

    December 13, 2016 at 6:19 am

    #1917572

  • RE: CPU vs memory issues

    Try this

    https://www.red-gate.com/library/troubleshooting-sql-server-a-guide-for-accidental-dbas

    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

    December 13, 2016 at 2:53 am

    #1917526

  • RE: Will there be any data loss?

    Maybe.

    Maybe.

    Got a good backup?

    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

    December 12, 2016 at 6:43 am

    #1917362

  • RE: Let the optimizer do it's thing -- wrong

    Indianrock (12/12/2016)

    Why would SSDs generate deadlocks?

    It doesn't generate deadlocks, just facilitates them.

    If your workload currently is IO-bottlenecked (quite common), then the IO latencies are slowing things down. Remove those, which...

    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

    December 12, 2016 at 6:42 am

    #1917361

  • RE: Copy BAckup Files to Non Prod servers

    I need to copy backup files from

    JasonClark (12/11/2016)

    Make database off line.

    Detach the production 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

    December 12, 2016 at 2:15 am

    #1917316

  • RE: Backing up log in High Availability

    Log backups don't make the file smaller. They mark the space in the file as reusable.

    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

    December 11, 2016 at 2:17 pm

    #1917288

  • RE: Is it right way to add filtered column as main column for creating filtered index

    DesNorton (12/9/2016)

    Then again how many statuses are there? It may be beneficial to not filter the index and just use

    CREATE NONCLUSTERED INDEX indexname

    ON table_name ( type_id, createtime, status )

    I'd...

    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

    December 11, 2016 at 2:15 pm

    #1917287

Viewing 15 posts - 1,996 through 2,010 (of 49,552 total)