Michael Gerholdt (12/20/2016)

---

Initially, AlwaysOn Availability group works from everywhere with clients of various sorts aimed at listener.

Do a manual failover, and now only clients on the same VLAN as the...

Personally, I would always use a date dim for this type of thing. There are many scripts out there which should do most of the donkey work for you.

Firstly,...

Would you not be licensing cores, rather than VM's?

Slight but IMHO important...

Something like this?

select

ag.Name, AGReplica.replica_server_name, ag.Group_Id, agl.dns_name as 'ListenerName', COUNT(db.database_id) 'DatabaseCount'

from

master.sys.availability_groups ag

left join

master.sys.availability_group_listeners agl

on ag.group_id = agl.group_id

left outer join

sys.dm_hadr_database_replica_states db

on db.group_id =...

Sergiy (11/28/2016)

4. Vehicle registrations are not unique for a car.

You may change your car registration any day, by purchasing a personalised plate.

Not to mention - in many countries registration plates...

Beatrix Kiddo (11/21/2016)

---

In the UK there has been quite a lot of resistance to implementing a centralised repository of all health records, and this kind of thing is exactly why....

Brandie Tarvin (11/17/2016)

---

Grant Fritchey (11/16/2016)

---

Announcements include:

SP1 for 2016 (which also has CREATE OR ALTER).

A single development surface. This means all functionality in Enterprise is also in Standard and Web (WHOOOP!).

vNext...

Rather than roll your own, I would use one of these

https://ola.hallengren.com/

http://sqlfool.com/2010/04/index-defrag-script-v4-0/

both are great, take your pick according to your needs

I'm afraid, as ever, it depends.

If this is a staging table where you will be running a lot of transformations on the data, then the addition of an appropriate clustered...

Using TRUNCATE rather than DELETE will reset the identity

When you delete rows in a heap, it can't reallocate the space it had been using.

One of the myriad ways heaps suck.

Is the table a heap?

Phil Factor (11/5/2016)

---

MUMPS? Good grief, that is an amazing survival. I wrestled that fiendish system in the eighties. It is true, though. If you curl up your nose at something...

Ed Wagner (10/22/2016)

---

I'm a bit puzzled by the "if you really, really need to performance test" part. Who doesn't do performance tests before releasing something to production? It's...