tag:blogger.com,1999:blog-6366097984829649612.post4086134723280973023..comments2024-03-28T19:37:42.047+05:30Comments on SQL SERVER and DOT NET: Question asked by one of my DBA friends.MR. JOYDEEP DAS (MCDBA) for SQL Server/BI and MR. PALASH PAUL for .NEThttp://www.blogger.com/profile/03227712555349641849noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6366097984829649612.post-89332477636218282592012-02-23T11:57:02.626+05:302012-02-23T11:57:02.626+05:30Thanks "Venkat"Thanks "Venkat"MR. JOYDEEP DAS (MCDBA) for SQL Server/BI and MR. PALASH PAUL for .NEThttps://www.blogger.com/profile/03227712555349641849noreply@blogger.comtag:blogger.com,1999:blog-6366097984829649612.post-26306175481769274942012-02-22T16:16:53.378+05:302012-02-22T16:16:53.378+05:30hi joydeep,
the article looks good. but i have a d...hi joydeep,<br />the article looks good. but i have a different view on the 'using temporary table to improve the performance of a stored procedure'.<br /><br />I think instead of joining a lot of tables using JOIN statements, we can divide the tables into different groups and load the required values from the group in temporary tables and use these tables later on for achieving the object. This will definitely improve the SP.<br /><br />I reckon to use 'table variables' instead of 'temporary tables' for the same purpose. But using temporary tables does not affect performance of the SP.venkatnoreply@blogger.com