Adding along to the list..

Check the health of your db by running dbcc check db. Or you can schedule the same by creating a maintenance plan.

as i said dont use * if u can.

Experts correct me if iam wromg

when OR is used sql server finds it difficult to use the right index , mostly it does a table scan. This can bring down...

Hi

How about specifying column names in the insert as well as select clause

ex:- insert into table1 (col1,col2)

select col1,col2 from table2.

Hi

I dont think the trigger will be enabled when sql server service is restarted.

Thats a neat trick Ian. Where did you get it from ?

Hi

What about using a Left join instead of "OR". This will have a better execution plan.

Hi

Check out this link

http://www.sqlservercentral.com/Forums/Topic367977-146-1.aspx

Hope this helps

For starters...

specify the column names instead of "*".

SELECT column1 ,COUNT(column1) AS expr1

FROM (SELECT column1 FROM table1...

That looks like a nice suggestion. you can aggregate on another column and then join it with your table to get the image column. But you need another column to...

Hi

Is TvsRecordID a primary key or a identity column.

Can you group by any other column.

Pls post the table structure and sample data and let us see.

Yes like others have said use 2 schemas in the same database. Having 2 diff databases would complicate things and also bring down performance .

Hi

Whats it that you want to know

Hi

you can do the same from SSMS. Check out "Moving tables" in BOL.

Hi

How will the table be updated . Open the table and make the modifications , thru ad-hoc sql queries or thru stored procedures ?