I still wonder why is the view perofrming better on some db's which are actually bigger than the problem database.

view

how can i create a stored proc or function which can be used just like a view and perform just like querying a table

Ok here is the important observation, I am runnig the above query from a view (which has union of 2 big tables ) which why it is not using paralellism...

no everything is identical execept the amount of data and data also is different. good database is 900gb and bad db is just 300gb, running the same query on both...

i dont think its working for me, is there a chance to improve if we can bring in same statistics from the better performing DB to slower db? not sure...

i have updated the stats already and here is the code its not a stored proc.

Create Table #dtrange (

jobstart datetime,jobend datetime,paystart datetime,payend datetime)

go

drop table #empdts

select distinct empno,

case when efdt>=jobstart...

I have also observed that the faster datavase is generating bitmap create filter before parellelism ,how do i make sure even slower db also generate bitmap and parallelism?

Its on the same instance but different databses but the databases are completely identical structured.I am wondering why one be faster than other.

I have also ran dbcc dropcleanbuffers and...

I have seen huge performance difference between 2 identical databases and the weired thing is bigger db perfoprming betterr than smaller where the expected was in reverse.

the query i am...

I think you got me wrong, user already has permissions to INSERT and UPDATE but i want the user to execute the stored proc by which the user will be...

open dbnameCursor

Fetch next from dbnameCursor into @dbname

WHILE @@FETCH_STATUS = 0

BEGIN

--print @dbname

if exists (select name from sys.tables where name in('ssn_info','pf_info') and

create_date>=dateadd(day, datediff(day, 0, getdate()), 0))

print 'conf tables are created'

...

any idea how this can be done?

I have alreayd tried it but i think it will not work as i try it says " TRIGGER should be the first statement"

I am not sure what you are trying to say but though i give him permissions to exec jus the procedure that would not be sufficiant because inside the proc...