Yes to all of what you said. And it is available on Standard Edition, as opposed to "Always On", although I think a dumbed-down version of that is being released...

I can promise you that I will still have clients using mirroring at least 10 years from now, probably 15.

Lynn Pettis (3/2/2016)

---

I don't think so since the OP only wants to see one row...

On SQL Server 2014 I would think this is a great use case for LAST_VALUE().

Good advice here on the two main resources to investigate and/or hire. My personal preference is David Klee, but they are both extremely competent technically.

I will add that there are...

shamshad.ali (3/2/2016)

---

We have several lookup tables where Id column is PK auto increment.

Lets say big INT column datatype with records 1,2,3,4, and so on. Due to migration, developer added one...

kc2ine (3/1/2016)

---

Hi,

I have like 89% of server 20GB RAM used all the time.

Is it normal usage? I mean it's the same even at night when nobody is working.

Some...

I would take a quick look at dbcc memorystatus. Semi-documented online. Doubt it will show anything.

With low memory utilization I take it you aren't seeing actual use of the page...

Seems that a LAG statement in a CASE should be able to interrogate the prior value and increment the current count when those two differ.

Presumably no one is hitting your 3-day-old restored backup when you execute against it. Thus one very likely issue is blocking. Use sp_whoisactive during execution on production to check for...

1) There are a LOT of bugs related to Always On. Have you searched post SP3 CUs for any related to this issue?

2) What are is you hardware config, VM...

ravi@sql (3/1/2016)

---

Hi Champs,

I have a Merge statement which has both insert and update .

But source table is quite huge it is having around 70 million records or 2...

This is a multi-statement TVP. Those should be avoided at all costs. DEVASTATINGLY BAD stuff happens! Also, this one is completely ridiculous. Simply calculate the sum yourself on your on...

gorripativ (2/26/2016)

---

Hi,

I have set my db log intitial size as 512 MB and autogrowth as 512 MB. The db is in full recovery model and tlog runs every 15 min....

Brandie Tarvin (2/26/2016)

---

TheSQLGuru (2/11/2016)

---

Whenever I am building out dynamic SQL I always use SET QUOTED_IDENFITIER OFF first and then use double quotes in the outer sections of text. Then I...