Kim Crosser (10/20/2015)

---

We have interfaces with other systems where...

Steve Jones - SSC Editor (10/20/2015)

---

Eric M Russell (10/20/2015)

---

It makes me wonder how anyone (regardless of whether they are a hacker or the CIO) can download records for 40 million...

The following gem will list what database/objects currently are locked by an open transaction, the type of lock used (ie: Exclusive vs. Shared) and also the SPID, login name, etc....

Let's assume a hacker can gain access to a privileged account on a highly sensitive database, like the one belonging to the federal government's Office of Personnel Management.

(OK, let...

Lynn Pettis (10/19/2015)

---

Eric M Russell (10/19/2015)

---

What % of rows are you deleting and how often? If > 25%, then you probably want to go ahead and just drop all indexes...

What % of rows are you deleting and how often? If > 25%, then you probably want to go ahead and just drop all indexes and then rebuild afterward. Another...

Indianrock (10/19/2015)

---

Yes, its not pretty. With 30 indexes on the table, I was hoping to find some to remove or change. Very difficult to do when such updates...

Lynn Pettis (10/19/2015)

---

Here is the update query initially post in a slightly more readable format:

...

Looking at this, I started having a problem following it. This is something I'd have...

To start, you would need a reference table mapping the longitude and latitude boundaries of each state, wouldn't you?

Kim Crosser (10/19/2015)

---

But doesn't Microsoft sell SQL Server against Oracle by telling everyone they don't need a DBA...

GoofyGuy (10/19/2015)

---

... by the staff grabbing...

There is a system table called sys.sql_expression_dependencies which contains references between objects, for example when a view or stored procedure references tables. If referenced_database_name is not null, then the referenced...

BL0B_EATER (10/19/2015)

---

Eric M Russell (10/19/2015)

---

GilaMonster (10/19/2015)

---

Eric M Russell (10/19/2015)

---

GilaMonster (10/19/2015)

---

I've seen bad management result in a complete turnover of the entire development staff within 3 months. That is, no dev...

GilaMonster (10/19/2015)

---

Eric M Russell (10/19/2015)

---

GilaMonster (10/19/2015)

---

I've seen bad management result in a complete turnover of the entire development staff within 3 months. That is, no dev who was working there...

GilaMonster (10/19/2015)

---

I've seen bad management result in a complete turnover of the entire development staff within 3 months. That is, no dev who was working there at the start of...