Good question.

But it's sort of easy; you are telling sql server which CPUs it is allowed to use (alter server configuration set processor affinity); and you are...

GilaMonster (8/15/2011)

---

Hmm, I can pick up 4 x 1 TB drives for around $300. RAID 5 config, 3TB internal. Should last for a while.

Or I can get 4 x...

Laptops with a TB...

Important subject, good question, wrong answer - it should allow two answers to be ticked.

As it only allows one item to be ticked, all the people who chose...

It's more than a year since this editorial was published, so I'm joining in the discussion extremely late.

I tend to be a bit like Andy Warren - surprised...

Not too bad though -...

MadTester (8/12/2011)

---

Hi Tom,Nice to hear my environment is far better than I thought. The picture you paint is bleak.

My circumstance is legacy columns, too many indexes on high trans tables...

Not really clear what you require; maybe you are after something like

select L.emp_id, IsNull(emp_name,' ')

from (select 1 emp_id union all select 2 emp_name union all select 3...

You can't really mean that, or you would have moved to live in Fort William.

I guess what you have to ask yourself is if the fonts you are using include the characters encoded in the unicode string. If you have some Chinese characters...

Bruce W Cassidy (8/11/2011)

---

All the same, if you're beginning the process of repairing such a model, having a code generator to check for the duplicates would make sense. I'd...

Ninja's_RGR'us (8/11/2011)

---

Tom.Thomson (8/11/2011)

---

But which is crazier there - the locking hint or the tortuous where clause (getting rid of...

Bruce W Cassidy (8/11/2011)

---

In my own designs, composite keys tend to occur on many-to-many relationship bridging tables, so not necessarily a natural...

But which is crazier there - the locking hint or the tortuous where clause (getting rid of all those...

Bruce W Cassidy (8/11/2011)

---

Nice change....