lianvh (8/2/2012)

---

Good Day ,

our IT Auditors suggested the database administrators should not be able to view the Production data . Is there way to do that or should we rather...

oferhai (7/27/2012)

---

very good script - thank you!

i tested it on 2008 and it works great - the problem is that it is not working on 2012.

for 2012 all groups and...

So, if you're interested in query performance tuning in general,...

ChrisM@Work (7/26/2012)

---

Eric M Russell (7/26/2012)

---

Lynn Pettis (7/25/2012)

---

Eric M Russell (7/25/2012)

---

I'm not a beer connoisseur and don't care for the small batch gourmet stuff. When I drink beer, I'm either drinking...

Lynn Pettis (7/25/2012)

---

Or? ...

You can index a computed column that has the PERSISTED keyword.

http://msdn.microsoft.com/en-us/library/ms191250(v=sql.105).aspx

Mark R1 (7/23/2012)

---

This is a poorly done saas implementation that another company is hosting, I have been locking down individual logins, but that does no good unless I can restrict...

I'm not a beer connoisseur and don't care for the small batch gourmet stuff. When I drink beer, I'm either drinking Miller High Life.

Style 120 actually doesn't strip out the time portion of the datetime, so what they're doing makes no sense. I doubt the...

Steve Jones - SSC Editor (7/25/2012)

---

mtucker-732014 (7/23/2012)

---

My recent experience was a rating in which my manager told me (and was obviously embarrassed to do so) that the reason he wasnt...

miapjp (7/24/2012)

---

Well thanks, everyone, I appreciate the responses! While I'd like to do database stuff all day long, working at a small business means in one day I can...

Jeff Moden (7/23/2012)

---

Eric M Russell (7/23/2012)

---

Regardless of that formal methodology is used for appraisals, I expect that most managers mentally "stack rank" the employees in their department anyhow. What we're...

Regardless of that formal methodology is used for appraisals, I expect that most managers mentally "stack rank" the employees in their department anyhow. What we're talking about here is a...

hakim.ali (7/20/2012)

---

I first heard of the stack ranking system in MBA school, on a case study. I believe it was Jack Welch, famous CEO of GE, that pioneered the system...

I can see how stack ranking would be a useful tool for a company who has a tight budget for pay raises and performance bonuses, or a company which is...