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

Look at restore filelist only - http://msdn.microsoft.com/en-us/library/ms173778.aspx

I recommend you not back up multiple backups to one file. It's a risk that's unnecessary and any problem with that file means you...

Dev @ +91 973 913 6683 (10/17/2011)

---

Your boss shouldn't really run your schedule, but tracking down the things you spend time on and examining them later is a good...