To my knowledge, the machines, databases, workloads, configurations are exactly similar. I took the backup from VM machine and restore it on to the other machine. (Wanted to compare performance...

Thanks, yes i have to do it on test machines only.

As you said that you usually are concerend with compile & execution time, so Is ignoring the read/writes a good...

Actually the Inner Query (aliased as A) is not a subquery in my database, its a view, and users call this view with their where clause.... I just copied the...

thanks

Thanks,

Whats the effect(benefi/drawback) of enabling this option?

thanks, but then in which cases snapshot is usefull........... i mean mostly databases are of very huge sizes and replication is mostly implemented with huge datases........so wats the benefit...

Grant---question for you.

Why would the data be half when using Varchar? Both the queries will return same number of rows so how can data be half for Varchar?

I think....most probably...

Right Click on your database-->Tasks-->Shrink-->Files

Select 'Log' from file type drop down. Press ok.

But if you have full recovery model, log file will not be reducing significantly so in this case...

Gila u r just too gud.......

Greg thanks alot that helpfull too.........

Thanks,

Usman

So how will the data BETWEEN a full backup and a transactional backup will be restored, assuming that checkpoints occurs AFTER the full backup and data was flushed and REMOVED...

One option is...

Detach the DB.

Move the Data & Log Files of this DB from current location to some other location.

Create new DB with the same name as of your DB.

Restore...

GSquared you rules......thanks man

thanks every one who tried to help me.

@Noffer........i cant find "scripting" option in Tools-->Options

There is no such option available

I am using SQL Server 2005 Management Studio.

I think there will be a setting to enable the TRY n CATCH stuff.

@steveB....which version of SQL Server r u using?enterprise?development?wat...

Anynomas block means running the query in SSMS...not within a procedure or function.

i have tried it as follows now....but its still now working......p.s Funds is the name of the table

create...