First things first modify model database to include a script to log table creations as well as modifications. The logic could be trigger based or job based doesn't really matter.

Now...

you just need to add another condition in the where clause to do a datediff on the day as well

http://msdn.microsoft.com/en-us/library/aa214297%28v=sql.80%29.aspx

Read this for a better understanding on collation

Collation , will impact sort operations and as a result performance . Additionally collation will impact the results being returned and as a result the join and type of join...

Form past experience NO , the data volume will result in slower query performance , but in no way are the proportional , i.e double the data <> 1/2 the...

use madworks

go

declare @table table

(

name varchar(10),

ddatetime datetime

)

insert into @table

select 'Bobby', GETDATE()-365

union

select 'Mary' , GETDATE() - 512

;

select * from @table

;

With CTE as (

...

looking at the execution plan , the query 2 accounts for 76 % of your cost and a significant part of it is the index scan.

You might want to...

Your right ,the performance would vary depending on which type of join is used by the optimizer and available indexes, my previous response did not conider joins btw.

type of...

Fortunately for me there is a nearly infinite supply of entities out there who feel like you do and I get paid good money to fix their stuff because they...

First of all the tran log backups are useless without the full back for the db.

Next you can use from transaction log reader software , SQLlog rescue is one...

Damn , I knew I should have read thru the previous 2757 pages 😀

SSIS has a for each loop task which can be used to iterate thru as many files as required.

Your best bet is to go with a single where clause with all your filters , the optimser will be able to filter the result sets on its own ,...

i think you would need to use something like

where 1 = case when (col1 = x ) or (col2 = x) or (col3 = x) then 1

else 0...

A rule of thumb , the data decides the datatype , performance and storage considerations are secondary , i.e if the data is fixed length use char else varchar if...