If you're going for the MCDBA cert, may I offer a piece of advice?

There are (or were) two OS tests as part of the MCDBA.  Windows 2000 Server & Professional. ...

Linda said:

I belive my boss wants something we can present to our VPs besides just basic reports.  It's not just about the graphical "nifties".  We have the problem of having too...

Too true, Rudy.  I actually know an IT guy who is a genius at what he does, but hates doing IT work.  It doesn't matter what job he does, who...

We're currently using SQL Server 2005 for our production DBs and SQL Server Reporting Services 2000 for our operational reports (haven't upgraded to SRS 2005 yet cause we're still trying...

Honestly, I haven't had to make a lot of comparisions.  Not many moons ago, I was working in retail sales/customer service.  When I got my first real IT job (a...

"Thank you"s are definitely one of the non-pay recognition factors that I count as an important thing.  It's amazing how two little phrases ("thank you" and "please") transform a potentially dull and...

A boss who is reasonable in his/her demands and willing to stand up to the end users and the higher-ups for the employees under him.

A team that communicates and mostly gets...

Looks like this is a new forum.  Perhaps created or requested by RedGate??  Maybe it's supposed to be internal to them.

Anyway, there's no moderator associated with it, so I think...

We've tried everything we can think of to deploy properly.  Our problem is that we don't have separate servers for Dev/Test/QC.  We've got the same server for all three with...

Lee,

Thanks for the response.  I posted a reply on your thread as to what we finally figured out the problem was.  We don't have a solid resolution yet that applies...

Lee,

You replied to my post and I'm going to now reply to yours.  Several days after I originally posted, I found the problem with our situation & config files.

When you...

Thank you for the information and the link.  It is greatly appreciated!

You need a case statement in the WHERE clause of your procedure.

My situation is doing a Data Dictionary where I give the user an option to choose a...

There is another option.  Make some of your filegroups READ ONLY, then backup only the filegroups that are READ/WRITE.  @=)  (see Partial Backups in BOL)

Or do put your large table on its...