Detecting Overlapping Indexes in SQL Server 2005

  When SQL Server has an optimal index that satisfies the search predicates of a query the optimizer performs an index SEEK operation as opposed to an index (or table) scan to retrieve the required rows; this is desirable.  Based on this, one may be led to believe that having an index for every possible…

3

New SQL Best Practice Articles now available

Please have a look at four new Best Practices Articles SQL Server 2005 Predeployment I/O best practices http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx                                by SQLISVPM team member Mike Ruthruff SQL Server 2005 Deployment Guidance for Web Hosting Environments http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/SQL2005DGWHE.mspxby Alex DeNeui Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarioshttp://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspxby Carl Rabeler Implementing Application Failover with Database…

1

Will 64-bit increase the performance of my SQL Server application?

With 64-bit servers becoming more mainstream and SQL Server customers running more deployments on native 64-bit Windows there is a common misperception that running on 64-bit will always provide an increase in performance over 32-bit.  Many customers are surprised to find that some workloads actually run faster on 32-bit SQL Server than on the native…

5

Upgrading to SQL Server 2005 and DEFAULT_SCHEMA setting.

Upgrading to SQL Server 2005 has many benefits . As we look back at the past year and the deployment of SQL Server 2005 with our ISV partners, one important but under-advertised feature in SQL Server 2005 became increasingly visible; the ability to control the dynamic name resolution behavior. This capability applies to workloads where object…

3

Best Practices for SQL Server 2005

Did you know there is a great place to get real-world best practices for SQL Server 2005:  http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx This Best Practices site contians information such as Technical Whitepapers, Best Practices Toolbox which contains scripts and other tools for performance tuning and troubleshooting, Top 10 lists, and best practice information compiled from the SQL Server Books Online…

0

Case-insensitive Search Operations

  Many applications have a functional requirement for the underlying database to have a case-sensitive sort-order, implying that all character data related operations are case-sensitive.  With SQL Server, such databases are created with either the ‘binary’ or any of the case-sensitive (CS) sort orders (collations).  Often times these applications also need to perform case-insensitive searches…

1