thanks . it worked for me 🙂

yes i was restoring MSDB for login and jobs perspective.

i didnt try to restore the MSDB instead i transfered jobs with SSIS package.

Grant

, isnt it different objected creating whenevr we create a index on view. bcoz i read some where that whever we create any indexed view, sql server will...

Vyas, i was telling the same thing as grant Frithcey mentioned in his first reply.

version are different , as mentioned in prior post

i guess , destination drive will have enough space

As above line depicts , this is transactional table, i guess

Sure, whenever you create index on any transactional table , it will degrade the performance.

because whenever DML operation performed on this table , index will get updated.

no that cant be done , just for a one delete operation .

on every run, creating indexes is not at all possible and recommended.

this table contains around 20 millions of records.

the statistics are being updated on daily basis

can u post different indexes associated with tables?

. i guess someone had asked for the same earlier.

Thanks a lot

Does it mean that if space available and for temporary storing purpose, we can store milions of record in table variable? (this is just hypothentical scenario )

and second ques, whenever...

No it doesn't. The reason that table variables perform poorly on large row counts is because they have no statistics and hence the optimiser comes up with really, really bad...