Likely have some job security though. With uneducated staff, always need to keep a few people around that do know something.

All those _WA are system created, and they do get created, as Mike noted, in response to queries. If the statistics tell the optimizer that your index may, or may...

Wear the tux

That's likely working well. If you do some testing, especially with larger offsets, you might get some confidence that this works better or not.

It is interesting how we deal with things. I have 5 email accounts that I need to watch (3 work, 2 personal), and I find that in the Hotmail one,...

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.