I have used it a couple of times for task that could be done using T-SQL. Its very slow.

Its more useful to write code which could be understood by...

Hi,

I have never new that there is so much about transactions. Its really a very good article.

Raj

Hi,

You got to create a function which returns a table.

CREATE FUNCTION test_function

 (@p1  int, @p2 char)

RETURNS @table_var TABLE

 (c1 int, c2 int)

AS

BEGIN

 INSERT into @table_var (c1 , c2)

 SELECT 1, 2

 RETURN

END

GO

Insert...

Why dont you try the option ALTER INDEX REORGANISE option to defragment the index.

Otherwise Upgrade the system configuration. If possible have a Dual processor and place the index on a...

Hi,

To My knowledge if ur code is fine just have a look at the query that you are executing, possible the query u r executing is taking lot of time...