Luis has shown what's the easiest way for 2008. Use a CTE that inserts a row number to order the data and determine what the previous row is.

I'd also suggest...

If you're mirroring storage at the SAN level, why the AG then? That seems redundant, unless I'm looking at this wrong. The idea with the AG is that it's sending...

That shouldn't be the case.

In fact, whether you use SSMS on your machine to connect to the prod instance, or on the production server console to connect to the production...

David.Poole (5/25/2016)

---

I think there is scope for a "Stairway to DB source control". I'm not volunteering for it as I'm too much of a beginner.

I've just about got the...

shok0002 (6/7/2016)

---

I like to read articles before bed with my device in portrait orientation. After scrolling past the site links and related resources panel, an estimated 30% of the page...

Cary Hower-563110 (6/7/2016)

---

I agree that 57418 (from the most current order) will be returned for each row and that all three rows will be returned. However, the list of answers...

Restart the Windows host? Power down, power on.

That's a restart. Pending operations are those that occur when the...

Pensacola was great as well. Smaller than the past, but still a good 150 and a fun event.

The move requires SA, so it's not free, but it's certainly...

I think draft is usually about Labor Day. Dan sets it late, just before the opening Thur game.

Certainly it's hard to make a stable schema, but I also think that databases are supposed to evolve over time. We don't really keep stable schemas. We add things.

So.

AdventureWorks. If...

Yeah, earlier than 2014. My typo. I was thinking 4.2 and typed 2014. I've been doing a lot of 2014 stuff for demos and my instances is .\SQL2014.

One more you might want to give to managers, especially IT managers is The Phoenix Project - https://www.amazon.com/Phoenix-Project-DevOps-Helping-Business-ebook/dp/B00AZRBLHO?ie=UTF8&btkr=1&ref_=dp-kindle-redirect

You should just restart the windows host, not delete anything.

It's been pointed out this is a bad idea. Some companies do this, even large ones, to make AD admin easier.

However, this is an issue for me. If I need...