i agree. i think it is up to individual to take the advice and believe in things. I should have done my work and tested it properly. this is the...

thanks jeff.

It seems i need to be careful about reading the article. I would assume if the article written on some sql forum from expert then it will be accurate....

select fname,lname,disposition as verdict,COUNT(*) as cnt

from test

group by fname,disposition

having COUNT(*) > 2

u need group by on lname.

thanks jeff & gail.

I had a quick look at this article before couple of years which made my wrong impression about select into.

http://searchsqlserver.techtarget.com/tip/Tricks-to-increase-SQL-Server-query-performance

Many thanks for the clarification.

I just took a quick look, but to be blunt that procedure probably needs a rewrite.

Permanent tables instead of temp tables? That's gonna cause all osrts of fun if...

Hi Gail,

I've tried to include all the information in the attachment.

SQL Query, Table definition, index detail, constraint, number of records, timing of the query.

It takes around 45-47 minutes...

Hi Gail,

thanks for looking into this. I can provide all the information but it seems it will take some time as query runs for 40 minutes and it is friday...

Also i've noticed that clustered index on this table is having two columns.

service_id (varchar (62)) & year (201011 or 201112 etc.). That year is also varchar(6) and combined with...

thats bit of relief then. I am not sure how long it takes to retrieve as i didnt work on huge dataset before so just making sure.

Once the row...

the query below is on this table which takes 6 minutes to do the row number.

select con_fyear,v_finyear,prov_spell_id,patient_id,admidate,disdate,

row_number() over (partition by patient_id order by admidate,disdate,pat_epiorder21) as admiorder

from dbo.Health_Table

Thats true. NHS employee gets more holiday and better environment to work.

You get paid more in london but it will be more only because of living expense in london.

Thanks.

We are public sector so obviously the pay is less than private sector. It is secure job in the current market of recession.

How much would you get paid...

Thanks GSquared. Much appreciated.

Thanks very much guys. very useful information.

Thank you both.

We will never have operation code which will go more than 15. Also by normalizing this way it will help writing some of the queries and could be...