Sorry for the code

Its

select --- From table 1 where user=@userid

union all

Select --- From table 2 where user=@userid

--

--

--

--

Union all

Select --- from table 12 where user=@userid

Does this make a difference on the performance??

Hi Steve

Thanks for the reply, the Query is so simple,

select col1,col2,col3 from table1 where user=@userid

Union all

select col1,col2,col3 from table1...

Hi

Use this code below to mail you with HTML format to ur mail,

declare @body1 varchar(MAX) ...

It depends upon the data you store, if the data is less then u can use the first ones,

If you want to index on all the Columns on the...

Thanks Gial

there is a constraint with the same name on other SP as well, but its working on fine now with the same name when it is supposed...

Thanks for the post. i want to clear this replication objects, and there are some column in tables as well, that i wish to clear, i cant replicate this on...

Hi Colin, i am refering to hardware parallelism, which iam not able to do on AMD, hope that wasent relevant to this discussion, i am new to this field and...

Thanks for ur posts

My server Configuration ( its a Virtual Server)

MS Windows 2003 Std Edition (64 Bit) with 4 Processers (AMD 2.81 GHz)

SQL Server 2005 (64 Bit).

I tired to allocate...

Thanks, i have got a standard edition, mimimum memory is 0 and max is 5 GB, i havent got any other services running.its only SQL server, is there any other...

Thanks a lot Guys

this sounds perfect, i will try this

Cheers

Suji

Cheers Grant, i have also found one more problem with the SQL , once i used DBCC DropClearbuffer, the CPU usage drops a fair amount say from 100% to 20%,...

Thats correct Grant, i have checked the system and it seems to be working fine, i have some Quries that take a large amount of CPU, in one application they...

Thanks Grant, i have looked into the fragmentaion level, it seems to be a bit high on certain tables, i am working on to defragament it, i also have looked...

Thanks mate

i have asked my system admin to check exchange server and this fixed the problem

Cheers

Sujith