nice question

SQL does not have "iif ". Even if there was you cannot use it in a select statement.

SQL 2000 does not have the previously mentioned catalog views. You posted in SQL 2005 forum and got the answers for SQL 2005.

My 2 cents...

Depends on how you are inserting your records. If you are using normal insert statements then i believe it would behave just like the Full recovery model.

From ...

Hi

If you need to this frequently you can implement this using SSIS. If you do this on rare occasions then just use the import/export wizard.

take a look at this

http://support.microsoft.com/kb/886695

I have'nt looked deep into this but will a column in the order detail table indicating that the product is from the quote or product table help.

Hi

I use VSS integrated into SSMS. It is cumbersome to use but it does the job. It make sure there are no concurrent changes to the same script and give...

Hi

You are right. We can find out times of queries already executed. I assumed the OP wanted to the execution time of a new query which has not been...

just 3 days back i had a similar issue with isnumeric. If this QOTD had come then it would have been helpful.

Changing the query time out may help but its better to find out the reason and solve it. You will make sure that it will not come back again.

We can get the data related to queries already executed. I think the OP wants to know the time before executing the query.

Only way you can predict the time...

check out the BOL topic - estimating table size.

I think no but iam interested if someone can come up with something.

Create a trace, put the output of the trace in a file and run the trace. This is uses lesser resources than running the trace on profiler. Also set the...