Dears ,
We Are currently moving to our new blog , please take a look and give us your feedback.
Check it through he following link:
Thank you.
Saturday, January 19, 2013
Tuesday, March 16, 2010
Tuesday, August 19, 2008
SQL SERVER - SQL Commandments - Suggestions, Tips, Tricks
1. Know your data and business application well.Familiarize yourself with these sources; you must be aware of the data volume and distribution in your database.
2. Test your queries with realistic data.A SQL statement tested with unrealistic data may behave differently when used in production. To ensure rigorous testing, the data distribution in the test environment must also closely resemble that in the production environment.
3. Write identical SQL statements in your applications.Take full advantage of stored procedures, and functions wherever possible. The benefits are performance gain as they are precompiled.
4. Use indexes on the tables carefully.Be sure to create all the necessary indexes on the tables. However, too many of them can degrade performance.
5. Make an indexed path available.To take advantage of indexes, write your SQL in such a manner that an indexed path is available to it. Using SQL hints is one of the ways to ensure the index is used.
6. Understand the Optimizer.Understand the optimizer how it uses indexes, where clause, order by clause, having clause, etc.
7. Think globally when acting locally.Any changes you make in the database to tune one SQL statement may affect the performance of other statements used by applications and users.
8. The WHERE clause is crucial.The following WHERE clauses would not use the index access path even if an index is available.e.g. Table1Col1 (Comparision Operator like >, <, >=, <=,) Table1Col2, Table1Col1 IS (NOT) NULL, Table1Col1 NOT IN (value1, value2), Table1Col1 != expression, Table1Col1 LIKE ‘%pattern%’, NOT Exists sub query.
9. Use WHERE instead of HAVING for record filtering.Avoid using the HAVING clause along with GROUP BY on an indexed column.
10. Specify the leading index columns in WHERE clauses.For a composite index, the query would use the index as long as the leading column of the index is specified in the WHERE clause.
11. Evaluate index scan vs. full table scan. (Index Only Searches Vs Large Table Scan, Minimize Table Passes)If selecting more than 15 percent of the rows from a table, full table scan is usually faster than an index access path. An index is also not used if SQL Server has to perform implicit data conversion. When the percentage of table rows accessed is 15 percent or less, an index scan will work better because it results in multiple logical reads per row accessed, whereas a full table scan can read all the rows in a block in one logical read.
12. Use ORDER BY for index scan.SQL Server optimizer will use an index scan if the ORDER BY clause is on an indexed column. The following query illustrates this point.
13. Minimize table passes.Usually, reducing the number of table passes in a SQL query results in better performance. Queries with fewer table passes mean faster queries.
14. Join tables in the proper order.Always perform the most restrictive search first to filter out the maximum number of rows in the early phases of a multiple table join. This way, the optimizer will have to work with fewer rows in the subsequent phases of join, improving performance.
15. Redundancy is good in where condition.Provide as much information as possible in the WHERE clause. It will help optimizer to clearly infer conditions.
16. Keep it simple, stupid.Very complex SQL statements can overwhelm the optimizer; sometimes writing multiple, simpler SQL will yield better performance than a single complex SQL statement.
17. You can reach the same destination in different ways.Each SQL may use a different access path and may perform differently.
18. Reduce network traffic and increase throughput.Using T-SQL blocks over Multiple SQL statements can achieve better performance as well as reduce network traffic. Stored Procedures are better over T-SQL blocks as they are stored in SQL Server and they are pre-compiled.
19. Better Hardware.Better hard ware always helps performance. SCACI drives, Raid 10 Array, Multi processors CPU, 64-bit operating system improves the performance by great amount.
20. Avoid Cursors.Using SQL Server cursors can result in some performance degradation in comparison with select statements. Try to use correlated sub query or derived tables if you need to perform row-by-row operations
2. Test your queries with realistic data.A SQL statement tested with unrealistic data may behave differently when used in production. To ensure rigorous testing, the data distribution in the test environment must also closely resemble that in the production environment.
3. Write identical SQL statements in your applications.Take full advantage of stored procedures, and functions wherever possible. The benefits are performance gain as they are precompiled.
4. Use indexes on the tables carefully.Be sure to create all the necessary indexes on the tables. However, too many of them can degrade performance.
5. Make an indexed path available.To take advantage of indexes, write your SQL in such a manner that an indexed path is available to it. Using SQL hints is one of the ways to ensure the index is used.
6. Understand the Optimizer.Understand the optimizer how it uses indexes, where clause, order by clause, having clause, etc.
7. Think globally when acting locally.Any changes you make in the database to tune one SQL statement may affect the performance of other statements used by applications and users.
8. The WHERE clause is crucial.The following WHERE clauses would not use the index access path even if an index is available.e.g. Table1Col1 (Comparision Operator like >, <, >=, <=,) Table1Col2, Table1Col1 IS (NOT) NULL, Table1Col1 NOT IN (value1, value2), Table1Col1 != expression, Table1Col1 LIKE ‘%pattern%’, NOT Exists sub query.
9. Use WHERE instead of HAVING for record filtering.Avoid using the HAVING clause along with GROUP BY on an indexed column.
10. Specify the leading index columns in WHERE clauses.For a composite index, the query would use the index as long as the leading column of the index is specified in the WHERE clause.
11. Evaluate index scan vs. full table scan. (Index Only Searches Vs Large Table Scan, Minimize Table Passes)If selecting more than 15 percent of the rows from a table, full table scan is usually faster than an index access path. An index is also not used if SQL Server has to perform implicit data conversion. When the percentage of table rows accessed is 15 percent or less, an index scan will work better because it results in multiple logical reads per row accessed, whereas a full table scan can read all the rows in a block in one logical read.
12. Use ORDER BY for index scan.SQL Server optimizer will use an index scan if the ORDER BY clause is on an indexed column. The following query illustrates this point.
13. Minimize table passes.Usually, reducing the number of table passes in a SQL query results in better performance. Queries with fewer table passes mean faster queries.
14. Join tables in the proper order.Always perform the most restrictive search first to filter out the maximum number of rows in the early phases of a multiple table join. This way, the optimizer will have to work with fewer rows in the subsequent phases of join, improving performance.
15. Redundancy is good in where condition.Provide as much information as possible in the WHERE clause. It will help optimizer to clearly infer conditions.
16. Keep it simple, stupid.Very complex SQL statements can overwhelm the optimizer; sometimes writing multiple, simpler SQL will yield better performance than a single complex SQL statement.
17. You can reach the same destination in different ways.Each SQL may use a different access path and may perform differently.
18. Reduce network traffic and increase throughput.Using T-SQL blocks over Multiple SQL statements can achieve better performance as well as reduce network traffic. Stored Procedures are better over T-SQL blocks as they are stored in SQL Server and they are pre-compiled.
19. Better Hardware.Better hard ware always helps performance. SCACI drives, Raid 10 Array, Multi processors CPU, 64-bit operating system improves the performance by great amount.
20. Avoid Cursors.Using SQL Server cursors can result in some performance degradation in comparison with select statements. Try to use correlated sub query or derived tables if you need to perform row-by-row operations
Found On sqlauthority
Monday, February 11, 2008
We Are The Champion - (Ghana 2008)
Egyptian people after Wining the African Cup go to streets to express its happiness about the result of match between the Pharoahs and Cameroon National team.
Egypt deserved their win in Accra, after A bog effort from Mohamed Zidan with the Ball and fininshed by Abotrika but Cameroon who had held out well for the most part eventually only fell victim to a simply suicidal goal.
Good job Ya Regalah
Sunday, February 3, 2008
تعاطغا مع غزة
لقد بلغت الإنسانية دركاً متدنياً لم يسبق له مثيل في الانحطاط من قبل، فلا الدين ولا العقل ولا القانون ولا شرعة حقوق الإنسان تقبل بالجريمة الأشنع ضد الإنسانية التي اقترفها الكيان الصهيوني بحق أهلنا الأبرياء في غزة.
ندعو الله سبحانه وتعالى بفك الحصار عن اخواننا الفلسطينين
"لفته جميله من الفنان ابو تريكا في مباراة السودان لمؤازرة اهل غزةلقد استطاع فعل ما عجز عنه السياسيون "
Thursday, December 27, 2007
Adding ASP.NET AJAX to an Existing ASP.NET Application
ASP. NET AJAX makes it easily to take advantage of AJAX techniques and enables you to create ASP.NET pages, and enables you to take full advantage of the capabilities of the browser to deliver richer Web experiences that work on any modern browser.
how to upgrade an existing asp.net 2.0 web app?
You add ASP.NET AJAX functionality to the application by adding a reference to the ASP.NET AJAX assembly,
I explain how to use ajax using XMLHttpRequest object in details in an article in codeproject.
Ttake your time reading the article and waiting for your comments, questions and queries .
See how to add ASP.NET AJAX to an existing ASP.NET 2.0 application article i hope you enjoy the article
Monday, December 3, 2007
Marie Digby
We don't have to see TV shows to find talented people like Star Maker,Super Star, or any other TV shows .
All we need is just the internet ,You can find many talented people in the internet wating for thier chance . Marie Digby is one from those who used the internet to broadcast her songs, people know her throw the internet in http://www.youtube.com/
over than 6 milion watch her clips till now .i hope producer check the internet and find more and more talnted people Check this song Umberlla :D
All we need is just the internet ,You can find many talented people in the internet wating for thier chance . Marie Digby is one from those who used the internet to broadcast her songs, people know her throw the internet in http://www.youtube.com/
over than 6 milion watch her clips till now .i hope producer check the internet and find more and more talnted people Check this song Umberlla :D
Subscribe to:
Posts (Atom)