So if I detach the DB, delete the log file and re-attach the DB, the log file will be created at minimum size?

Thanks,

Danny

Thanks for the reply guys,

I've tried using the DBCC Shrink + Backup Log .., sometimes it works and the log shrinks but sometimes it's not working...

ok, thanks ..

Actually I'm not referring to any specific query here, Phill.

I just wanted to know the strategy implemented by SQL when parsing and execute a query in general.

To join or...

Hi Phill, thx for your reply.

okay, let's say the execution plan tells me that SQL Server will join the 2 tables first before it filter out...

Hi Sismith and David

Thanks for the help.