Awesome article, especially the part at the end.

One things that might be worth pointing out is that while there are genuinely good times to use cursors, most of the time...

Steve Jones - Editor (1/1/2009)

---

It's definitely a business decision, and I'd recommend C# if it's not substantially more expensive (time and money) for your people. If they have a lot...

mtassin (1/5/2009)

---

I dunno if this qualifies as a weird case where you need a cursor or not.

Certainly if this could be done as one big set based query, I'd go...

Thanks Jeff and Wagner.

I took a class on database theory that used Oracle for all examples, but for the most part I have used SQL Server. Even...

Jeff Moden (1/1/2009)

---

I believe that articles like this one serve as a great disservice to anyone new to databases and believe that it's horribly irresponsible of an author to try...

Well, one that comes to mind is included columns.

Just out of...

Are you using the Fully Qualified Domain name?

Also, how do the domains communicate?

Those are all great options, you can also use OpenRowset with select into to avoid setting up a permanent linked server.

Also, you can look at a combination of SQL Compare...

I am not myself a perl programmer, but this was both enlightening and a fantastic piece of work.

Kit Brandner (12/22/2008)

---

Consider the one exception I've encountered - generating a variable number of PIN codes according to a proprietary algorithm. There are easily several set-based approaches, but they run...

SSMS is SQL Server Management Studio, it replaced The Enterprise Manager that...

Jeff Moden (12/21/2008)

---

timothyawiseman (12/21/2008)

---

Two things of note though are that it is sometimes faster to code the procedural solution than it is to code the set based one, largely due...

Hugo Kornelis (12/19/2008)

---

Sorry Steve, but I have to disagree with you on this one.

Indexed views are not an index type. They are a special type of view, created by creating...

I fully agree with Gail that column order should not matter in SQL and generally the answer to changing column order is just to reorder the output in the select...

I agree with Ninja, this will likely quickly become one of the longest threads on the site.

With that said, I personally have never seen a sql procedural solution which is...