Or upgrade to R2 on the server you are restoring to

Second vote for this.

Manage your log files, do not truncate them.

It wasn't aimed specifically at you, but...

Congrats again, Jeff, and a nice ceremony for you and a nice speech from you. The award was well deserved.

Just an FYI, since many of you post often, this thread is a little inappropriate in terms of responses to the poster. I know he's a troll, or lazy, or...

For the original poster: Please use a search engine or Books Online to research these questions. We are happy to help you with specifics, but without any effort on your...

Ease is relative. A backup restore requires double the disk space of the data (backup file + database mdf/ldf). An attach requires the space only for the mdf/ldf.

The physical name...

FYI, not sure if you saw it, or can see it, but Dr. Dewitt's talk on Big Data and Hadoop is great: http://www.sqlpass.org/summit/2011/Live/LiveStreaming/LiveStreamingFriday.aspx

It's OK. Not sure about the quality, but it's...

mannaggia (10/18/2011)

---

That's one downside to the Developer edition IMHO - unless the developers have a feature matrix handy, they may use something that you don't have in the production environment...

a-241529 (10/18/2011)

---

I would personally love it if the server came with all the features, and like Express it limited hardware. I would like it even more if the increments,...

Knut Boehnert (10/18/2011)

---

One other problem is the enforcement. While I like the idea to pay by scale how can unscrupulous customers be forced to pay the right scale?

So buying one...

Not sure I implied it did. It's all sales/marketing, or maybe all marketing/execs....

pvoutov (10/18/2011)

---

There are two different ways to calculate weekly returns. The methodology you're using implies holding for an entire week (using weekly prices). A more complicated methodology would compound daily,...

My apologies. I've uploaded the prices.sql file now. You can download it from the end of the article.