GilaMonster (9/7/2016)

---

If you've analysed and tested, and have confirmed through careful testing and consideration of alternatives, that the hint is the best way to solve the specific problem you have...

^^^ Exactly This!

If you have scores of servers and hundreds of systems, manually repointing them all in the event of a datacentre, or even host - loss, for a number...

SQLAssAS (9/6/2016)

---

I am currently setting up an AG, 2 node in the primary data center with synchronous commit and a third node in the secondary data center with asynchronous commit.

All...

Hi, yes, see exactly what you're saying. Most of the time (although not always by any means) the box is actually pretty quiet - CPU low and our WhoIsActive...

Hi Gail,

both the same - here's an example, immediately before and after PLE being squashed

RunTimeCounter_Name ...

I don't know Gail - I'll add that to the PLE collection and get back.

thanks

Thanks for that. It was actually set to the correct locale, so instead I decided to stop being a f***wit and used the correct (datetime) datatype.

<sigh>

Thanks for your help

Very briefly:

Full -

allows you to restore to a point in time - say 4 seconds past 5 this afternoon when someone accidentally truncated the...

Try adding a startup sp on each node to turn off those jobs on the other nodes and turn their own job on

If you've not got an auditing tool that can scan for you, try using this guy's powershell scripts. Have a look at his blog here, they may be what you're...

When I've done it in the past, just a standard empty database creation with the tables selected for the publication created and populated when it's created option used.

You can create a new database at the target and set up replication to that.

We're just coming to the end of a project at our place to move all the SQL Server instances onto a new dedicated infrastructure. For the initial investigation of...

I quite like Apex's formatting freebie, it's configurable enough to get at least close to most rational formatting preferences. I've not used it with 2016, but it works fine...

Sergiy (6/15/2016)

---

Jeff Moden (6/15/2016)

---

An interview is the one place where volunteering information can do nothing but good... if you know what you're talking about. When someone asks a simple...