I hope these ad-hoc queries are not running against your primary operational database. If so, then as suggested earlier, speak with your manager about implementing a replicated instance. Also consider...

Read up on the SET QUERY_GOVERNOR_COST_LIMIT setting, which can be configured at either the session or server level. The threshold value specifies the maximum number of seconds for which a...

Lynn Pettis (5/16/2013)

---

I may be wwrong, but since all the columns used to update the table come from the columns defined in the view, I would say the computed column...

Of course, if your database accepts only network domain logins, then all this fancy authentication would be handled by Active Directory, not by SQL Server. Users login to the network...

curious_sqldba (5/16/2013)

---

Eric M Russell (5/16/2013)

---

curious_sqldba (5/16/2013)

---

I don't...

curious_sqldba (5/16/2013)

---

I don't know what lay beneath...

Steve Jones - SSC Editor (5/16/2013)

---

Eric M Russell (5/16/2013)

---

...

There could also be honeypot tables. For example, the DBA could create tables with enticing names like [Employee_Salary] or [Customer_CreditCard] and then...

If the production server should only be accessable by an admin or service accounts, then there is no reason why login attempts should be routinely failing with invalid account name...

curious_sqldba (5/15/2013)

---

Thanks. Few questions before i try:

i) in reality i have about 20 columns in my table, so for this new computer column would i do like checksum( col1,col2...col 20)?

ii)...

WHERE A.Pid = 9

AND ( Isnull(A.ID, 0) <> Isnull(V.ID, 0)

...

It...

sjs-36273 (5/14/2013)

---

GilaMonster (3/4/2012)

---

kilkenny (2/27/2012)

---

My first inclination was to turn on TDE, but after reading several articles, I'm worried about losing performance. If we choose to encrypt at the column-level,...

jpSQLDude (5/14/2013)

---

Thank you all, these are very helpful!

This is a production server, so I can't make *any* changes like installing software, not even Who is Active.

But what I can do...

Someone previously provided methods to return what sessions are currently accessing the database and what execution plans consume the most read and writes.

Something else that might be useful is...

Identify a specific INSERT or UPDATE statement is believed to benefit from this cache flushing. It's possible that the actual I/O isn't slow, but rather the execution plan is stale....