Couldn't you do something with sys.dm_db_index_usage_stats? It does not separate updates/deleted/inserts but has a user_updates column and a system_updates column that I assume would be the number of times...

Can you post the restore commands you were using? I have done point in time restores to a new database.

You need to use IN as Like does comparison to the entire parameter. So if your parameter contains:

'Johnson, Jones, Smith'

the LIKE is Where Name Like '%Johnson,...

Unless you want to break out the objects in the database by schema, like production, sales, hr, etc... and use that to manage security you do not need to create...

There will definitely be changes as the way we use data changes. I think most will be fairly minor, changes to aggregations and different functions like Row_Number, Rank, and...

If you wanted to pass the column name then you would want to use dynamic sql. Another option, and the one I use, assuming the web page has all...

It depends. What other columns are being returned by the query? What is the selectivity of the column(s) in the index?

As a rule you should not place a...

First let's take it slowly, you do not want to make multiple changes at once because if you have a problem which change created it?

I believe you can remove the...

Attached is a script I used to create a script to convert char(1) columns to bit. I drop any constraints that include the column, check constraints on the column,...

You need to replace "C:\i386" with the path to your log backups.

Check out this article:

http://www.sql-server-performance.com/articles/per/SSIS_Usage_of_Checkpoint_File_p1.aspx

Try out the derived column transform as step 2 in your process.

SQL Server also ships with a tablediff utility that was really included to check replication, but can be used to compare data across DB's. Here's link to my blog...

You use ADO.NET connection, command, datareader, and dataset objects. Import System.Data.SQLClient. You can have your scripts in a file and just read the file to load the appropriate...

SQL Server Express has the same security available as any other Edition of SQL Server. The biggest issue you would have with backing up remotely is latency over your...