The page space used by deleted rows isn't even freed up until the clustered index is rebuilt, so it's still the same size of data you're scanning. If your table...

Yes, the first SQL Saturday took place in Cambridge in May 1813, where a young Charles Babbage demonstrated a...

I was at SQL Saturday here in Atlanta a couple weekends back, and it was great. Steve Busby gave a presentation on SQL Server Parallel Data Warehouse, which I found...

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