Database and More

AVOID DYNAMIC QUERY IN SQL SERVER – IMPROVE PERFORMANCE

kkumar@iotap.com — Tue, 16 Feb 2010 13:18:00 GMT

This Blog will explain, how to avoid dynamic query to improve performance.

More...

Solution for SQL Server 2008 Express Microsoft SQL Server, Error: 18456 issue

kkumar@iotap.com — Tue, 19 May 2009 06:06:38 GMT

This blog explains the steps for fixing SQL Server 2008 Express Microsoft SQL Server, Error: 18456 issue

More...

Identifying queries running slower than normal

kkumar@iotap.com — Thu, 07 Aug 2008 07:17:00 GMT

A query can start to run slower for many reasons, including: an increased number of users (resulting in more waiting on resources), increased volume of data to process, too much context switching for parallel queries, and slower hardware. When a query is run, its query plan is cached to improve subsequent run of the query. Many interesting details relating to the query are recorded, these details can be accessed via SQL Server’s Dynamic Management Views (DMVs). In particular the DMV sys.dm_exec_query_stats contains performance statistics for cached query plans. This DMV has everything we need to determine if a query is running slower than normal.

More...