As you said, there's lots of debate on whether or not a certificate is "worth" anything. But if you're confident you can pass and your company is paying.... "it couldn't...

SQL Server 2008 sp2 cu2 - latest 2008 release

SQL Server 2008 R2 cu6 - latest 2008 R2 release

There have not been any service pack releases for SQL Server 2008 R2....

From my experience, don't think that it's tough to find a position with little real world experience. I've seen many people straight out of college with no on the job...

I go with what MS says.

"A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this...

Keep in mind that TDE encrypts data "at rest". Meaning you can't open the .mdf file in notepad and gather plain text data. Also, TDE doesn't stop someone from logging...

You are right. It is not normalized as far as the objectName, counterName, and description are concerned. This data is populated by pulling from a DMV which is why I...

I just wanted to give you props for posting

1:ddl script

2:sample data script

3:expected results

You can do it one of two ways.

A:

Create a user for each login

Create a user defined database role

Add each user to that role

B:

Create a windows security group in your...

I'll chime in to try and spur some conversation.

I'm not sure how MAXDOP works in detail or what effect it has on query results but I'll touch on something you...

Select

Orders.OrderId,

Orders.OrderNotes,

OrderDetails.ProductCode,

OrderDetails.Productname,

OrderDetails.Quantity --this is where your typo was. 'orderdetails,quantity' instead of 'orderdetails.quantity'

From Orders

join Orderdetails

on orders.orderid = orderdetails.orderid

Where Orders.Orderstatus in ('Pending', 'Processing', 'New')

you're getting all columns because...

I'll give you some advice to get more (at least one) answer to your question. Provide some ddl for us to work with. It's more likely an expert will fancy...

Have you thought about just storing the files in a column (varbinary)?

Or even use filestream if you're super ambitious. This would be good if you already have all your recipes...

Here's what BoL says about piecemeal restores.

http://msdn.microsoft.com/en-us/library/ms175541.aspx

I'm pretty sure you need to have been doing filegroup backups along the way also. No piecemeal restores from a single full...

Hooray! I'll do a celebratory happy dance for your success. Glad you got it working.

format(expression,[optional string format])

So perhaps you could format the whole thing like this?

=iif(format(Fields!COSTYPE.Value = "M","Available","Reconciled"))

I believe format is the appropriate function.

Again, I'm just trying to throw ideas out there until...