Both of them have their places. But do not store much data in table variables. Not only they suffer from the above performance problems, you cannot create non-clustered indexes on...

Also, if you are interested about how the tables are stored, it may be better to look at sys.data_spaces instead of sys.partitions. The sys.indexes data_space_id references the data_space_id in...

As one of those other people who will point out some of the differences, I suggest you have a look at http://www.sql-server-performance.com/articles/per/temp_tables_vs_variables_p1.aspx

Under 2005 the performance of table variables for large...

A table may be stored on more than one partition even though it is not explicitly partitioned. I'm not sure about the exact rules that trigger the additional partitions, but...

Hi Paul,

under 2005 you could use a join, and use a trick with xml path to concatenate the column values.

Under 2000, where xml path is not supported you could create...

local temptables have the scope of a connection, the name SQL Server creates for them in tempdb is postfixed with undescores and some number.

Regards,

Andras

If this is a 2000 server, you could look at msdb..sysjobs. Chances are good that the local jobs have not been updated properly, and the originating_server is set to the...

Information may have been lost during the concatenation/storing this data in a single column. Probably it will not always be possible to get this information back. E.g 13-19 may need...

You may want to have a look at http://sql-server-performance.com/Community/forums/p/14315/82960.aspx

This would set up the job from inside a trigger. However, I'd agree with John that a nicer solution would be to...

Some compat mode 80 issues are on: http://www.sqlservercentral.com/Forums/Topic407783-146-1.aspx

Regards,

Andras

EXEC sp_MSForeachDB "use ? Exec sp_change_users_login 'Report'"

Regards,

Andras

after copying your example to G:\bulk1.txt:

BULK INSERT bulk1 FROM 'G:\bulk1.txt' WITH ( FIELDTERMINATOR = ',',

ROWTERMINATOR = '\n', FIRSTROW = 2 )

seems to work for me. Are...

Hi TJ,

much depends on the type of disks you have (whether all your disks are the same speed/ you have some slower ones), whether there is a sensible way to...

Hi Sandy,

Sandy (10/11/2007)

1st Qst : I am really Confused why I will use Hash Join,

I mean to say in what circumstances I can use hash join,

and what...

Hi Jan,

I've fixed the link in the original post. The one that did not work was to another thread on SQL Server Central http://www.sqlservercentral.com/Forums/Topic402984-146-1.aspx

Both links should now work,

Regards,

Andras