Wayne West (10/21/2015)

---

Eric M Russell (10/21/2015)

---

If someone (or something), other than the official DBA, unexpectedly changes configuration settings on the database server, then you probably want to immediately close all...

Are you referring to the brute force dictionary query against sys logins table to get passwords? Yes, it works. There are...

One definition of a "bad manager" is one who locks themselves in their corner office from 8am - 5pm every day, or one who spends their day hovering over the...

timlenz (10/20/2015)

---

Mike Fal (github.com/MikeFal) did an excellent presentation to our SQL Users Group on configuring your servers using PowerShell. By having the configuration setup he was able to install a...

SQLCurious (10/20/2015)

---

Thanks, Eric. Unfortunately, that's not enough for me since it will only tell me that the object has been modified...that too the most recent one. I need to know...

The following will return all objects modified today.

select * from sys.objects where cast(modify_date as date) = cast(getdate() as date);

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?