I have tried this, but the organization...

I passed the 70-432 a few days ago.

I used the Microsoft press prep kit initially but found it far from adequate. For starters it was not edited well and not...

Jeff Moden (9/28/2009)

---

Hmmm... I suppose it comes with the answers to those...

i needed the largest OrderId for each status, so in this case, the results would be:

(No column name)OrderStatus

2 A

5 B

8 C

10 D

serious apologies for posting this question. was making it much more complicated that it should be.

its

select max(OrderID),OrderStatus from #orderline

group by OrderStatus

I was trying joins and subqueries and a host of...

Michael Valentine Jones (10/13/2009)

---

When you restore a backup from another server, the info about the backup you restored from is stored in the same tables where info about local backups...

Roy Ernest (9/29/2009)

---

If my understanding is correct, Master key just protect the private key of certificates and asymmetric keys that are present in the DB. It is the certificate that...

Thanks for the link. i...

thanks folks! its educational to see all of the options i had in this case!

I love Florians solution, i would have never considered an idea like that.

I ended up using...

Cool. thanks for the answers. im just wondering as if such an issue occured, and you had to restore, chances are you dont have time to restore a 300gb database...

Thanks for the info. I ended up going with the Inside sql server 2005: the storage engine, query tuning and optimization.

I know its sql 2005, but from reviews, it seems...

Thanks for the responses. that clears a lot of questions up.

please disregard my silly question. i had forgotten to update the job schedules. all is working fine now.

madhukeshwark (8/22/2009)

---

Hi Winston Smith !

As per my understanding, u have set the flat file connection manager configuration setting correctly. You need to specify the delimiter in the connection manager.

Pls...

using brain dumps, along with ensuring you dont learn, and risking having your certification revoked, and being banned from taking any further certifications, also lowers the value of the certification...