Browse by Tags

Tagged Content List
  • Blog Post: SQLCAT.Com - eBook Downloads

    As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication. MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated...
  • Blog Post: Tuning Spatial Point Data Queries in SQL Server 2012

    Written by : Ed Katibah, Milan Stojic, Michael Rys, Nicholas Dritsas Technical reviewers : Chuck Heinzelman Introduction : Spatial Point Data queries require particular tuning efforts to enhance performance and improve overall application throughput. SQL Server 2012 introduces a few key new features...
  • Blog Post: A Computed Column Defined with a User-Defined Function Might Impact Query Performance

    Author: Kun Cheng Reviewers: Shaun Tinline-Jones, Silvano Coriani, Steve Howard, Thomas Kejser, Sanjay Mishra A computed column is computed from an expression that can use other columns in the same table. The expression can be a noncomputed column name, constant, function, and any combination of...
  • Blog Post: Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot

    Author : Shaun Tinline-Jones Reviewers : Mike Ruthruff, Sanjay Mishra, Alexei Khalyako Not too long ago an ISV that developed solutions using SQL Server as the RDBMS, asked me how they could query a database as at a point in time. This was a relatively easy answer, thanks to the Database Snapshot...
  • Blog Post: Maximizing SQL Server Throughput with RSS Tuning

    Author : Kun Cheng Reviewers : Thomas Kejser, Curt Peterson, James Podgorski, Christian Martinez, Mike Ruthruff Receive-Side Scaling (RSS) was introduced in Windows 2003 to improve Windows scalability to handle heavy network traffic, which is typically the case for SQL Server OLTP workload. For...
  • Blog Post: Optimize Recursive CTE Query

    Author : Shaun Tinline-Jones Reviewers: Lubor Kollar; Conor Cunningham; Steve Howard; Kun Cheng; James Podgorski; Jimmy May; Joseph Sack; Welly Lee; Neeraj Joshi; Keith Bauer Introduction We recently assisted a global ISV to address a performance issue related to a poor performing recursive...
  • Blog Post: Comparing Different Results with RCSI & Read Committed

    Author: Kun Cheng Reviewers: Sunil Agarwal, Steve Howard, Shaun Tinline-Jones, Prem Mehra, Sanjay Mishra, Michael Thomassy, Mike Ruthruff, Howard Yin, Jimmy May During a recent ISV partner engagement, we decided to enable RCSI (Read Committed Snapshot Isolation) on a SQL Server 2008 R2 instance with...
  • Blog Post: Watch out those prepared SQL statements

    Author: Kun Cheng Reviewers: Sunil Agarwal, Chuck Heinzelman, Shaun Tinline-Jones, Prem Mehra Although not documented very well, the system stored procedures listed below are known to many SQL Server developers and DBAs. For more details, please check out http://msdn.microsoft.com/en-us/library/ms176007...
  • Blog Post: Character data type conversion when using SQL Server JDBC drivers

    Author: Kun Cheng Reviewers: Wanda He, Kevin Cox, Michael Thomassy, Peter Scharlock In a recent customer engagement, I ran into an interesting situation, which I’d like to share, especially with SQL Server users using Microsoft JDBC drivers. It started with typical SQL Server performance tuning exercise...
  • Blog Post: Enabling Partition Level Locking in SQL Server 2008

    Author: Thomas Kejser Reviewers: Juergen Thomas, Sanjay Mishra, Stuart Ozer, Lubor Kollar, Kevin Cox, Kun Cheng In this blog, we will provide additional details on a well-hidden feature in SQL Server 2008 – partition-level locking. But before we illustrate the feature, here’s a bit of background about...
  • Blog Post: Whitepaper About Star Join Optimizations

    When we talk to Data Warehouse customers – they often raise questions about the star joins improvements SQL Server 2008. Star join is a set of optimizations that provide some interesting performance gains in data warehouse workload. Instead of digging into details here on SQL CAT we want to draw your...
Page 1 of 1 (11 items)