TABLE VARIABLES - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

TABLE VARIABLES

Author

Topic

WoodHouse
Posting Yak Master

211 Posts

Posted - 2009-11-09 : 02:58:48

HI

Queries that modify table variables do not generate parallel query execution plans. Performance can be affected when very large table variables, or table variables in complex queries, are modified

Am not clear above statement please explain me.

Thanks guys....

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-11-09 : 04:36:21

quote:
Originally posted by WoodHouse

HI

Queries that modify table variables do not generate parallel query execution plans. Performance can be affected when very large table variables, or table variables in complex queries, are modified

Am not clear above statement please explain me.

Thanks guys....

When did you get that message?

Madhivanan

Failing to plan is Planning to fail

WoodHouse
Posting Yak Master

211 Posts

Posted - 2009-11-09 : 04:42:55

Hi

please refer below link...

http://msdn.microsoft.com/en-us/library/ms175010.aspx

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-09 : 10:30:04

see here: http://msdn.microsoft.com/en-us/library/ms178065.aspx

short answer is to use temp tables instead of table variables if there is a lot of data, or you'll be manipulating the data in the temporary object

X002548
Not Just a Number

15586 Posts

Posted - 2009-11-09 : 10:43:53

I guess the questions is, what did you do, or what are you doing, that this is an issue for you?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources