Microsoft SQLCAT ISV Program Management Team
Asynchronous Population of a Cursor May Result in Performance Degradation
SQL Server offers an option to asynchronously populate API created keyset and static server cursors...
Date: 07/29/2009
Interesting issue with Filtered indexes.
Recently, an ISV I work with ran into an interesting problem with Filtered Indexes. The application...
Date: 06/29/2009
Why did the size of my indexes expand when I rebuilt my indexes?
Recently I worked with a partner who was seeing some interesting behavior. Upon rebuilding their...
Date: 05/18/2009
SQL Server 2005 / 2008 table partitioning : Important things to consider when switching-out partitions.
An ISV recently found an anomoly in their implementation of a "drop table partition" function which...
Date: 04/10/2009
Avoid using JDK Date APIs to handle timezone sensitive date and time
JDK APIs for Class “java.util.Date” and “java.sql.Timestamp” (subclass of Date) including...
Date: 03/26/2009
Zeroing in on blocking on seemingly unrelated tables
In one of our recent lab tests we were surprised to see blocking occur on a table that did not...
Date: 02/02/2009
Using SQL Server 2008 Management Data Warehouse for database monitoring in my application
SQL Server 2008 introduced what we call the Management Data Warehouse. The Management Data Warehouse...
Date: 01/29/2009
OPTIMIZE FOR UNKNOWN – a little known SQL Server 2008 feature
Using parameterized queries is a well known SQL Server Best Practice. This technique ensures caching...
Date: 11/26/2008
SQL Server 2008 : new binary – hex string conversion functionality can dramatically improve related query performance by orders of magnitude.
In previous SQL Server releases it wasn’t possible to convert binary data to string characters in...
Date: 10/31/2008
Designing Composite Indexes
When it comes to creating composite indexes there are two questions I get asked most often by the...
Date: 09/26/2008
How to create an autonomous transaction in SQL Server 2008
I have been asked by many customers and partners, especially those migrating from Oracle, this...
Date: 08/22/2008
UPDATE with OUTPUT clause – Triggers – and SQLMoreResults
NOTE: the code in this BLOG is TSQL instead of ODBC calls. Since ODBC can be hard to understand and...
Date: 07/11/2008
Use SQL Server replay tools to reproduce and resolve customer issues
For many ISVs that run into issues at customer sites it is sometimes difficult to isolate underlying...
Date: 06/26/2008
SQL Server Intermittent Connectivity Issue
Recently many customers of an ISV I work with, reported intermittent connectivity issues when...
Date: 05/27/2008
Using time zone data in SQL Server 2008
In SQL Server 2008 Microsoft has introduced a number of new date and time data types. One of these...
Date: 03/18/2008
Increase your SQL Server performance by replacing cursors with set operations
You have probably heard many times, from different sources, that as a best practice; avoid using...
Date: 03/18/2008
Appending Data Using SQL 2008 Filestream
SQL Server 2008 has a new feature called Filestream, which allows you to save large binary files in...
Date: 03/06/2008
Now is time to try SQL Server 2008
Did you know that SQL Server 2008 is right around the corner, and that the SQL development team has...
Date: 02/25/2008
Detecting Overlapping Indexes in SQL Server 2005
When SQL Server has an optimal index that satisfies the search predicates of a query the optimizer...
Date: 06/29/2007
New SQL Best Practice Articles now available
Please have a look at four new Best Practices Articles SQL Server 2005 Predeployment I/O best...
Date: 06/05/2007
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...
Date: 04/30/2007
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...
Date: 03/23/2007
Best Practices for SQL Server 2005
Did you know there is a great place to get real-world best practices for SQL Server 2005:...
Date: 02/08/2007
Case-insensitive Search Operations
Many applications have a functional requirement for the underlying database to have a case-sensitive...
Date: 01/04/2007
Knowing about 'Forwarded Records' can help diagnose hard to find performance issues.
Imagine a customer using an ISV application that stores certain product information in a...
Date: 12/01/2006
Resolving Login Errors with Duplicated Databases
Many ISVs and ISV customers often have a need to duplicate their database server in entirety onto...
Date: 10/17/2006
SQL Server 2005 UNICODE considerations.
ISV applications today often require international support. Migrating an existing non-Unicode...
Date: 07/07/2006
Three significant Cursor changes in SQL Server 2005
Many ISV applications use ODBC API Server Cursors. One source of developer confusion when coding and...
Date: 06/23/2006
The Perils of Multi-valued logic
Perils of NULL usage: I know there is a religious war about the use of NULLs and I don’t want to go...
Date: 05/30/2006
SQL 2000 SP4 behavior change when using API cursors to be aware of.
A few customers and ISVs who’ve applied SQL Server 2000 Service Pack 4 (SP4) have observed...
Date: 05/18/2006
SQL Optimizations - Manual Update statistics on small tables may provide a big impact.
Problem: When I analyzed a performance problem in an ISV data warehouse solution running on SQL...
Date: 05/11/2006
SQL Optimizations – A well concealed transform that can cut that much needed millisecond out of your query.
SQL Server Optimizer is full of surprises… Optimizer uses many transformations to find the best...
Date: 05/05/2006
SQL Server 2005 Service Pack 1 Released
SQL Server 2005 SP1 is now generally available for download via the web at:...
Date: 04/20/2006
How to Block fetch over a Default Result Set
Problem: When I was design/performance reviewing an ISV ODBC application, I turned on SQL Server...
Date: 03/24/2006
Stay tuned for the SQL Server ISV Program Management Team BLOG
Hi SQL Server Community! Did you know that the SQL Server Product development team has a team of...
Date: 03/15/2006