1. In general it costs just as much to develop code with poor performance as it does to develop fast code. The same can be said for security. If you...

There is mundane & there is Administrivia.

Mundane suggests something needs to be done & it is not very intellectually challenging for you to solve it. Perhaps it was once...

Most people talk as if Locks & Latches do the same thing. They stating a Latch is a lightweight version of a Lock, which really doesn’t tell you much. I...

Thought 1: Depends on the Industry. eg: Horseracing; I speculate that short people earn more as jockeys...

However does that mean that women need to act like men because more men are in charge? Or that men aren't paying attention to valuable input from others because they...

Sure a female doll & doll house may be hard for him to relate to. But...

I was disappointed by this article. I felt cheated of an opportunity to gain insight. Clearly you are well qualified & possibly able to provide new input on a complex...

So it seems that we are all in agreement.

1. It is best that the system is designed to avoid these issues in the first place. This is similar to...

trubolotta (9/22/2010)

---

This appears to be one of those articles that creates a problem based on poor design and purports to correct it using some bloated functionality of SQL Server. ...

jun.merencilla (9/22/2010)

---

good article. but i would not do this simply because there is a more straightforward way.

select distinct *

into #Emp_Details

from Emp_Details

truncate table Emp_Details

insert into Emp_Details

select * from #Emp_Details

though...

SSC Eights

Interesting. I had assumed that his table had a PK but he was ignoring it as I'm often forced to. Why? Because it is an Identity Col, we know...

Nice article & Nice solution. But I would caution anyone about to blindly using this in production. It is only the 1st part of the process.

Problem 1: need to...

This is the best advice...

I agree with you absolutely, in the ideal world. Now, the real world is a much different story. Bad managers fire good people all the time! Why? because they usually...

Microsoft has been doing this for years.

They have an annual POLL online questionnaire. The answers are collated by 3rd party so by default you remain anonymous, unless you choose...