I recently come across the situation where my query was running very slow. I written a perfect query with good inner join and with proper condition. Have a look at query and its executing plan. As you can see in the image query takes 1.28 minute to execute successfully. And as you can see in [...]
Archive for the ‘SQL Server’ Category
How to Improve slow running query performance using an Index ?
Posted in SQL Server, tagged Performance Optimization, SQL server Index on June 24, 2009 | Leave a Comment »
SQL server 2005 – Database Publishing Wizard
Posted in SQL Server on June 1, 2009 | Leave a Comment »
The topic is self explanatory . What would you do if you want to generate script that contains data and schema too. To generate script with schema is pretty simple but what about data. Microsoft Database Publishing Wizard is the tool that work with SQL server 2005 to generate that kind of script. Below are [...]
Query Performance Optimization
Posted in SQL Server, tagged database, Indexes, Joins, Query Optimization, sql, sql query optimization, t-sql query on April 30, 2009 | Leave a Comment »
We all know how to create database, how to create tables etc… But do we know how to improve query performance when your database growing. Imaging the situation when your table will have more than a million rows. Just think what will be the query output time?? I personally working on the application where there [...]
