Note that THROW works well in some cases, RAISERROR in others.

Learn how to use both.

TomThomson (9/29/2014)

---

I don't think I would call SQL Server mature. SQL Server 2000 lasted long enough to become mature. Maybe SQL 2005 did, I didn't have enough...

Dev Updates:

Top priority for the IT team, which manages dev, is reducing SPAM. They are looking at integrating with ASKIMET for rating comments, but I've also asked them to think...

Update: SP4 for SQL Server 2008 is available: http://www.microsoft.com/en-us/download/details.aspx?id=44278

Congrats, Jack and Jason. Well deserved and earned.

In hindsight, I perhaps should have included another row in the sample. I didn't intend for it to imply that 1,2,3,3,4 was the result, but rather that this was the...

Ed Wagner (9/30/2014)

---

SQLRNNR (9/30/2014)

---

Melanie.Townsend (9/23/2014)

---

I've just logged a request with the developers to see if they can have a look and see if we can get the points back. Fingers...

roryp 96873 (9/30/2014)

---

SQLDCH (9/30/2014)

---

Last week was the beginning of BYE weeks, make sure your lineups are updated.

Rory remains the only undefeated team, here's hoping he and Steve get trounced this...

MiguelSQL (9/30/2014)

---

very inspirational post, thanks.

I've been thinking about blogging for a while, and the most compelling reason is career development and a way to showcase my work.

however, the most powerful...

Got lucky there, though I wish I could have used some of those points for next week 😉

Clearly a broken question. I'm not sure why this worked for me in a few tests, but I only got two results in 2012 and 2014. I suspect I have...

Nope, 3TDs, but less yards and catches than I'd expect. I was thinking he'd be closer to a 20pt/game guy.

He's playing well, but that hasn't translated into the 1st pick...

Feel free, but I'd like to get it moving. Please don't commit if you can't do it.

You can qualify with the full table name.

I find that to be incredibly annoying to read in a query, especially when I have tables like

- CustomerAddress

- InstantForum_MessageTopics

Having long names...

I'm with Jeff. If I had

SELECT

CustomerID

,Name

,Address

...

FROM

Customer

I like the alias. Not because I'd self join to Customer, but...