OK, I'm confused.

The TRUNCATE ONLY is for the backup of the log, correct?

Do you have a 300GB data file, or database? Are you shrinking the data file somehow?...

yes

Have you tried something like this to be sure of the contents:

http://www.sqlservercentral.com/scripts/Miscellaneous/30852/

Are you sure the file is growing? Meaning have you detected auto grows, or monitored the actual file size?...

P-V, physical to virtual migration. Essentially snapshot the Windows OS as a point in time and recreate as a virtual machine. You can leave the physical, and bring up the...

I'd change the db owners to a new account, since it shouldn't affect anything if you make the change. Use "sa" or another real account.

For the other stuff, I...

Interesting link, but that talks more about the organization and benefits. This guy was having trouble understanding the concept of the entire machine being emulated. If they can't get that...

Is this account the owner of the databases or is it mapped to "sa"?

The installation shouldn't matter. It's the access and perhaps ownership of this account. The SID should stay...

Mark has an ORDER BY, but you need to be sure one is included. Without an ORDER BY, there is no such thing as a consecutive record. The rows have...

I'm not sure how big...

How did you explain virtualization to him? I ran into someone, a dev, a couple years ago and it was was a struggle to get him to understand the idea...

Slight exaggeration, perhaps a bit of a poking by a...

GilaMonster (1/17/2012)

---

Personally I just find it hilarious that the US denounces that kind of censorship in China and Iran, then considers implementing it at home. "Do what I say, not...

I was hoping Google/Facebook/Twitter would join in, at least the .coms.

It's a good way to protest, and show the...

Hugo Kornelis (1/17/2012)

---

A good question, and it's hard to see how anbody could contest the correct answer.

Although in the spirit of nitpicking, I could argue that the format one should...

Lots of companies have had sites hacked. Hotmail has been hacked numerous times, does that mean that MS can't handle security?

Tons of company sites have been hacked and they never...