milzs (1/18/2012)

---

I have seven development PCs sitting here at my desk, including a "souped-up" one that cost over $5K. Add in a 21" monitor, a ScanSnap scanner, and a...

There...

I think we're close now 🙁

Jason is right here. I was asking for clarification to understand if you were talking logs or data.

You should never shrink data files as part of regular maintenance. Ever. It's...

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...