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
-
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...
-
We have common doubts when to update statistics, before index or after index. To resolve this query we must understand, what is the stati...
-
SQL Server will reuse space made available when rows are deleted from a table. This occurs automatically without any outside intervention on...
-
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...
-
In this article we have to learn the covered index. As the name suggest the cover index "COVER" all the columns in the selec...
-
Lambda expression is an inline delegate introduced with C # 3.0 languages. It's a concise way to represent an anonymous method. It p...
-
JOIN HINT in SQL, What and When: Joint hint specifies that the query optimizer enforced the join strategy before joining two tables. ...
-
This article gives you a total overall idea related to collation. It not only contains definition but also contains SQL comparisons an...
-
Transaction is a very important part of SQL developer. In this article I am taking about the SAVEPOINT of MS SQL Server and how we use th...
-
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 ...
Thanks for your Script.
ReplyDeleteIt's really working