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.

Depending on what you think, look at Itzik's book or Kevin Kline's T-SQL in a Nutshell. Both good books.

I like Lynn's solutions. #1 moves the function to a scalar instead of a column that is indexed and should improve performance.

Thanks for the update and glad you found it.

Double Clicking on the error should take you to the line. It might not be always exact, but it should get you...

The mature third party backup tools provide utilities, for free, without license, that convert their compressed/encrypted backups to native formats. You can get those for SQL Backup (Red Gate) and...