Search Results

Thread by: tran008, Aug 12, 2009, 6 replies, in forum: T-SQL Performance Tuning for Developers

Currently I have the index on the id for the following select statment: SELECT id , (CASE WHEN XTYPE =...

Thread by: tran008, Jan 6, 2009, 2 replies, in forum: T-SQL Performance Tuning for Developers

Hi all, I have the code below, which used for stock analysis base on the first in first out. As you can see if need a lot of help....the currently...

Thread by: tran008, Jun 16, 2008, 3 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

I trying to filter over a million records that was import by the third party database. The reason for filtering is that the data contain too many...

Thread by: tran008, Dec 7, 2007, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi all, With the statement below, what will happen if more then 1 persons run at the same time? thanks DECLARE @TranStarted BIT IF(...