All posts are AS IS, without any further guarantees or warranties.
Recently, an ISV I work with ran into an interesting problem with Filtered Indexes. The application...
Date: 06/29/2009
Recently I worked with a partner who was seeing some interesting behavior. Upon rebuilding their...
Date: 05/18/2009
An ISV recently found an anomoly in their implementation of a "drop table partition" function which...
Date: 04/10/2009
JDK APIs for Class “java.util.Date” and “java.sql.Timestamp” (subclass of Date) including...
Date: 03/26/2009
In one of our recent lab tests we were surprised to see blocking occur on a table that did not...
Date: 02/02/2009
SQL Server 2008 introduced what we call the Management Data Warehouse. The Management Data Warehouse...
Date: 01/29/2009
Using parameterized queries is a well known SQL Server Best Practice. This technique ensures caching...
Date: 11/26/2008
In previous SQL Server releases it wasn’t possible to convert binary data to string characters in...
Date: 10/31/2008
I have been asked by many customers and partners, especially those migrating from Oracle, this...
Date: 08/22/2008
NOTE: the code in this BLOG is TSQL instead of ODBC calls. Since ODBC can be hard to understand and...
Date: 07/11/2008
For many ISVs run that into issues at customer sites, it is sometimes difficult to isolate...
Date: 06/26/2008
Recently many customers of an ISV I work with, reported intermittent connectivity issues when...
Date: 05/27/2008
In SQL Server 2008 Microsoft has introduced a number of new date and time data types. One of these...
Date: 03/18/2008
You have probably heard many times, from different sources, that as a best practice; avoid using...
Date: 03/18/2008
SQL Server 2008 has a new feature called Filestream, which allows you to save large binary files in...
Date: 03/06/2008
Did you know that SQL Server 2008 is just around the corner, and that the SQL development team has...
Date: 02/25/2008
When SQL Server has an optimal index that satisfies the search predicates of a query the optimizer...
Date: 06/29/2007
Please have a look at four new Best Practices Articles SQL Server 2005 Predeployment I/O best...
Date: 06/05/2007
With 64-bit servers becoming more mainstream and SQL Server customers running more deployments on...
Date: 04/30/2007
Upgrading to SQL Server 2005 has many benefits . As we look back at the past year and the deployment...
Date: 03/23/2007
Just a quick note that this is by design and no you don't need to use it. What are we talking about...
Date: 02/22/2007
Did you know there is a great place to get real-world best practices for SQL Server 2005:...
Date: 02/08/2007
The following queries can be used to understand plan cache behavior. It should be noted that for...
Date: 01/23/2007
3.1 Costing algorithm change between SQL Server 2000 and SQL Server 2005 RTM In SQL Server 2000 and...
Date: 01/22/2007
Plan cache related performance problems usually manifest in decrease in throughput (or increase in...
Date: 01/21/2007
If after upgrading from SQL 2000 to SQL 2005 RTM and/or SP1, you notice decreased OLTP database...
Date: 01/20/2007
11.1 Temporary Tables versus Table Variables In order to determine if table variables or temporary...
Date: 01/18/2007
In SQL Server 2005, certain database maintenance operations or certain dbcc commands such as “dbcc...
Date: 01/17/2007
The procedure cache responds to memory pressure like all other cache stores built using the common...
Date: 01/16/2007
During batch compilation we make a determination regarding the cache-ability of the batch. Each...
Date: 01/15/2007
A uniform costing scheme has been implemented for all cache stores in SQL Server 2005. The cost of a...
Date: 01/14/2007
In this section we will outline some programming practices for efficient plan cache usage: 6.1...
Date: 01/13/2007
P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman";...
Date: 01/12/2007
Each cache store is implemented as a hash table. A hash value and cache key pair is used in order to...
Date: 01/10/2007
2.1 What is a Plan_Handle Cached compiled plans are stored in the SQLCP or the OBJCP cache stores. A...
Date: 01/09/2007
The plan cache is comprised of 4 separate cache stores: Object Plans (CACHESTORE_OBJCP), SQL Plans...
Date: 01/09/2007
Since the release of SQL Server 2005 there have been several questions around how plan caching has...
Date: 01/08/2007
Many applications have a functional requirement for the underlying database to have a case-sensitive...
Date: 01/04/2007
Imagine a customer using an ISV application that stores certain product information in a...
Date: 12/01/2006
In general, equality comparisons make a lot of sense with uniqueidentifier values. However, if you...
Date: 11/06/2006
Many ISVs and ISV customers often have a need to duplicate their database server in entirety onto...
Date: 10/17/2006
Occasionally we hear from people who are surprised to find that their XML data uses more space when...
Date: 09/26/2006
Introduction Login statistics is a useful mechanism to keep track of login activity on a server...
Date: 08/16/2006
ISV applications today often require international support. Migrating an existing non-Unicode...
Date: 07/07/2006
There have been some questions about the sysadmin requirement of SQL Server 2005 Debugging, and I’d...
Date: 06/30/2006
Many ISV applications use ODBC API Server Cursors. One source of developer confusion when coding and...
Date: 06/29/2006
MARS is a powerful tool, but you may shoot yourself by the foot if you don't use it correctly. In...
Date: 06/23/2006
When the user code will try to access a resource outside of the SQL server it will run in the...
Date: 06/17/2006