Avoid using temporary tables and derived tables as it uses more disks I/O. Instead use CTE (Common Table Expression); its scope is limited to the next statement in SQL query...
View more
Posted By: Mr. Joydeep Das
Subscribe to:
Post Comments (Atom)
About Me
- MR. JOYDEEP DAS (MCDBA) for SQL Server/BI and MR. PALASH PAUL for .NET
- This web hosting contains the critical information related to SQL server and .NET. All this information is taken from day to day development life cycle. If you need any critical information related to SQL server or .NET, feel free to mail us at(for All) sqlserver.asp.net@gmail.com For SQL Server and Business Intelligent (BI) das.joydeep2@gmail.com and for .NET palashpaul.net@gamil.com
Thanks for your Script.
ReplyDeleteIt's really working