Brandie Tarvin (5/28/2015)

---

Well, unless someone used DBCC Timewarp() on it, the last I checked there was only one. But then again, someone did say DBCC Timewarp() was outdated and being...

"There can be only one" although AlwaysOn might come in handy...

Mouth

We need to get a GPS tracker...

Did you check out this: Resume an Availability Database (SQL Server)?

😎

Quick thought, search for "AlwaysOn Availability Groups data movement for database 'XXXXXXXXX' has been suspended"

😎

Edit: typo

Running

Quick thought, you can change the select to a delete and delete from the cte directly.

😎

Quick thought, how about using Extended Events and capture OPEN SYMMETRIC KEY, surely those columns are encrypted?

😎

Therapy

ma701ss (5/27/2015)

---

Hi,

I have two columns in an Excel spreadsheet: productid and colour.

These columns are populated with values, e.g. '123' and 'Red'.

I have about 200 rows and want to insert the...

Alan.B (5/27/2015)

---

Emph. mine

1. It's hard to prove that Everyone knows anything. Statements like "everyone knows" and "we all agree" are antithetical to...

Eric M Russell (5/27/2015)

---

One of the advantages of a medieval style IT shop, where the rules are not spelled out on paper, is that you as the DBA can simply...

My 2 cents on the security and privileges: for the production data, developers with administrative privileges are more dangerous than high heel wing walking on a fighter jet, cannot recall...

+1

😎

BTW, think this experiment thread is becoming a proof that digression is somewhat of...