ÿþ<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/articles.dwt" codeOutsideHTMLIsLocked="false" --> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <!-- InstanceBeginEditable name="doctitle" --> <title>SQL Solutions</title> <!-- InstanceEndEditable --> <link href="../lsql.css" rel="stylesheet" type="text/css" /> <style type="text/css"> div.hr { height: 1px; width: 100%; line-height: 1px; font-size: 1px; border-bottom: solid 1px #ccc; margin-bottom: 10px; } p { margin: 1em 0 1em 0; } .h1 a, .h1 a:hover, .h1 a:active, .h1 a:visited { font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: #2b8ace; text-decoration: none; font-weight: bold; } .date { color: #999; position: relative; top: 9px; } div.hr { height: 1px; width: 100%; line-height: 1px; font-size: 1px; border-bottom: solid 1px #ccc; margin-bottom: 10px; } .alignright { float: right; } .alignleft { float: left; } a span.continue, a:visited span.continue { border: solid 1px #e5e5e5; padding: 3px 6px; background-color: #f7f7f7; } a:hover span.continue { background-color: #f0f0f0; border: solid 1px #d0d0d0; } a img { border: 0; } .date, .continue { font-weight: normal; } /* Post */ td.post-header { border-top: solid 1px #ddd; padding-top: 2em; background: url() repeat-x; } div.post-text { padding: 2em 0; } td.post-header p.header-paragraph { margin: 0; padding: 0; } /* Where title and date are */ form textarea { width: 100%; } .main_texts h3 { font: bold 12px arial, sans-serif; } pre { border: solid 1px #eee; padding: 1em; border-left: solid 2px #eee; font: 1em/1.4em 'lucida console'; color: #666; background-color: #f9f9f9; } #articles-home-link { padding-top: 10px; padding-bottom: 10px; background-repeat: repeat-x; } #articles-home-link a { font-size: 11px; background-image: none; background: transparent; } td.subnav { padding: 5px 9px 5px 25px; background-repeat: repeat-x; background-color: #ffffff; } td.subnav a { background: transparent; background-image: none; } td.article-link { text-indent: -11px; padding: 9px 9px 9px 25px; } td.article-link a { font-weight: normal; } td.post-text h3 { margin: 1.2em 0; color: #999; font-size: 1.2em; } p.image { float: right; margin: 0 0 1em 1em; border: solid 2px #ddd; } div.post-info { width: 110px; padding: 0; margin: 0 0 1em 1em; float: right; } div.post-info p.image { float: none; margin: 0; /* Override */ background-color: #eee; margin-bottom: 10px; overflow: hidden; width: 105px; } a.read-more { display: block; width: 91px; height: 19px; overflow: hidden; padding: 0; margin: 0; background: url('../images/btn_read_article.gif'); text-indent: -9999px; } td.article-link a, td.article-link a:link, td.article-link a:visited { font-weight: normal; } p span.h1 a, p span.h1 a:link, p span.h1 a:visited { font-size: 10pt; } </style> <!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable --><!-- InstanceParam name="banner-visible" type="boolean" value="false" --><!-- InstanceParam name="subnav-class" type="text" value="null" --><!-- InstanceParam name="wrapper-id" type="text" value="w03" --> <script type="text/JavaScript"> <!-- function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } //--> </script> </head> <body id="articles" onload="MM_preloadImages('../../images/bg_home.gif','../../images/bg_inner.gif','../../images/bg_prod_home.gif','../../images/bg_products.gif','../../images/subnav_bg.gif','../../images/subnav_a_bg.gif');"> <script src="http://www.sqlsolutions.com/Tracker.js" type="text/javascript"></script><script type="text/javascript">TrackPage();</script> <div id="logo"><a href="../index.html">SQL Solutions</a></div> <div id="aux-nav"><a href="../company/contact.html">Contact</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="../site-map/index.html">Site Map</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="../privacy/index.html">Privacy</a></div> <ul id="main-nav"> <li id="nav-home"><a href="../index.html">Home</a></li> <li id="nav-products"><a href="../products/index.html">Products</a></li> <li id="nav-services"><a href="../services/index.html">Services</a></li> <li id="nav-downloads"><a href="../downloads/index.html">Downloads</a></li> <li id="nav-purchase"><a href="http://sqlsolutions.com/tadownload/SQLOnlinePayment/Step2.aspx?sProducts=1">Purchase</a></li> <li id="nav-support"><a href="../support/index.html">Support</a></li> <!--<li id="nav-training"><a href="../training/index.html">SQL Training</a></li>--> <li id="nav-articles"><a href="index.html">Resources</a></li> <li id="nav-ask"><a href="../forum/">Forum</a></li> <li id="nav-company"><a href="../company/index.html">Company</a></li> </ul> <div id="bar-horz-gray-thick">&nbsp;</div> <div class="wrapper-main" id="w03"> <div id="column-nav" class="null"> <div style="text-align: center"> <span style="text-align: center;font-size: 12pt;"> <a href="DBA_Library.html"> <br /> <span style="color: #0000ff"><strong>DBA Library</strong><br /> </span> <br /> </a> </span> <span style="text-align: center;font-size: 12pt;"><strong>Latest articles </strong> </span> </div> <ul style="margin-right:10px"> <li> <a href="articles/Multiple_Databases_or_Multiple_Instances.htm"> Multiple Databases or Multiple Instances?</a><br /><br /></li> <li> <a href="articles/Performance%20of%20indexing%20of%20XML%20in%20MS%20SQL%202005.html"> Performance of indexing of XML in MS SQL 2005</a><br /><br /></li> <li> <a href="articles/When%20SQL%20Server%20Query%20Optimizer%20Is%20Wrong.htm"> When SQL Server Query Optimizer Is Wrong</a><br /><br /></li> <li> <a href="articles/SQL_Optimization.htm"> SQL Optimization</a><br /><br /></li> <li> <a href="articles/Disclaimer.html"> Disclaimer</a><br /><br /></li> <li> <a href="articles/Encrypted_Columns_and_SQL_Server_Performance.htm"> Encrypted Columns and SQL Server Performance</a><br /><br /></li> <li> <a href="articles/SQL_Server_2005_Data_Versioning_and_Performance.htm"> SQL Server 2005 Data Versioning and Performance</a><br /><br /></li> <li> <a href="articles/Temporary_Tables_vs._Table_Variables_and_Their_Effect_on_SQL_Server_Performance.htm"> Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance</a><br /><br /></li> <li> <a href="articles/SQL_Server_Cache_Hits_Ratio_and_SQL_Server_Performance.htm"> SQL Server Cache Hits Ratio and SQL Server Performance</a><br /><br /></li> <li> <a href="articles/Diagnosing_Database_Performance_Problems_with_SQL_Profiler_and_Lakeside_SQL_Trace_Analyzer.htm"> Diagnosing Database Performance Problems with SQL Profiler and Lakeside SQL Trace Analyzer</a><br /><br /></li> <li> <a href="articles/SQL_Server_Tutorial _A_SQL_Server_Experiment_and_its_Findings.htm"> SQL Server Tutorial: A SQL Server Experiment and its Findings</a><br /><br /></li> <li> <a href="articles/How_Values_with_Irregular_Selectivity_Impact_SQL_Server_Database_Performance.htm"> How Values with Irregular Selectivity Impact SQL Server Database Performance</a><br /><br /></li> <li> <a href="articles/Common_Bad_Practices_in_SQL_Development.htm"> Common Bad Practices in SQL Development that Lead to SQL Server Errors and Performance Problems</a><br /><br /></li> <li> <a href="articles/CLR_vs._T-SQL_and_Stored_Procedures_in_SQL_Server_2005.htm"> CLR vs. T-SQL and Stored Procedures in SQL Server 2005</a><br /><br /></li> <li> <a href="articles/SQL_2005_vs.SQL_2000_SQL_2005_is_not_always_faster.htm"> SQL 2005 vs. SQL 2000: SQL 2005 is not always faster</a><br /><br /></li> </ul> </div> <div id="block-right"><!-- InstanceBeginEditable name="content-area" --> <div> <div id="breadcrumbs"> <p><a href="../index.html"> home</a><img src="../images/bullet_breadcrumb.gif" alt="" width="17" height="11" /><a href="index.html"> articles</a><img src="../images/bullet_breadcrumb.gif" alt="" width="17" height="11" /> </p> </div> <div class="col-2"> <div class="inner-white"> <h4> Articles </h4> </div> <div class="article-main"> <table> <!-- ARTICLE START --> <tr> <td colspan="2" class="main_texts post-header" id="Td3" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/t-keyboard2.jpg"></p> <a class="read-more" href="articles/Multiple_Databases_or_Multiple_Instances.htm"> Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="18"></a><a href="articles/Multiple_Databases_or_Multiple_Instances.htm" rel="bookmark" title="Permanent Link to Multiple Databases or Multiple Instances?"> Multiple Databases or Multiple Instances? </a></span> <br> <span class="date">October 5th, 2007 </span> </p> <div class="post-text"> <p> <!--asdfasf--> </p> <p>Let s say you have 2 different applications, A and B, and only have one physical server. What is a best way to share that server between these 2 applications?</p> </div> </td> </tr> <tr> <td colspan="2" class="main_texts post-header" id="Td2" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/t-keyboard2.jpg"></p> <a class="read-more" href="articles/Performance%20of%20indexing%20of%20XML%20in%20MS%20SQL%202005.html"> Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="18"></a><a href="articles/Performance%20of%20indexing%20of%20XML%20in%20MS%20SQL%202005.html" rel="bookmark" title="Permanent Link to Performance of indexing of XML in MS SQL 2005"> Performance of indexing of XML in MS SQL 2005 </a></span> <br> <span class="date">October 4th, 2007 </span> </p> <div class="post-text"> <p> <!--asdfasf--> </p> <p> In this article we make a <a href="articles\disclaimer.html">'test drive'</a>&nbsp;of XML indexes. We compare a traditional database schema with 2&nbsp;master - Details tables versus one table where data is encoded in XML.</p> </div> </td> </tr> <tr> <td colspan="2" class="main_texts post-header" id="Td1" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/t-keyboard2.jpg"></p> <a class="read-more" href="articles/When%20SQL%20Server%20Query%20Optimizer%20Is%20Wrong.htm"> Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="18"></a><a href="articles/When%20SQL%20Server%20Query%20Optimizer%20Is%20Wrong.htm" rel="bookmark" title="Permanent Link to When SQL Server Query Optimizer Is Wrong"> When SQL Server Query Optimizer Is Wrong</a></span><br> <span class="date">May 9th, 2007 </span> </p> <div class="post-text"> <p> <!--asdfasf--> </p> <p> In most cases, SQL Server Optimizer generates optimal plans. It is impossible to compete with its internal knowledge of average disk access cost, record length or page fill ratio. But, there is one area where human expertise is always superior. </p> </div> </td> </tr> <tr> <td colspan="2" class="main_texts post-header" id="post-17" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/temporary-tables.jpg"></p> <a class="read-more" href="articles/SQL_Optimization.htm">Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="17"></a><a href="articles/SQL_Optimization.htm" rel="bookmark" title="Permanent Link to SQL Optimization">SQL Optimization</a></span><br> <span class="date">January 3rd, 2007 </span> </p> <div class="post-text"> <p> SQL optimization is a transformation of SQL statements, which produces exactly the same result, as an original query. This process requires a lot of creativity and intuition; it is more an <strong>Art</strong> than a <strong>Science</strong>.<br> </p> </div> </td> </tr> <tr> <td colspan="2" class="main_texts post-header" id="post-15" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/cache-hits-ratio.jpg"></p> <a class="read-more" href="articles/Encrypted_Columns_and_SQL_Server_Performance.htm"> Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="15"></a><a href="articles/Encrypted_Columns_and_SQL_Server_Performance.htm" rel="bookmark" title="Permanent Link to Encrypted Columns and SQL Server Performance"> Encrypted Columns and SQL Server Performance</a></span><br> <span class="date">October 29th, 2006 </span> </p> <div class="post-text"> <p> For legal reasons, it is very important to encrypt table column with sensitive data, like SSNs. SQL server 2005 allows you to encrypt data using different algorithms using symmetric and asymmetric keys. Alternatively, you can also use password-based encryption (that password must be supplied by the client to encrypt/decrypt data).<br> </p> </div> </td> </tr> <tr> <td colspan="2" class="main_texts post-header" id="post-13" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/t-keyboard2.jpg" alt="" title=""></p> <a class="read-more" href="articles/SQL_Server_2005_Data_Versioning_and_Performance.htm"> Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="13"></a><a href="articles/SQL_Server_2005_Data_Versioning_and_Performance.htm" rel="bookmark" title="Permanent Link to SQL Server 2005 Data Versioning and Performance"> SQL Server 2005 Data Versioning and Performance</a></span><br> <span class="date">October 10th, 2006 </span> </p> <div class="post-text"> <p> Data versioning is one of the most important features of SQL 2005. Different data readers can obtain different values from the same record, like in Oracle. It can be achieved using SNAPSHOT ISOLATION LEVEL or DATABASE SNAPSHOTS.</p> <p> In this study, we measure how these two new SQL Server 2005 features affect performance of data readers and data writers.<br> </p> </div> </td> </tr> <tr> <td colspan="2" class="main_texts post-header" id="post-12" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/temporary-tables.jpg"></p> <a class="read-more" href="articles/Temporary_Tables_vs._Table_Variables_and_Their_Effect_on_SQL_Server_Performance.htm"> Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="12"></a><a href="articles/Temporary_Tables_vs._Table_Variables_and_Their_Effect_on_SQL_Server_Performance.htm" rel="bookmark" title="Permanent Link to Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance"> Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance</a></span><br> <span class="date">September 13th, 2006 </span> </p> <div class="post-text"> <p> There are 3 major theoretical differences between temporary tables:<br> </p> </div> </td> </tr> <tr> <td colspan="2" class="main_texts post-header" id="post-11" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/cache-hits-ratio.jpg"></p> <a class="read-more" href="articles/SQL_Server_Cache_Hits_Ratio_and_SQL_Server_Performance.htm"> Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="11"></a><a href="articles/SQL_Server_Cache_Hits_Ratio_and_SQL_Server_Performance.htm" rel="bookmark" title="Permanent Link to SQL Server Cache Hits Ratio and SQL Server Performance"> SQL Server Cache Hits Ratio and SQL Server Performance</a></span><br> <span class="date">August 30th, 2006 </span> </p> <div class="post-text"> <p> As you know, one of the most important indicators of SQL server performance is a cache hits ratio. This is the percentage of pages that were found in the buffer pool without having to incur a read from disk. </p> <p> </p> </div> </td> </tr> <tr> <td colspan="2" class="main_texts post-header" id="post-10" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/sql-trace-analyzer.jpg" alt="" title=""></p> <a class="read-more" href="articles/Diagnosing_Database_Performance_Problems_with_SQL_Profiler_and_Lakeside_SQL_Trace_Analyzer.htm"> Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="10"></a><a href="articles/Diagnosing_Database_Performance_Problems_with_SQL_Profiler_and_Lakeside_SQL_Trace_Analyzer.htm" rel="bookmark" title="Permanent Link to Diagnosing Database Performance Problems with SQL Profiler and Lakeside SQL Trace Analyzer"> Diagnosing Database Performance Problems with SQL Profiler and Lakeside SQL Trace Analyzer</a></span><br> <span class="date">August 11th, 2006 </span> </p> <div class="post-text"> <p> Many large-scale and complex enterprise applications are now developed and deployed using Microsoft SQL Server. However, these applications often suffer from poor performance and scalability because the focus of the development process is on functionality, while performance and scalability are dealt with as an afterthought.<br> </p> </div> </td> </tr> <tr> <td colspan="2" class="main_texts post-header" id="post-9" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/sql-graph.jpg" alt="" title=""></p> <a class="read-more" href="articles/SQL_Server_Tutorial _A_SQL_Server_Experiment_and_its_Findings.htm"> Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="9"></a><a href="articles/SQL_Server_Tutorial _A_SQL_Server_Experiment_and_its_Findings.htm" rel="bookmark" title="Permanent Link to SQL Server Tutorial: A SQL Server Experiment and its Findings"> SQL Server Tutorial: A SQL Server Experiment and its Findings</a></span><br> <span class="date">July 30th, 2006 </span> </p> <div class="post-text"> <p> SQL server is not an ordinary application. Usually Windows applications use all the memory they need. If there is not enough memory on a server, some memory pages will be written into a page file. </p> <p> SQL server application is different. It is aware of the memory conditions on a server. When it is configured to adjust memory automatically (Dynamically-configured memory), it can  breathe , growing in size when there is a lot of free memory available, and reducing in size when  pressure from other program increases.</p> <p> Let s check how it works. Experiments are conducted on a small computer with only 512Mb of physical memory.<br> </p> </div> </td> </tr> <tr> <td colspan="2" class="main_texts post-header" id="post-8" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/t-execution-plan.jpg" alt="" title=""></p> <a class="read-more" href="articles/How_Values_with_Irregular_Selectivity_Impact_SQL_Server_Database_Performance.htm"> Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="8"></a><a href="articles/How_Values_with_Irregular_Selectivity_Impact_SQL_Server_Database_Performance.htm" rel="bookmark" title="Permanent Link to How Values with Irregular Selectivity Impact SQL Server Database Performance"> How Values with Irregular Selectivity Impact SQL Server Database Performance</a></span><br> <span class="date">July 17th, 2006 </span> </p> <div class="post-text"> <p> Values with irregular selectivity might dramatically degrade database performance. Well, the term  values with irregular selectivity may sound too scientific, but actually it is quite simple. I would even say that it is a <em>regular</em> thing.</p> <p> </p> </div> </td> </tr> <tr> <td colspan="2" class="main_texts post-header" id="post-6" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/t-execution-plan.jpg" alt="" title=""></p> <a class="read-more" href="articles/Common_Bad_Practices_in_SQL_Development.htm">Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="6"></a><a href="articles/Common_Bad_Practices_in_SQL_Development.htm" rel="bookmark" title="Permanent Link to Common Bad Practices in SQL Development that Lead to SQL Server Errors and Performance Problems"> Common Bad Practices in SQL Development that Lead to SQL Server Errors and Performance Problems</a></span><br> <span class="date">July 5th, 2006 </span> </p> <div class="post-text"> <p> There is one common mistake, which is repeated again and again, that it is definitely in the beginning of the  top ten list of common causes of the performance problems.</p> <p> </p> </div> </td> </tr> <tr> <td colspan="2" class="main_texts post-header" id="post-4" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/t-keyboard2.jpg" alt="" title=""></p> <a class="read-more" href="articles/CLR_vs._T-SQL_and_Stored_Procedures_in_SQL_Server_2005.htm"> Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="4"></a><a href="articles/CLR_vs._T-SQL_and_Stored_Procedures_in_SQL_Server_2005.htm" rel="bookmark" title="Permanent Link to CLR vs. T-SQL and Stored Procedures in SQL Server 2005"> CLR vs. T-SQL and Stored Procedures in SQL Server 2005</a></span><br> <span class="date">June 4th, 2006 </span> </p> <div class="post-text"> <p> CLR or TSQL? That is the question.</p> <p> More are more developers are struggling to find the right answer, but the answer really depends on the developer s individual needs.</p> <p> For classic SQL tasks, the good old TSQL is recommended. On the other hand, CLR works best for calculations, parsing, image processing and other tasks that deal with a very limited amount of data.</p> <p> We performed an experiment that defies the common perception that calculation tasks run several times faster when implemented in CLR form. For this experiment, we utilized a computer with Pentium 4 2.4GHZ processor and 1 Gb of RAM.</p> <p> </p> </div> </td> </tr> <tr> <td colspan="2" class="main_texts post-header" id="post-3" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/t-keyboard.jpg" alt="" title=""></p> <a class="read-more" href="articles/SQL_2005_vs.SQL_2000_SQL_2005_is_not_always_faster.htm"> Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="3"></a><a href="articles/SQL_2005_vs.SQL_2000_SQL_2005_is_not_always_faster.htm" rel="bookmark" title="Permanent Link to SQL 2005 vs. SQL 2000: SQL 2005 is not always faster"> SQL 2005 vs. SQL 2000: SQL 2005 is not always faster</a></span><br> <span class="date">June 2nd, 2006 </span> </p> <div class="post-text"> <p> We continued on with our experiments that call almost empty procedures thousands of times over. The results are once again revealing.</p> <p> Experiments are again done on a computer with Pentium 4 2.4GHz processor and 1Gb of RAM.</p> <p> </p> </div> </td> </tr> <tr> <td colspan="2" class="main_texts post-header" id="post-16" align="left" valign="top"> <div class="post-info"> <p class="image"> <img src="Articles_list_files/temporary-tables.jpg"></p> <a class="read-more" href="articles/Disclaimer.html">Read more</a> </div> <p class="header-paragraph"> <span class="h1"><a name="16"></a><a href="articles/Disclaimer.html" rel="bookmark" title="Permanent Link to Disclaimer">Disclaimer</a></span><br> <span class="date">June 1st, 2006 </span> </p> <div class="post-text"> <p> <strong>A test-drive of technologies. </strong> <br> </p> </div> </td> </tr> <!-- ARTICLE END --> </table> <table border="0" cellpadding="0" cellspacing="0"> <tbody> <tr> <td colspan="2" class="dashes" align="left" valign="top" style="height: 5px"> <div class="hr"></div> </td></tr> <tr> <td colspan="2" class="main_texts disclaimer" align="left" valign="top"> <div style="margin:10px"> <strong>Disclaimer:</strong><br> <p style="color: rgb(102, 102, 102);"> In many articles you will find the execution times of different queries. Please do not interpret these results scientifically or as official benchmarks. You will not even find the configuration of the computer used for these experiments because it is rather unimportant.</p> <p style="color: rgb(102, 102, 102);"> What is important is that query A is running 2 times slower then query B. On your computer, it could be different: 1.5 or even 3 times slower. <a href="articles/Disclaimer.html"> Read the full disclaimer »</a> </p> </div> </td></tr> <tr> <td colspan="2" class="dashes" align="left" valign="top" style="height: 5px"> <div class="hr">&nbsp;</div> </td></tr> </tbody> </table> </div> </div> </div> <!-- InstanceEndEditable --></div> </div> <div id="footer"> <div id="footer-text"> <p><a href="../index.html">Home</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="../products/index.html">Products</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="../services/index.html">Services</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="../downloads/index.html">Downloads</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="http://sqlsolutions.com/tadownload/SQLOnlinePayment/Step2.aspx?sProducts=1">Purchase</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="../support/index.html">Support</a>&nbsp;&nbsp;<!--|&nbsp;&nbsp;<a href="../training/index.html">SQL Training</a>&nbsp;&nbsp;-->|&nbsp;&nbsp;<a href="index.html">Articles</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="../forum/">Forum</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="../company/index.html">Company</a>&nbsp;&nbsp;|&nbsp;&nbsp;<img src="../images/bullet_top.gif" alt="" width="17" height="11" />&nbsp;<a href="#">Back to Top</a></p> <p>Copyright © 2007 SQL Solutions. All rights reserved.</p> </div> <div id="logo-partner">Microsoft&reg; Certified Partner</div> </div> <script src="http://www.google-analytics.com/urchin.js" type="text/javascript"> </script> <script type="text/javascript"> _uacct = "UA-3292604-1"; urchinTracker(); </script> </body> <!-- InstanceEnd --></html>