Thanks - Highly appreciated your help.

when i use this 512.322.1396, the logic don't return anything. also same with 713-326-XXXX as input it should return only numbers

could u plz see this...

Yes we are doing daily updates on this table, if user changes his location, Region, or any other personal information then we take that data changes and update...

I was just asking about the OPTIONS, why they are different and what options are better - I mean they should be added or NOT? does they make sence and...

There is no any trigger and but one non clustered index, having Administration_ID, administration, Regiond_Id, Region, Facility_ID and Facility all are included in one non clustered index with no fillfactor...

Also the Update on this table is noticed as slowest running SP:

Please have a look at this and help how can i improve perforamnce:

CREATE PROC sp_Tracking_UpdateSession ...

Awaiting for response...

Shamshad Ali

Thank you all for your replies, we have few testing servers over VM and we would like to have pilot testing (pre-prod) before going live, and need to differentiate performance...

One more basic quetion. Can we implement clustering on VM environment?

we have VMware VI 3.5 OS over which we have windows server 2003 EE R2 installed.

Shamshad Ali.

Thanks bob for you help and time, actually i did not get chance to see it working. Please make it more simple if possible. Here is my requirements in detail.

--...

Usually we require to find out schedule start time and end time most frequently and title as well,

So here these are all

[Sch_End_Time] ASC,

...

You are saying Correct that its not good practice to write such kind of logic in Triggers, but the reason is i have to write changes at the same time...

And what about the style for selecting data between start and end?

----------------------------------------------------

AND 7/14/2008 BETWEEN s.start_date AND s.end_date

Post your query first. I think you are writting a query like below:

select media_title from tbl_media m, tbl_Schedule s where media_category_id =34

AND '7/14/2007' BETWEEN s.start_date AND s.end_date

see if...

I have a similar question so rather I post a new one I would like to add here.

I want to know if the following query is correct with respect to...

Jeff,

Plz don't forget to reply me with suggestion and help i requested on page 1 of this disussion.

Shamshad Ali.