GilaMonster (12/10/2010)

---

It's only valid when shrinking the data file. If you shrink the log and specify that option, it's ignored. It's the same as doing...

For clarification, are we talking about shrinking datafile and logfiles?

Also, what about truncate only?

For instance, I've found myself using shrinkfile truncate only for logfiles once every few months after a...

I guessed wrong. Figured I had a 1/128 chance of getting it right... can't win if you don't play.

Very interesting information, and I appreciate it. Way too many answers for this early in the morning though 🙂 Is that 1/256 statistically?

Dogpile on Carlo. Give him a dutch rub. 😉

I'm short. Don't tall people make more on the average? :discuss:

Craig-315134 (10/4/2010)

---

pjdiller wrote:

I think the Technical IQ vs. Emotional IQ has some validity, but I think it has more to do with interest than ability.

Very possibly so, my friend,...

Without trying to explain why this is, back to the stone age, let me say that I think the Technical IQ vs. Emotional IQ has some validity, but I think...

Party On Dudes!

I have to admint I wouldn't have gotten this one right, except for a similar question a few months ago. I still don't understand why one would want to...

Thanks very much! This is a question that applies to the category of "things I need to know and will probably run across" and the answer is straight-forward/simple! ...

I think a nice or good question is one that includes the correct answer as an option. This is not one of those. I choose to reserve my...

Done.

Also voted this up:

https://connect.microsoft.com/SQLServer/feedback/details/533288/allow-backup-restore-snapshot-databases

I know that databases can be restored from existing snapshots:

RESTORE DATABASE database_name

FROM DATABASE_SNAPSHOT = database_snapshot_name

I figured the question referred to this, but it must not have... and I was...

JF1081 (7/21/2010)

---

Lol, I saw the word "definitely" and immediately thought: nope, it depends. I have no substantial backing for that thought as I know nothing about computed columns, but...