Browse by Tags

Blog Post: Under rare conditions, using IN clause can cause unexpected SQL behavior

SQL Server Support Content

I want to make you aware of a latest SQL Server 2008 hotfix documented in http://support.microsoft.com/kb/2791745 . Using large number of constants in IN clause can result in SQL Server termination unexpectedly. When this happens ...read more

on 12 Feb 2013
Blog Post: Forced Parameterization Can Lead to Poor Performance

SQL Server Support Content

Something that is a relatively common performance eye opener is when you have a large ad hoc workload, and you’re getting a huge gap in the lack of plan reuse. You talk to the application team that is responsible for this possibly dreaded scenario ...read more

on 3 Sep 2013
Blog Post: Oops… I forgot to leave an empty SQL table partition, how can I split it with minimal IO impact?

SQL Server Support Content

One of the several advantages you get with partitioning a very large table is the ability to add or remove partitions instantaneously to help you with sliding window scenarios. However there are caveats if best practices aren’t followed. If the right ...read more

on 13 Aug 2013
Blog Post: A performance issue involving CLR garbage collection and SQL CPU affinity setting

SQL Server Support Content

We have been troubleshooting a customer’s case and uncovered a GC behavior with SQL Server CPU affinity that is worth sharing here in a blog. Problem Customer reported that they had two instances of SQL Server 2008 running on a two-node cluster. ...read more

on 11 Jun 2013
Blog Post: High CPU Troubleshooting with DMV Queries

SQL Server Support Content

High CPU Troubleshooting with DMV Queries Scenario: Recently, a customer called Microsoft Support with a critical performance issue that I worked on. Their SQL Server instance had 100% CPU utilization for a period, but the problem stopped without ...read more

on 17 Jun 2013
Blog Post: Interpreting the counter values from sys.dm_os_performance_counters

SQL Server Support Content

The performance counters exposed by SQL Server are invaluable tools for monitoring various aspects of the instance health. The counter data is exposed as a shared memory object for the windows performance monitoring tools to query. It is also available ...read more

on 23 Sep 2013
Blog Post: How Simple Parameterization works

SQL Server Support Content

Recently we got a customer who upgraded from SQL Server 2005 to 2008. But their performance degraded greatly. What happened was that they had an update query that was run many times in a batch. The query was submitted as ad hoc by the application with ...read more

on 4 Dec 2013
Blog Post: Don’t change value of that parameter

SQL Server Support Content

Parameter sniffing is a well known among SQL User community. But I have seen variations of this frequently that need a bit creative handling and solution may not that straight forward. One of the variation is that a user changes the value ...read more

on 3 Feb 2013
Blog Post: Query hint QUERYTRACEON is now documented publically

SQL Server Support Content

I just wanted to put a quick note that QUERYTRACEON is now publically documented in http://support.microsoft.com/kb/2801413/en-us . If you have situations where you don’t want to enable an optimizer trace flag globally on your server instance, you ...read more

on 7 Feb 2013
Blog Post: Optimizing partition split when the partition is not empty

SQL Server Support Content

Some of our Field Engineers, Kal Yella and Denzil Ribeiro ( @DenzilRibeiro ) have posted a blog that discusses how to optimize adding a partition when either the right most, or left most partition is not empty.. It is well worth the read, so we ...read more

on 13 Aug 2013

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

SQL Server KBs and Blogs

Browse by Tags

Blog Post: Under rare conditions, using IN clause can cause unexpected SQL behavior

Blog Post: Forced Parameterization Can Lead to Poor Performance

Blog Post: Oops… I forgot to leave an empty SQL table partition, how can I split it with minimal IO impact?

Blog Post: A performance issue involving CLR garbage collection and SQL CPU affinity setting

Blog Post: High CPU Troubleshooting with DMV Queries

Blog Post: Interpreting the counter values from sys.dm_os_performance_counters

Blog Post: How Simple Parameterization works

Blog Post: Don’t change value of that parameter

Blog Post: Query hint QUERYTRACEON is now documented publically

Blog Post: Optimizing partition split when the partition is not empty