Well this doesn't make any sense.

As the databases are not being used for data entry as much as reporting the logs are very small.

The entire database server's set of logs...

How can I do that?

(I'm a developer who happens to be the DBA, so my detailed DBA skills are somewhat lacking. I can write great TSQL, but when it...

Now for that to work you are relying on a data cube though right?

Or would that same approach work with a simple table of data that had:

EmployeeID

EmployeeSupervisorID (references the employeeID...

Thanks, that does help clear that up.

GilaMonster: For the grouping that makes sense (or well any aggregate function).

For the use of multiple fields in an index I'm still a BIT fuzzy on that.

Examples:

1. CustomerID =...

Just for the record... I stumbled across this post by accident and found everyone's suggestions very helpful for my own query tuning.

Someone mentioned grouping on indexed fields.

I knew you should...

I've seen this suggested: http://weblogs.asp.net/mhawley/archive/2004/08/10/212281.aspx

And according to Microsoft (and I've used this):

"Although it is not recommended, you can disable soft page breaks by setting InteractiveHeight to 0."

I'm trying to do this with SSRS 2005 but instead of showing indentation I want to use the drill down + option so you will see the CEO at the...

I'm actually VERY interested in those on call DBAs.

I'm a single DBA shop and when possible prefer to handle development more than administration.  I'm confident that my servers are safe...

Where in the report did you enable sorting?

Sad but true... they're a reason they say "If you want a job done right... do it yourself".

You might be interested to do some research on management articles related to...

I've seen mention that 64 bit SQL Server 2005 doesn't always work well with linked SQL Server 2000 machines.

Can anyone confirm that?

Sorry, I should have been more clear.

Log backups for the other databases, user, etc...

I don't bother with log backups for any of the system databases (granted I can't with Master...

I finally ended up doing the entire thing through sqlcmd using the restore options indicating the file location on the tape.

So I can restore full backups at least, but I'm...

Can you expand on windows native backups?

This is different than what SQL Server uses to backup data to a tape directly?