Forum Replies Created

Viewing 15 posts - 1,861 through 1,875 (of 49,552 total)

  • RE: Restore a backup from primary filegroup into the secondary filegroup

    info 58414 - Friday, January 20, 2017 2:53 AM

    Can i restore a backup from old server to the new server into 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

    January 20, 2017 at 3:34 am

    #1923957

  • RE: odd files from sql server 2016 ent install

    Snargables - Thursday, January 19, 2017 6:40 AM

    Forgive me but this is my first sql server 2016 enterprise install. After 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

    January 19, 2017 at 6:48 am

    #1923689

  • RE: SQL 2016 Learning Sources....

    kevaburg - Thursday, January 19, 2017 6:28 AM

    Thanks for the help....the answer was what I was afraid of.  I think it will...

    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

    January 19, 2017 at 6:41 am

    #1923688

  • RE: Retrieve Dates (and other data) From Different Rows

    Please don't post multiple threads for the same question.
    No replies here. Replies to https://www.sqlservercentral.com/Forums/1852028/Retrieve-Dates-from-Different-Rows

    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

    January 19, 2017 at 5:54 am

    #1923676

  • RE: Permissions issue with a sysadmin account

    Ian Scarlett - Thursday, January 19, 2017 4:21 AM

    Doesn't the last bit of the error message give it away?  "The text is...

    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

    January 19, 2017 at 4:24 am

    #1923650

  • RE: Permissions issue with a sysadmin account

    sysadmin has all permissions and cannot be denied anything (it bypasses all permission checks). So if he's logging in with that sysadmin account, it can't be a permission problem.

    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

    January 19, 2017 at 4:16 am

    #1923645

  • RE: Restore question related to DIFF and FULL

    kevaburg - Thursday, January 19, 2017 3:04 AM

    There isn't an inherrent requirement to restore the full backup in NORECOVERY and then...

    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

    January 19, 2017 at 3:51 am

    #1923640

  • RE: Restore question related to DIFF and FULL

    kevaburg - Thursday, January 19, 2017 12:12 AM

    Because of this, restoring the database with NORECOVERY doesn't actually achieve anything....

    ???
    If you want to restore...

    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

    January 19, 2017 at 2:34 am

    #1923626

  • RE: Need help on cte query

    Since there's an aggregate that you're filtering on, use the HAVING clause, not WHERE

    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

    January 18, 2017 at 8:29 am

    #1923446

  • RE: Addressing my biggest objection to using sys.sp_executesql…

    Jason A. Long - Wednesday, January 18, 2017 7:05 AM

    Have you published it yet? If so, any chance you'd share the link?

    Not yet,...

    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

    January 18, 2017 at 8:22 am

    #1923443

  • RE: Addressing my biggest objection to using sys.sp_executesql…

    Jason A. Long - Tuesday, January 17, 2017 11:13 AM

    The use of sys.sp_executesql is certainly a valid method of doing that but so...

    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

    January 18, 2017 at 5:07 am

    #1923386

  • RE: Addressing my biggest objection to using sys.sp_executesql…

    Jeff Moden - Tuesday, January 17, 2017 12:16 PM

     And yes, dynamic SQL is definitely the way to go for something like 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

    January 18, 2017 at 4:56 am

    #1923382

  • RE: what happens internally when you execute same query in multiple times

    I'm not sure what you're looking for, When a query is run multiple times, it runs multiple times, nothing more complicated than that.
    Durations and CPU will vary slightly for...

    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

    January 18, 2017 at 3:27 am

    #1923365

  • RE: Extended Events

    arifulhaq - Tuesday, January 17, 2017 10:21 PM

    What is SQL Server Extended Events? Why it is used for? Can anyone provide a link...

    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

    January 18, 2017 at 2:41 am

    #1923354

  • RE: DBCC CHECKDB('MSDB') returns errors

    Do you have a backup of MSDB?

    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

    January 18, 2017 at 2:40 am

    #1923353

Viewing 15 posts - 1,861 through 1,875 (of 49,552 total)