SanDroid (4/7/2011)

---

You have references to validate the incorrect answers, but not to the correct one!?!?! :sick:

Looks like 90% if the people that tried to answer this question did not understand...

Stefan Krzywicki (4/6/2011)

---

WayneS (4/6/2011)

---

Stefan Krzywicki (4/6/2011)

---

CirquedeSQLeil (4/6/2011)

---

Roy Ernest (4/6/2011)

---

Gail, Low blow aimed at Lynn... 🙂

I remember Star...

Stefan Krzywicki (4/6/2011)

---

CirquedeSQLeil (4/6/2011)

---

I...

How's this?

DECLARE @test-2 TABLE (MyTime VARCHAR(4));

INSERT INTO @test-2

VALUES ('1425'),

('945'),

('1258');

WITH cte AS

(

SELECT MyTime,

...

Well, I tracked this down to a procedure running through a job (I forgot to disable/delete it after finished with testing it), and in the process I learned something I...

bitbucket-25253 (4/4/2011)

---

CirquedeSQLeil (4/4/2011)

---

Well, if you want, we can certainly nitpick...

Well, it looks like I (finally) got a QotD question that didn't have everyone up in arms over it... whew!

Lynn Pettis (4/4/2011)

---

Roy Ernest (4/4/2011)

---

Jeff, I have been having some bad time with accidents during the past one and a half years. One car was totaled and bought this new...

You might want to check out http://www.brentozar.com/sql/blitz-minute-sql-server-takeovers/. This script is from a SQL Server "Microsoft Certified Master" that goes through examining everything on a server that you would be interested...

Thank you Jeff and Grant. These are excellent responses - and to be honest, a little bit differently from what I expected. Basically, from what I'm seeing, the basic CRUD...

So, whose more glad about that... you or your family?

I wonder how well a CLR function of the .net SPLIT function would perform...?

FYI - I have it on good authority that a newer, faster version of this is in the works. Keep...

opc.three (3/31/2011)

---

Wayne, I hear what you're saying, and you are absolutely correct, but it's not exactly relevant to my comment. I concede I could have worded my post better but...

LutzM (4/1/2011)

---

I recommend to google for "scarydba nhibernate". Obviously, Grant provided several excellent posts well worth reading including additional links (as well as covering the reason for the effect described...