Mine aren't as funny .

If you post the query and the execution plan we can give a hand... if he's too busy.

The benefit is only there if you have a where condition on it and that the range of values is good (didn't read the whole thread).

Just my 2...

Gives a chance to use an index seek too .

Maybe it would be possible to write the post to a cookie and redisplay it if the session has ended.

Gonna have to learn to type slower

follow up question :

Are you casting to int because you have values like '03'...

IF Object_id('ListTableColumns') > 0

DROP FUNCTION ListTableColumns

GO

CREATE FUNCTION dbo.ListTableColumns (@TableID as int)

RETURNS varchar(8000)

AS

BEGIN

Declare @Items as varchar(8000)

SET @Items = ''

SELECT

@Items = @Items + C.Name + ', '

FROMdbo.SysColumns C

WHEREC.id = @TableID

AND OBJECTPROPERTY(@TableID, 'IsTable')...

Can you do it that way?

Update tblIntelecDownload

Set CRSC_3_PLACE_NUM = 1

WHERE SCRCTG = '3'

The gist is I have a query that returns a rather large set of records (~ 4 million) on which I will perform aggregate functions and other statistical analyses later...

How can a real DBA assume that???????????

Maybe this can help :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=93685

Does it shrink down eventually?

What is the size after you back it up?

Here's a fun one :

--I use this table for many other string operations as well

CREATE TABLE [Numbers] (

[PkNumber] [int] IDENTITY (1, 1) NOT NULL ,

CONSTRAINT [Pk_Number] PRIMARY KEY ...

I C, good luck anyways.