Thanks ScottPletcher and Chris. Understand it much better now. 
Chris, I checked with IT and it is on SAN

But , would more drives on a single physical drive  versus different physical drive have any adverse effect?

I only have non-clustered index on dbo.table1 and dbo.table2.
And after the update (it never did finish) I have clustered index on dbo.tbl_needs_ranking

I changed the length of the last field to 7. It helped me get in all rows that had only english characters correctly.  So I increased the size of 1st...

Thanks.
But this prints only valueA from <Property Name="paramB" Value="valueA" />

and not valueY from
<Property Name="paramB" Value="valueY" />
How do I iterate through all Property elements?

Thanks
Rash

closing this post myself as I figured out the answer.

If anybody has the same issue,

There is a parameter in CONTAINSTABLE that can be set.

CONTAINSTABLE([MovieReviews].dbo.Reviews, HTMLReviews, @SearchTerm ,LANGUAGE N'English',10000))

Sorry needed to edit table columns. I had forgotten to add to columns.

So there are multiple records for same employee:

INSERT INTO dbo.Employees(EmpName ,EmpAddress1 ,EmpAddress2 ,EmpAddress2 ,

EmpCity ,EmpState ,StartDate,EndDate )

Values ('Ann','1...

Can you please elaborate on "less resources" ..not sure about log files also?

Thanks

I am told by PM, we will not touch those cases.

Here's the table structure,

Create table dbo.Homeaddr(HomeID INT,Address varchar(200));

INSERT INTO dbo.Homeaddr VALUES(1, 'Four Union Ave');

INSERT INTO dbo.Homeaddr VALUES(2,'Fifth Avenue ');

INSERT INTO dbo.Homeaddr VALUES(3,'Twenty First and Main Street ');

INSERT INTO dbo.Homeaddr VALUES(4,'Seventeenth...

Luis,

I haven't thought of spelling mistakes in the word like 'Secnod', but for 'thirty-five' I remove all punctuations, so that it's easier to apply rules.

Yes, I do really need a solution. This is not a student assignment but a company project.

Thx

Yes, to remove certain unwanted strings from FirstName and Lastname columns.

Here's why I thought I should have a function...there are many such unwanted strings for example: a) Former b)Legal c)IRS...

I am trying to insert the 'cleaned' values into the table called Name