We'd need more specific info, but if the select is contained in the same sp as the update, you can wrap them both in a transaction and rollback.

I was able to find the processes in a history table we keep. It looks like the user was using DacFX Deploy to deploy the changes. My guess...

The trace goes back to 2013-04-25 01:34:56.880. I assumed that by using this file (its the oldest) I would get the date I need. It does in fact have...

On a daily basis we spit out the SQL logs into a daily report that our primary reviews. In the SQL logs, we see the following:

Apr 25 2013 ...

Are there any commands that implicitly decrypt? I know it is not random, but maybe a misunderstanding of a command. The only command I see issued is ALTER TABLE...

I guess it is time to track...

GilaMonster (4/29/2013)

---

No, removing compression on a table or set of tables will not disable TDE. As for decrypting the pages, SQL does that every time they're pulled into memory, then...

Evil Kraig F (4/26/2013)

---

SQLKnowItAll (4/26/2013)

---

Thanks for the replies. We will test both, of course. I was against the idea at first because of my feelings on changing a...

Thanks for the replies. We will test both, of course. I was against the idea at first because of my feelings on changing a perfectly good set-based operation...

Stefan Krzywicki (4/25/2013)

---

SQLKnowItAll (4/25/2013)

---

I guess I just don't get it. You said you did not want to use sp_help_job because you had to insert into a table, yet you...

I guess I just don't get it. You said you did not want to use sp_help_job because you had to insert into a table, yet you do the same...

rdeheld-535532 (4/24/2013)

---

Yes It does require license

Read Multiplexing:

"The number of tiers of hardware or software between the SQL Server and the user or devices that ultimately use its data, services, or...

rdeheld-535532 (4/24/2013)

---

SQLKnowItAll (2/15/2012)

---

@lutz

Your scenario 1 most certainly requires an unlimited CAL license if you cannot account for all devices. This is one of those "indirect" scenarios that should have...

GilaMonster (4/9/2013)

---

SQLKnowItAll (4/8/2013)

---

It is pretty clear that with auto_update_statistics enabled, there is no reason whatsoever to recompile after the statistics update.

There's never any need to recompile after a stats update...

Excellent! Thanks Gail.