Search Results | SQL Server Performance Forums

performance tuning tools

Thread by: rohitkochar, Jun 17, 2007, 2 replies, in forum: T-SQL Performance Tuning for Developers

HI , please tell me some inbuilt tools to tune T-Sql in SqlServer-2005 apart from execution plan analsys?? Rohit Kochar MCP .Net(Web and SqlServer)...

best way to implement many to many relationship?

Thread by: rohitkochar, Jun 11, 2007, 4 replies, in forum: SQL Server 2005 General Developer Questions

HI , What is the best way to implement many to many relationhip in sql server?? Suppose i have two tables teachers and class . A class can have many...

sproc tuning..

Thread by: rohitkochar, Jun 6, 2007, 7 replies, in forum: T-SQL Performance Tuning for Developers

HI , I have tuned a sproc...initially it took 2 minutes ( 12381 rows ) to run but second time it took about 45 seconds ....and on production server...

SSIS issue...OLE DB Destination [21]] Error

Thread by: rohitkochar, Jun 5, 2007, 3 replies, in forum: SQL Server 2005 Integration Services

Hi , I have created a SSIS package while running it . I am getting errors while package execution is in progress : 1) [OLE DB Destination [21]]...

Export import script automatically

Thread by: rohitkochar, Jun 4, 2007, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hi , I am running export - Import wizard to transfer data from tables from one Dataabse to other Database on the same server . I want to generate...

Which query should run fast?

Thread by: rohitkochar, Jun 1, 2007, 5 replies, in forum: T-SQL Performance Tuning for Developers

HI all , I have three version of a query that returns the same result . Query used in , like and = operator for searching ... I ran the three query...

Concseptual questions...Plz explain

Thread by: rohitkochar, May 30, 2007, 16 replies, in forum: Getting Started

1) I am running query select * from <sometable>. Table has a clustered index and non clustered index. Will running above query result in table...