U can use another table to store searched record... Before insert.... check whether it is there in the new table... if exists... update its counter... else insert it...

or else u...

Check whether Internal free space is there by right clicking on the database...

Does "loca" table has more than 1 address for each sno...???

U can use Union clause to merge...

However, This is not a good approach, but I could find only this solution by using T-SQL....

select c1, replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(c1, '0', ''), '1', ''), '2', '') , '3', ''), '4', ''),...

Yes Chris, u r right.... I didn't consider groupby clause here...

use getdate() for last_modified... gives current datetime....

Right Click on server name --> Reports --> Standard Reports --> Performance - Top Qrys by CPU...

Also go thru below links....

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

http://blog.sqlauthority.com/2010/03/15/sql-server-maxdop-settings-to-limit-query-to-run-on-specific-cpu/ -- by pinal...

Use SQL Server DashBoard to find out more expensive qrys in terms of CPU.... can run execution plan against those qrys...

Also check Processor counters by using perfmon.... check the settings...

Y u r using Substr, if u want to compare firstname and lastname.. u can compare by removing leading and trailing spaces in the string... ltrim()... rtrim() can be...

In my choice, In-Place upgradation is a better option. The moment when u are going to uninstall the previous version (Sql 2000), then it may give some issues like... "Mgmt...

First u can set the MDOP to the no. of processors ie 8.

check IO on the drive where database files exists....using perfmon for disk counters like avg disk q length,...

U can create insert trigger on Login table or on the table where u want to log info...

U can store the logged data in tables...

To copy data... There r several ways in sql... check BOL for the same...

for Linked Server.. Well explained in BOL...

U can find the qry below, but this is not the optimum sulution....

select distinct a.c1, (select distinct top 1 b.c2 from asd1 b where b.c1 = a.c1) from asd1 a