douglasbrown880 (4/13/2016)

---

Unfortunately I cannot get the actual execution plan.

I have spoken to the dev's and they will be looking to add a "lock" to the secondary threads.

We will then include...

Can you post the execution plans of a couple of those MERGE statements please? Actual, not estimated. If you can, try to get one where the number of rows in...

Friday and Saturday.

I have a sister in Liverpool and we haven't met up for ages, so I won't be staying too late on either day.

Famous last words...

b ghanekar (4/12/2016)

---

This is a great solution but my problem is something different.

I want to skip records where the date of sale is lesser than the date of purchase.

That...

TomThomson (4/7/2016)

---

"Crowdie" is ambiguous;...

Counting patterns of unexpected behaviour in a certain order, Graham?...

TomThomson (4/6/2016)

---

Brandie Tarvin (4/6/2016)

---

Good morning, peeps.

What are we having for breakfast today?

Mine was oatmeal with purple honey (from North Carolina) and assorted fruit. But for some reason I have pancakes...

Michael L John (4/6/2016)

---

Alan.B (4/6/2016)

---

Greg Edwards-268690 (4/6/2016)

---

Brandie Tarvin (4/6/2016)

---

Good morning, peeps.

What are we having for breakfast today?

Mine was oatmeal with purple honey (from North Carolina) and assorted fruit. But for...

Lynn Pettis (4/5/2016)

---

Just throwing this out there, but if you are deleting all the data from a set tables with RFI configured, you can delete the data starting at the...

Here’s how I would do this. First, number your cases 1,2,3,4 using a cross apply block or similar with CASE statements (if they’re not already numbered in the appropriate sequence)....

Jon-183221 (3/30/2016)

---

I only have a small insight to what you need to do but why can't you allocate the postcodes against the Account (police force) as this is where the...

Small change #1 of 2:

,('EC1','UglyGUID02') --- A Greater London postcode

,('EC1','UglyGUID04') --- A City Of London...

You would appear to be missing an area in which the City of London Police might operate.

Why not give the bizzies in the square mile their own area too...

er.mayankshukla (3/29/2016)

---

Hi,

In the AdventureWorksDB, I queries Sales.SalesOrderDetail table on the column CarrierTrackingNumber which doesn't have any index defined on it and I expected a clustered index scan. This query returns...

These articles benefit from a short description, for...