Meetings can be useful, of course. Even lots of meetings, so long as it doesn't become a career. I've had major projects that required hours of meetings in...

Jack Corbett (11/28/2011)

---

So I had to post this job description I got via email today for a SQL Server DBA position:

Qualified candidates will possess programming skills, such as skill in...

Another thing you can probably do is write a DDL trigger that tracks stored procedure creation and alteration, and which blocks creating them if they have "update" or "delete" or...

You might want to do an explicit denydatawriter to make sure that's fully covered.

ken.trock (11/28/2011)

---

The single most common cause of both work overload and project failure is doing work twice. The most common cause of that is picking up some piece of work...

Best rule I know for moderating that kind of behavior is to remember that it's perfectly okay to think you're the most important person in the world, just so long...

Yep! I can just imagine...

Kiara (11/28/2011)

---

L' Eomot Inversé (11/28/2011)

I was beginning to think no one would react like that - 6 whole days with those two quotations in my sig and not a...

GilaMonster (11/24/2011)

---

I think you mean GF (Grant Fritchey), because last time I checked I didn't work for...

"Stress" is primarily an endocrine reaction to fear or anger.

In this case, it's primarily going to be low-intensity fear, engendered by a threat to project success, as a reaction to...

Are you familiar with IN clauses, and with Group By and Having?

select *

from dbo.MyTable

where MyColumn not in (select MyColumn from dbo.MyTable Group By MyColumn Having count(*) > 1);

Alternative, a Where...

Okay. In a query that's already that complex, do use a UDF for a little more readability.

One thing you might want to do is break out each of the...

I'm not sure how you'd do replication without a snapshot being used somewhere along the way.

Brandie Tarvin (11/23/2011)

---

And now for the public flogging moment of The Thread as I post a semi-technical question that is sure to get me lynched.

We have a Word 2003 document...

Has to be one at a time, or rebuild the table all at once.

The way I usually do this kind of thing looks like:

select 'alter table dbo.MyTable alter column ['...