cfradenburg is correct. You can install your database if you script it, but if you have used any features that are limited by edition, you will not be able to...

I don't have the dev exams for the MCM, but I could take the test. I assume if I passed I'd have to go backfill the dev exams to get...

Interesting. It seems almost as though some of these questions are at too low a level. I might instead ask more development philosophical type questions:

- How important is it for...

You have the fundamental design here for sizes. They are related to the product, but there are many of them, so they are a child attribute.

In terms of a campaign,...

Each CU is listed as being for RTM or for a specific SP. You must have installed that level before applying the CU.

The build list for 2008 is here: http://www.sqlservercentral.com/articles/SQL+Server+2008/63491/

The...

I would tend to listen to Allan as he's had a lot of experience with clusters.

However, I would use VMWare/VirtualBox/HyperV to set up a test cluster and experiment there.

We are running SS2K8 here at SSC and see no reason to upgrade now. We don't do a lot of BI work with the production dbs that back the site.

LOL, I don't always try to make the questions hard. I typically write 5-10 at once, so I balance them out as easy and hard.

Richard M Karpel (5/20/2011)

---

If the data is store outside the database this is true but according to the white paper found at http://msdn.microsoft.com/en-us/library/cc949109%28v=sql.100%29.asp Then the limitation does exist as...

Yes and no. You can disable 8.3 name creation in NTFS (http://support.microsoft.com/kb/121007), and that is required for FILESTREAM. Or at...

mohammed moinudheen (5/20/2011)

---

Steve, thanks for the question again.

There is one thing I noticed in your questions-mostly the answer to your question is usually the first choice in the option list...

jmadsen 98862 (5/20/2011)

---

Bottom line - don't work for the highest $$. My highest paying jobs have been the worst. I don't think that's coincidental, I think they know the job...

What I have done is store full backups with the log files. you don't want them with the data files because they're the same thing and if you lose that...

OK, not sure I completely understand SQLRNNR's solution, but Jason, that is cool. Tested a few combinations and it seems to work very well.

Thanks.

Sorry, I saw your code and my wife came home from 3 days in Boston. Got distracted 😛