Pravasis (4/14/2013)

---

Mansfield (4/11/2013)

---

1. Joining integer columns (provided that they are correctly indexed) is faster than joining other data types because it is relatively straightforward (see below)

2. It depends....

ulisseslourenco (4/12/2013)

---

Hi people,

I have a question about nolock. I work in a company that there is a rule: all select query we must put nolock. If we don't put it...

In the example below, I've created a stored procedure called [acct_staging_truncate] which truncates a table. The user 'acctmaint' is db_owner, and user 'JoeSchmo' is a public member with no permissions...

Regarding vendors who support a client owned server, or clients who lease a vendor hosted server, there can be an account setup with elevated permissions that you enable or disable...

patrickmcginnis59 10839 (4/8/2013)

---

Eric M Russell (4/5/2013)

---

TravisDBA (4/5/2013)

---

Eric M Russell (4/5/2013)So, an a-hole boss will inevitably surround himself with either a-hole subordinates or mediocre supplicants. Meanwhile the most talented people will...

Jeff Moden (4/7/2013)

---

opc.three (4/7/2013)

---

You keep throwing this one back...

Miles Neale (4/5/2013)

---

Eric M Russell (4/5/2013) In professions like engineering, scientific research, and defense, emotions just get in the way. At least that's the case at the lower...

TravisDBA (4/5/2013)

---

Eric M Russell (4/5/2013)So, an a-hole boss will inevitably surround himself with either a-hole subordinates or mediocre supplicants. Meanwhile the most talented people will simply walk out the door....

TravisDBA (4/5/2013)

---

Eric M Russell (4/5/2013)

---

Belittling and sabotaging the efforts of co-workers goes beyond insensitivity. Fortunately where I work someone like that wouldn't last long. If one is not part of...

Belittling and sabotaging the efforts of co-workers goes beyond insensitivity. Fortunately where I work someone like that wouldn't last long. If one is not part of the solution, then one...

Are you asking what the SQL Server equivalent of Oracle's EXPLAIN PLAN ?

Perhaps this is...

In the more social professions (like healthcare, politics, and education), emotions are vital. If you don't have people skills, then you're basically just not qualified for the job.

In professions...

opc.three (4/4/2013)

---

Eric M Russell (4/4/2013)

---

Case in point: Just this morning I was asked to rename a database (AbcCorp -> AbcCorpOld) in the DEV and QA environments and then...

This is beginning to sound like the "Why do we need Cursors?" debate. Just like cursors, I'd be highly sceptical why anyone would need to leverage xp_cmdshell in a stored...

Steve Jones - SSC Editor (4/3/2013)

---

Very interesting discussion.

Opc.three, you did bring up a few good points, but this isn't one of them.

opc.three (4/3/2013)I understand how xp_cmdshell works but if...