I think many of the issues with the code sample or screenshot above are from many more people coding that just don't have good skills or habits. They make poor...

And let us know how it works.

If you're interested, the decision you make and why, as well as the result of the implementation, would make a nice article to publish...

This isn't a Redgate survey. It's a contracted survey that includes our customers, but there are plenty of non-customers in there. It is hard to get people to respond to...

+1 for replication then. Linked servers usually create headaches.

Interesting article about the Nats and stats

For the Nationals, a Former Bat Boy Mixes Numbers and Tradition https://nyti.ms/2MMyqWt

Lots to consider when making this decision, and for me, the technical work is the least important part.Too many other things get in the way around the technical work, so...

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...