I have SQL Server 2000, 2005 client tools, along with 2008 Developer Edition server installed on my desktop.

We still have some SQL Server 7.0 systems, so I need the 2000...

Oracle to SQL replication for disaster recovery?

There is just so much wrong with that idea that I don’t know where to start. The simple answer is that you would...

This will give you the filegroup information.

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

If you are deleting most of the rows and you have enough space, it might be faster to insert the rows you are keeping into a new table, and renaming...

The first thing you should determine is how long each statement is taking.

If it is the second step (INSERT INTO [ESSBASE_TEST_DW].[dbo].[fct_Logs]) that is taking too long to run, there is...

Date Table Function F_TABLE_DATE

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

Function F_TABLE_DATE is a multistatement table-valued function that returns a table containing a variety of attributes of all dates from...

The only feature I have seen in SQL 2008 R2 that really looks worthwhile is Standard Edition backup compression.

Sounds like a bug in RedGate SQL Compare. Contact them and ask them if there is a fix.

If your real issue is backup performance, then the best thing you can do will be to use a third party backup product, like SQL LiteSpeed or Redgate Backup. ...

I used SSIS to implement a real-time currency arbitrage system that drives the vast majority of trades world-wide.

It’s also a great tool for development of industrial process-control systems for oil...

It can be simpler to maintain...

Why is it important to avoid dynamic SQL?

I wash my hands of this thread.

What's a "true DBA"?

There is no reason to think that what you described would happen.

It would allow teams to exist in small market with say 1-2 million people in a metro area because...