Search Results | SQL Server Performance Forums

Defrag Non Clustered Indexes

Thread by: Arhamg, Mar 3, 2010, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi, How important it is to defrag Non Clustered indexes? Me and my colleague were discussing the defrag activity and I was of the opinion that we...

Update Statement using extra FK's

Thread by: Arhamg, Jul 2, 2009, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I have a simple update statement like Update tableName Set Col1 = val1, col2 = val2, col3 = val3 where TablePK = Val The table in question has...

Performance improvement by Left Join

Thread by: Arhamg, Feb 21, 2009, 1 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, I have a select statement in which I use table variable(with a PK) inner Join a table inner join a materialized view inner join a table left...

Debug CLR-User Defined DataType

Thread by: Arhamg, Dec 9, 2008, 0 replies, in forum: SQL Server 2005 CLR

Hi, Can you please tell me if there's a way to debug a user defined data type code (.vb or .cs). I have gone through this MS post...

Performance of CROSS APPLY

Thread by: Arhamg, Jul 31, 2008, 3 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, i have a query like Select Col1 , col2 , dbo.func1(col3), dbo.func2(col4) from table1 t1 inner join table2 t2 on t1.col = t2.col I'm plannig to...

varchar(max) and FTS

Thread by: Arhamg, Jun 17, 2008, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I have a made a full text index on column in a table having only 2 cols in all(one phrase(varchar(4000)) and second Id). Now i want to change...

How to optimize a trigger

Thread by: Arhamg, Jun 10, 2008, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I have a table with 35 columns and i have to maintain an audit trail of a couple of columns out of those.so i made a AFTER UPDATE,INSERT trigger...

Unexpected behavior of @var is null

Thread by: Arhamg, May 21, 2008, 11 replies, in forum: SQL Server 2005 General Developer Questions

hi, i have a procedure with a query havin 3 inner joins in which i have used the syntax table1 tbl1 inner join table2 tbl2 on tbl1.col1 = tbl2.col1...