Steve Jones - SSC Editor (4/28/2015)

---

Ralph Hightower (4/28/2015)

---

In the "Understand the True Source of Problems" article:

2 – NOLOCK is required on every query. It makes things run faster.

Instead READ_UNCOMMITTED is...

One problem you will encounter when digging into root causes is that your search will often need to cross departmental or even oganizational boundaries, especially in the realm of data,...

PHYData DBA (4/27/2015)

---

Eric M Russell (4/27/2015)

---

PHYData DBA (4/27/2015)

---

We would be running anything...

PHYData DBA (4/27/2015)

---

We would be running anything after 2008R2 if any of...

I wish Microsoft would drop support for v2008R2 this year; I'd love to upgarde to v2014.

Gary Varga (4/27/2015)

---

...and then read your post and feel patronised??? That's not collaboration!!!

(I am assuming that...

Gary Varga (4/27/2015)

---

...and then read your post and feel patronised??? That's not collaboration!!!

(I am assuming that...

I've been told by exectutive management that we'll remain on 2008 R2 until Microsoft drops support... so...

I'll step up to the plate and work 50 hours a week, if there is a deadline approaching or when troubleshooting an issue in production. Also when learning a new...

Jeff Moden (4/26/2015)

---

...

The other type is probably not what most people would expect. R. Barry Young coined the phrase for these "set based loops" (which is exactly what I...

I've heard that public shaming works.

stevenp333 (4/27/2015)

---

I wonder whether any companies use the DevOps idea to draw developers into a support role and then shut the gates behind them?

It might be that many large established...

Steve JP (4/24/2015)

---

There is a senior who wants to replace all the inline sql statements with sprocs. Well fine, the application will stop looping through 1000 inline statements and now...

If users demand access to the 'SA' account, then give it to them.

But first get rid of the default 'SA' and then create a new one having only the permissions...

If a database architect, IT support, executive, or BI developer needs eleveated permissions to troubleshoot performance issues or run ah-hoc queries in production, you can setup something like a power...