Forum Replies Created

Viewing 15 posts - 1 through 15 (of 137 total)

  • RE: DB Env. Refresh

    Yeah probably what I wrote and what I meant might have come across a little grey. I pretty much wanted a Prod Restore on the UAT Server, but keeping both...

  • RE: DB Env. Refresh

    FYI, I've resolved the issue. I created it going down the path of using Elastic Query. it was a little bit clunky (in preview mode) but achieved the results.

  • RE: DB Env. Refresh

    Hi Grant, 

    Thanks for the reply, not sure If i misunderstood your answer or didn't explain properly.

    Below action Plan:

    1. Copy a production backup and restore...

  • RE: DB Env. Refresh

    forgot to add -  will be using PowerShell to automate all this. I can manually create a script and call it but it will need to be maintained which defeats...

  • RE: Splitting TempDB across multiple files

    GilaMonster - Friday, January 5, 2018 3:00 AM

    Tava - Friday, January 5, 2018 2:46 AM

  • RE: Splitting TempDB across multiple files

    GilaMonster - Tuesday, January 2, 2018 6:59 AM

    Jeff Moden - Tuesday, January 2, 2018 6:19 AM

    January 5, 2018 at 2:46 am


  • RE: Splitting TempDB across multiple files

    They will be production backups and configurations will vary. E.g Simple recovery model will be in SYSTEST/UAT while PROD will have FULL.

    Datavolume and transaction counts will obviously reduce...

  • RE: Index Usage Stats - understanding. If my index being Used?

    Ed Wagner - Friday, April 28, 2017 10:27 PM

    If you look at your seeks, scans, you'll see that they are being...

  • RE: Type of DB Replication Scenario

    I've read a few articles, some good some bad.

    I think i understand but still little confused on setup. I'll definitely run a test, need a bit of hands on...

  • RE: Type of DB Replication Scenario

    Sorry if im misunderstanding... so this setup would work?

    Original country 1 - host database and no changes, read/write etc

    New Country 2 - has a copy of country 1s Db...

  • RE: Type of DB Replication Scenario

    Correct me if I'm wrong, but merge replication from what ive read will resolve the conflicts in IDs etc... but the read process, they will still have to query...

  • RE: Type of DB Replication Scenario

    Thanks for the quick reply. I haven't looked at merge replication as I'm very green in this type of area (rep, mirroring etc).

    I'll have a read of it now...

  • RE: DBCC Check DB

    Unfortunately i can't do the approach of restoring a backup on to another env.

    Is it not better to do both physical and logical? If you had too choose would you...

  • RE: DBCC Check DB

    RVSC48 (10/5/2016)

    Hi, this is an excellent article to look at regarding why checkdb takes so long. You will notice the size of the database is his #1 item.

  • RE: how to unit test sprocs?

    Eric M Russell (8/23/2016)

    It sounds like you're describing some specific implementation of unit testing within SSDT or Visual Studio.

    Unit Testing a stored procedure, generally speaking, is when you execute a...

Viewing 15 posts - 1 through 15 (of 137 total)