Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

Monday, June 29, 2009 12:56 PM

Interesting issue with Filtered indexes.

Recently, an ISV I work with ran into an interesting problem with Filtered Indexes. The application does all SQL INSERT, DELETE, and UPDATE operations using individual stored procedures. To improve performance, they decided to create a Filtered Index
Posted by mssqlisv | 0 Comments
Monday, May 18, 2009 10:57 AM

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 indexes they noticed that the total space used by all indexes increased significantly. The table has no clustered index but does have a total of nine non-clustered
Posted by mssqlisv | 1 Comments
Friday, April 10, 2009 1:43 PM

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 could lead to unexpected partitions being switched out. Typically, to do this "drop partition logic" SQL Server partitions are manipulated using the following
Posted by mssqlisv | 1 Comments
Thursday, March 26, 2009 2:30 PM

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 getHours(), getMinutes(), getSeconds(), getTimestamp() allow you to retrieve date/time related information. However, the JVM (Java Virtual Machine) won’t handle
Posted by mssqlisv | 1 Comments
Monday, February 02, 2009 10:20 AM

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 participate in the transaction being reported as the cause of the blocking. From the sp_lock output we noticed an ‘X’ lock being held on the table, but we could
Posted by mssqlisv | 1 Comments
Thursday, January 29, 2009 8:19 AM

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 is a relational database that contains the data that is collected from a server using the new SQL Server 2008 data collection mechanism. The Warehouse
Posted by mssqlisv | 1 Comments
Wednesday, November 26, 2008 2:35 PM

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 and reuse of existing query execution plans (instead of constantly compiling new plans), as well as avoiding SQL injection by mandating that input data
Posted by mssqlisv | 5 Comments
Friday, October 31, 2008 1:49 PM

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 hex format directly, because SQL Server did not have a built-in Transact-SQL command for converting binary data to a hexadecimal string. The Transact-SQL
Posted by mssqlisv | 0 Comments
Friday, August 22, 2008 1:54 PM

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 question: how to create an autonomous transaction in SQL Server? It turns out to be a tricky thing to do since SQL Server doesn't have built-in autonomous transaction
Posted by mssqlisv | 5 Comments
Friday, July 11, 2008 1:51 PM

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 other API’s will have the same basic issues, I decided to use the simpler and more concise TSQL, which should also appeal to a wider audience. An ISV I
Posted by mssqlisv | 1 Comments
Thursday, June 26, 2008 10:13 AM

Use SQL Server replay tools to reproduce and resolve customer issues

For many ISVs run that into issues at customer sites, it is sometimes difficult to isolate underlying problems, especially on a 24x7 production environment, where limitations apply to real time troubleshooting and live debugging. In situations like this,
Posted by mssqlisv | 1 Comments
Tuesday, May 27, 2008 10:49 AM

SQL Server Intermittent Connectivity Issue

Recently many customers of an ISV I work with, reported intermittent connectivity issues when running the ISV application on SQL Server. Some customers reported the issue to be SQL Server 2005 specific. Others stated that they are experiencing the same
Posted by mssqlisv | 2 Comments
Tuesday, March 18, 2008 4:25 PM

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 is the datetimeoffset data type. This data type includes an offset from UTC time as well as the datetime value and ensures that the datetime can be retrieved
Posted by mssqlisv | 5 Comments
Tuesday, March 18, 2008 3:49 PM

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 TSQL cursors. During a recent visit to a partner we ran into a common cursor case, which I wanted to use as an example to demonstrate why you should avoid
Posted by mssqlisv | 2 Comments
Thursday, March 06, 2008 11:33 AM

Appending Data Using SQL 2008 Filestream

SQL Server 2008 has a new feature called Filestream, which allows you to save large binary files in the file system, instead of in the database. This is targeted directly at the scenario that many document management and web applications have today where
Posted by mssqlisv | 1 Comments
More Posts Next page »
 
Page view tracker