There is no need to create a database before a restore. Restore the database...

What exactly do you mean by merge? Does it mean that you want to consolidate the data from two databaeses to one?...

One of the main things to note about SQL server 2005 is that it uses the tempdb to handle more operations. What you should be looking for is what...

There is no need to reorganize and rebuild indexes. Rebuilding indexes removes all fragmentation and also updates the statistics. ...

You can use triggers to collect data about altered DDL, as ALZDBA suggested.

My question to you is do you have all of your scripts in some sort of...

Is this coincidental or a user with the same name answering the post?

Anyway to elaborate on the solution:

You could simple use a SUM or COUNT case statement...

Agreed. There is no real advantage to adding additional log files. Adding more log files is usually a means to spread...

All of your requriements can be met by creating an SSIS package. SSIS is a very robust solution. It gives you the option to create delmited text...

Are you sure you even need a cursor to accomplish your task? Post your Table DDL, some sample data, and a description of what you want to accomplish. We...

Willy this is primarily used because it gives a slight performance boost. If exists evaluates if a...

The row_number function was introduced in SQL 2005. As John said, the best/easiet way to accomplish this is using temp tables.

Beat me too it 😎

SELECT

ROW_NUMBER() OVER(ORDER BY VatCode) AS [ROW],

VatCode

FROM Partner

GROUP BY VatCode

This is absolutely true. An if exists checks to make sure the statement...

But as Matt said, this only works if you are returning a table.