I like the snapshot method for Enterprise edition.

An alternative would be to detach and reattach during a maintenance window. The caveat here is to ensure a backup is performed first,...

I think I have an idea of how you got to where you are with these tlogs and vlfs. I have just been able to repro it with the...

Jacob Wilkins (7/27/2015)

---

Check the columns...the data is misaligned with the actual values because the header RecoveryUnitID takes up as much space as the first two columns of data.

You just have...

Your Loginfo results are a bit wonky.

It shows that the first vlf is 8kb and the second vlf is ~1090mb. This is not normal.

Second piece of wonky is that...

Congrats

GNATS

Jack Corbett (7/27/2015)

---

Brandie Tarvin (7/27/2015)

---

SQLRNNR (7/27/2015)

---

Brandie Tarvin (7/27/2015)

---

Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.

Thanks for...

Luis Cazares (7/27/2015)

---

That was exactly the point of this article, to differentiate RBAR...

One niggle. The looping-set update is not technically RBAR since it is performing groups of set-based operations. Maybe it should be called SBAS. 😀

I have used this method many a...

jasona.work (7/27/2015)

---

Came here for an interesting discussion on people using (or trying to use) Express Ed in production, got 7 pages of "poorly worded question" posts instead.

Which, having seen the...

Brandie Tarvin (7/27/2015)

---

Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.

Thanks for bring up the topic, Jason. And hold...

Toreador (7/27/2015)

---

SQLRNNR (7/25/2015)

---

Well, if the view does not exist or is in a different schema, then the third option is correct even though it truncated part of the error. ...

TomThomson (7/25/2015)

---

Actually none of the options is correct. The third is just plain wrong and the others each omit the first column (name) from the returned row.

What is...

Are you getting an error during the install?

I have installed it several times separately, so I would expect some sort of error if it is not working for you.

outre-mer