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
Popular Posts
-
We have common doubts when to update statistics, before index or after index. To resolve this query we must understand, what is the stati...
-
In this article my main objective is to compare 2 image fields (old image and new image) of a table objects. For this I use extended stor...
-
The most important thing of a table is defining the primary key; it could be single column based or the composite primary key. In my...
-
Once again, I find something that can hamper the performance of my SQL query, please have a look, it may be quite informative. Some time ...
-
I am a mail form one of my DBA friend to request about: "Please advice that how I can restore the database from backup file plac...
-
The NULL value always makes some problem to database developer. To handle the null value properly the SQL server provides two functions: ...
-
When I saw some junior developer writing SQL query, they always busy to get the correct output form there query. Not even thinking about... -
In this article I am trying to explain related to normal and correlated subquery. It is a short article but gives you a solid concept rel...
-
I saw many of the DBA have the wrong concept related to stored procedure. They think that the stored procedures are pre-compiled. I ...
-
In this article I am trying to collects some facts related to temporary table and table variable. So let's start about it. ...
Thanks for your Script.
ReplyDeleteIt's really working