I took and passed the beta.  All I did was go through the E-Learning courses.  However I did play with the pre-release.  I think that if you have had experience...

If you need to Brain Dump for 70-228 you shouldnt be taking the test.  You need to get your hands dirty and actually work on a box.  At least run...

I am a very junior DBA.  I got my MCDBA last May and am working in the field in a limited capacity.  I know that I cannot answer a few,...

To answer my own question.  It turns out that a developer had access to the box and shut down the service.  Once I started the service again, it worked fine.

my only other suggestion would be to talk to your dba (if that is not you) to check the default query timeout settings on your server to see if that...

I know that turning the parameters into query parameters would take a lot of development time to redo the report especially when it is a complex report, however doing so...

I am not sure why you are timing out but you could try a couple of other ways.

1 way would be to create filters and pull the full data set. ...

There is a hotfix in addition to the service packs.  Have you tried that?

I get an error saying that Child is not declared.  I appriciate all the help you can give me.

It was my understanding that Table variables were more efficient for a smaller set of data.  By using the Table variable you would not be writing to your temp log...