Design question: Why would you use this approach?

If each of the ten indicators are mutually exclusive, they should be listed in a single field as a status flag or something....

Tony++ (11/29/2010)

---

* I've made the change for select rather than update, thanks for the pointer on that. I can't say that I understand why the select IX should be...

WayneS (11/29/2010)

---

CirquedeSQLeil (11/29/2010)

---

Well, 92 was my final...

Direct quote from here: http://sqlblogcasts.com/blogs/christian/archive/2008/06.aspx

The first interesting ones I’ve looked at are the new PREEMPTIVE wait types. Any code that needs to execute outside SQL Server has to go...

Kit G (11/29/2010)

---

I tried importing using the Import/Export wizard, but that crashed and burned without really telling me why. But I figure it is because there are merged cells...

Tony++ (11/29/2010)

---

This article describes exactly what the code is trying to do (get an IX lock via an empty update), and may have been where the idea came from. ...

kcinman11358 (11/29/2010)

---

A very simple answer to this is if you are connected online, you could have lost your connection briefly and when it sent a signal, it didn't receive anything...

You'll pardon me if I'm inaccurate, but this is similar to a classic homework problem.

Please show what work you've done and we'll help you get unstuck. Check the first...

Nah, of course not... It runs on Oracle. 😛

Yes, afaik SSC runs on SQL Server, 2k8 if memory serves.

Well, you can get by pretty damned well in the states at $100/hour, so perhaps it's time to look into grabbing a visa? 😀

Side bonus, better internet!

On a comment you...

allin1 (11/29/2010)

---

I am at teh start of my career as DB Dev/DBA (2 yrs). I am in a small company with no challenging work. I was wondering what would be...

You have to specify the code page, 1252.

See here:

http://msdn.microsoft.com/en-us/library/ms180175.aspx

Future note, easily located via google. Search sql server collation CP1. 🙂

Ninja's_RGR'us (11/29/2010)

---

1 bazillion years of experience is going to cost you, period. We just happen to love sharing with people which makes useven stronger DBAs, but I'm...

Side note, I live in a desert, in a place called 'Valley of the Sun'.

Global warming my arse. I think I just frosted my toes off having a smoke.

http://www.google.com/#sclient=psy&hl=en&q=phoenix+weather&aq=f&aqi=&aql=&oq=&gs_rfai=&pbx=1&fp=567204dc07534ddc

GilaMonster (11/29/2010)

---

I bill $100/hour,...