I cannot test this at the moment, but I think..

You are specifying the database name NCOS as the Schema name. It knows the database name already, so just replace the...

By huge in size do you mean a large number of tables/columns or that each table is very large?

The text you specify obviosuly has to be stored, but compared to...

Just to reinforce what Jeff has said. I have also found views with a prefix of "tbl", I think for the same reasons - something started off as a table...

Without a detailed description of your business requirments, plus proper definitions and descriptions of what each of those tables and columns actually represents I don't think anyone can answer you.

You...

I would look at the I/O Stress test tool built for the job...

http://www.microsoft.com/en-gb/download/details.aspx?id=20163

Allows a wide range of tests of various types

Mike

I would not just copy and paste the rdl. Open the 2005 project in 2008 and it should I believe upgrade it. It has been a while since I needed...

You should find it will just open in Visual Studio, which will upgrade it. What have you tried?

Mike

There is no generic "rollback script" for this sort of change that anyone can give you.

You need to take the soure of the procedure, and change it to remove the...

Can you give some more details on what you want to do please?

Specifically what do you mean by "it is giving null"

Mike

No problem. Whether it would make much difference to the speed really depnds on how many bookings and how many attendants.

Effectively if you create a clustered index on attenant table...

Having just seen this and your other post re merge joins.

The vast majority of the time the query optimiser will choose the strategy for the physical way of implementing the...

If you have a clustered index in the joining fields then you should find the optimiser can omit the sort phase of the execution plan as it can rely on...

Please also see many other posts for discussions on the dangers of nolock hints.

Mike

There is no real concept of "first" and "last" in a table, the preciuse defintion being that a table is an "unordered set of rows". Therefore it could theoretically ...

Yes, everything that changes anything is logged, and therefore if inside a transation it can be rolled back. Including create table, drop table truncate etc .

Mike