The Stairways are a great way to learn about particular topics.

Your question about learning SQL Server is more like "how do I learn about government" than "how do I learn...

You can also use the tools from Sysinternals to find out if the file has a lock on it.

jeff.mason (7/20/2012)

---

Steve Jones - SSC Editor (7/20/2012)

---

There was a slight typo in the original question, and I mistakenly added another in fixing it. It should have been:

12:10 AM - Transaction...

Perhaps not. Replication can work, but it's a lot of administrative overhead. AlwaysOn is easier to administer, but $$. Depends on your resources.

If you want to go to the cloud,...

krystian (7/20/2012)

---

The question was which transaction changes will be contain in the full backup?

In my understanding all transaction changes until the point where backup finish are recorded in the backup...

There was a slight typo in the original question, and I mistakenly added another in fixing it. It should have been:

12:10 AM - Transaction 1 on QotDDatabase begins

12:11 AM -...

2) you have the backups, so you have HA. They can be restored on another instance.

3) replication can provide the HA if you have all the data replicated. There's no...

paul.knibbs (7/20/2012)

---

But if we did that, how would we keep...

AFAIK, the tool comes with the Litespeed install. Unless things are changed, there was a converter to move compressed->native that was a .exe in the folder where you installed it....

I'm sure that's a typo. Probably the author is used to typing raid 5 and copy writers didn't realize. RAID is mentioned a number of times, and it says TPC-E...

derek.colley (7/20/2012)

---

The problem is, it's all relative and totally subjective. There's too many factors affecting the bell(end?) curve, from how you and your job is perceived through to your...

tj 83432 (7/20/2012)

---

What is the purpose of any of these companies using Stack Ranking? We used it throughout my USAF career, but the driver was the service's "Up or...

mtucker-732014 (7/19/2012)

---

Thats a crazy system!

If you did have a group of people to begin with that had people who were 1 and 2, after you had weeded them out you...

Ugh, shooting in CO last night, just north of here if you haven't heard. Crazy. My son wanted to go see Batman last night (not that theater), but my wife...

GSquared (7/19/2012)

---

And I'll add my vote to "get rid of time zones and DST". The positive effects on cross-time-zone calls and so on ("call me after 6 PM", "webinar...