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...

you'll also want to set the multisubnetfailover=true option in your connection string. This requires .NET 4.5 or above

Slightly neater I suppose 😉

SELECT REPLACE(REPLACE(REPLACE(CAST(CONVERT(VARCHAR(19), GETDATE(), 120) AS VARCHAR(10)),'-',''),':',''),' ','');

hth

further to Jeff and Grant's posts, some additional reading on backups (including the importance and meaning of RTO and RPO), can be found in the following link. If you...

I do tend to agree. Logically, if an order has been placed, but we do not yet have a fulfillment date, then it is unknown, which is what null...

There is, apparently a workaround, but it does require a server restart, and I have to say it's not something I've tested because, frankly, the DTA is not something I'd...