Pequod

GilaMonster (10/10/2013)

---

The thing is, according to the OP that's not what the interviewer was asking. They were asking how to update to B then back to A in a single...

dwain.c (10/9/2013)

---

Am I the only one left speechless and flabbergasted by this post?

http://www.sqlservercentral.com/Forums/FindPost1503017.aspx

I used to teach 2 methods to swap A and B in entry level university FORTRAN course (too)...

Michael Riemer (10/10/2013)

---

Although easy if you know it and logical if you don't (since the other three aren't actually database tasks).

I don't think the documentation is very clear in highlighting...

Hugo Kornelis (10/9/2013)

---

L' Eomot Inversé (10/9/2013)

---

It would be nice to know what the real reason for excluding those statement is, and whether it has any validity or is just silliness,...

Hugo Kornelis (10/9/2013)

---

If Tom asked me a question in this topic, I overlooked it. I still don't see...

timwell (10/9/2013)

---

Does this explanation from the MSDN forums answer the question?

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/258beea6-f797-4b28-9ba5-aec36b9bc3b2/error-handling-in-user-defined-functions?forum=transactsql

I am not sure I understand the connection. Maybe it would not even get to the CATCH because the...

This is a problem which Date's 6NF is ideal for. The vertical design is a big problem, history shouldn't be a record of changes if you want to be...

Nice question.

I've never understood why try...catch was banned in functions, but the explanation for this question provides a clue. I'd never seen the error messages, and their text is...

The ratio is going to depend enormously on what needs doing.

If the shop is doing a little bit of application development but handling hundereds of production servers with...

I agree too. But Jeff understated it, this stuff...

Stefan Krzywicki (10/8/2013)

---

Hey Steve

There's a formatting error in my article today that causes all the code to be outside code boxes. Should I fix this and re-submit or is this...

Jeff Moden (10/6/2013)

---

I'm not actually looking for a job but it's sometimes a good thing to check on what the going rates are for different jobs. I'm seeing a...

Jeff Moden (10/5/2013)

---

I hate moderated...

Well, back in 2009 SANS published its list. It was going to be regularly revised. In 2010, there was a revsion, and an archive of the 2009 version...