ggeier (6/6/2013)

---

IIF isn't supported in 2008, it's new to...

2008R1 tells me:

Msg 102, Level 15, State 1, Line 9

Incorrect syntax near '='.

It doesn't appear to like the @a = @b-2.

Eric M Russell (5/31/2013)

---

I was at SQL Saturday here in Atlanta a couple weekends back, and it was great. Steve Busby gave a presentation on SQL Server Parallel Data Warehouse,...

I didn't even notice the varchar(max), I figured it would fail because there is no comma between it and the constraint. Still got the right answer.

I remember when I first got into IT some 15 years ago. I was working for a grocery chain, and a big industry topic was about customer loyalty cards....

I think my main goal for 2013 is to learn about unit testing, primarily in Visual Studio but also in SQL Server. Also want to learn more about performance...

I've had managers who would come in and "supervise" even the smallest issues. I've also worked on projects where we would waste 1-2 hours a day in status update...

I saw plenty of this at my old job. No one was safe, unless you happened to be on the CIO's "good side". I saw some very talented...

L' Eomot Inversé (10/22/2012)

---

roger.plowman (10/22/2012)

---

1) They're too busy to beta test software.

2) They're not too busy to call and complain.

3) They don't remember you have to sleep.

4) 18/7/365 on...

roger.plowman (10/22/2012)

---

It must be nice to have a team of developers on call. :hehe:

I work for a fairly small company (about 150 employees) and I *AM* the IT department. Support,...

I used to dream of being a rock star, or at least a full-time musician. But I was too lazy to really work at it. So I became...

Variables in SQL are not block scoped - you can put variable declarations between begin and end and use the variables after the end.

I have a vague recollection...

But there are also people who will shine no matter where you put them. It's just, sometimes, hard to see the "shine" when it's buried under a pile of...

For some reason I expected the 10/0.00001 to fail, expecting SQL to convert the 0.00001 to an integer with the integer 10 being on the left of the equation. ...

My first exposure to SQL code and a good solid database design was on Informix! I learned a lot about design and good coding practices from that system, but...