That stat has been gathered in survey's we've contracted out for from Redgate Software. Each year we hire professional surveyers to contact database people across a wide range of industries...

In 101, I get this returned:

The formatting returns mm/dd/yyyy, which means we are ordering by month first, then day, then year.  For a character set, "02"...

It really depends, but the OFFSET runs the full query and then trims out the results. You might be better with a WHERE clause with good indexing.

thanks, this has been corrected.

I can add things to my briefcase (articles, posts, etc.) and they stay, but a test account has some issue. There is a flash when I refresh the briefcase and...

I'll submit a bug. About to jump on a plane, so can't really test this minute.

What exactly are you doing with your code? If you are moving lots of data, this will be hard.

You don't need a temp table. If you select with row_number(), you'll...

London would be interesting. The SuperBowl is such an event and exepnsive. Likely not much more cost in London than LA for attendees.

Long as they don't change the time, which...

Glad you liked it. If you find a good, specific use, would love a short 1-2 page article on the way you use a computed column. Always good to help...

Thanks. I'm working on the next item which is custom automated container builds.

Anthony Notencino and Andrew Pruski have blogs on this site, and they have a bunch of container posts....

Ah, sorry,. Geoff. It looked like SPAM. I'll clean it up.

I find a lot of this in sports. Certainly when I coach we look to spend more time on things we don't do well than things we do. Hard to...

I think you are rubbing off on Denver....

I'll just keep giving thanks to the Yahoo gods that gave me Aaron Rodgers.

Welcome and please feel free to ask questions as you need help.