Having worked in the healthcare IT industry for several years, I can see how data is revolutioning how things are done. I've contributed to a lot of cool projects that...

Abu Dina (5/21/2013)

---

We have a tall table that contains 2.6 billion rows

Table structure:

The application which uses this table has been running slow for the last couple of days and it...

Your comment is referring to the maximum 2,147,483,647...

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,...