Thanks for the reply.

The table definition is big and thus I did not post it here.

The column1 is varchar(100) NULL.

I meant that the second query results in records where column1...

Thanks Keith. I shall have a look at the article. I am new to DBA side, so it helps a lot.

Thank you very much Chris.

May I also know, if there is any other way to get the space back, without restarting the service ?

Thank you very much Keith.

Thanks Chris.

I agree with Steve. Performance is definitely good with CTE's.

Check/Create indexes, that should help.

EDIT:

Also don't use Table variable if you have to process so many rows. That might be the...

Getdate() can't be passed as parameter

You may pass it as below

DECLARE @Date datetime

SET @Date = getdate()

exec YourSp @Date

Interesting answers by Lynn , Drew and Steve.

Its nice to know of that solution. May I ask for some links/resources to learn XML ?

Thanks WayneS!

Shawn, This might sound silly. how do you paste the code like that, as in I see a separate box there 🙂 ?

This should be faster. Do Test if the joins are fine.

SELECT TOP 100 *

FROM dbsrvr2.queues.dbo.OUTqueue2 a (NOLOCK)

WHERE result = 206

AND a.routing like '%1'

INNER JOIN defineroutings d

ON d.routing...

DECLARE @test-2 TABLE

(ID INT,

NAM VARCHAR(50))

DECLARE @RESULT TABLE

(ID INT,

RESULT VARCHAR(50))

INSERT INTO @test-2

SELECT 1,'RAM'

UNION ALL

SELECT 1,'PRASAD'

UNION ALL

SELECT 2,'SQL'

UNION ALL

SELECT 2,'SERVER'

UNION ALL

SELECT 2,'CENTRAL'

UNION ALL

SELECT 3,'FAMOUS'

UNION ALL

SELECT 3,'BOOK'

DECLARE @Id...

Thank you 🙂

Thanks Gail.

May I ask another question, based on your answer.

When we use 'SELECT *' in our query, then this is helpful. Say that I specify columnNames in my query...

Thanks for the reply.

I guess, I did not follow your answer.

I just created view on one server from a table on other server and it gets updated.