well is there any benefit in performance in doing that or it is not necessary?

also, i thought that when you rebuild an index in a table you are supposed...

Okay lets get formal here

ALTER TABLE dbo.candreg

ADD CONSTRAINT DF_candreg_totalexp DEFAULT 0 FOR totalexp

Forgot to put not null

alter table candreg

alter column totalexp int default 0 not null

alter table candreg

alter column totalexp int default 0

hi i have a question, i just got told by the senior DBA that to consider that query i have to put at least the page count > 50 is...

Try doing the concatenation before the execution.

DECLARE @vcText int,

@db varchar(50),

@FilePath VARCHAR(500)

SET @db='msdb'

SET @FilePath = '\\ctsqladp01\Backup$\InstA\'+@db+'.lsb'

EXEC @vcText = master..xp_restore_verifyonly @filename = @FilePath

It starts from 1900 and moves forward. The result from below is 0. Anything below '1900-01-1 00:00:00.000' returns a negative number.

declare @dt datetime

set @dt = '1900-01-1 00:00:00.000'

select ...

Maybe this example will help clarify. You will note the date portion is always to the left of the period. The hours/min/sec etc are on the right. ...

Well #77 beat me too it 😛

datetime fields are stored as float values. You can verify this by converting a datetime to a float, as shown below.

declare @dt datetime

set @dt = '2008-02-28 00:00:00.000'

select cast (@dt...

Nice. I like this one because you are not using while loops :D.

I agree with Matt. It sounds like you need to put the CTE (and any other peices of code you want to call) into stored procedures. You can...

You have to end the case statement.

(CASE WHEN @vcText = '0' THEN @vcText ELSE SUBSTRING(@vcText, 5, CHARINDEX(',', @vcText, 1) - 5) end)

Well you are always going to recieve the print and the error messages because you are running the entire process as one batch. Try putting a Go after your...

Adam Haines (2/26/2008)

--------------------------------------------------------------------------------

Thanks for pointing that out. It makes sense as the clustered index actually affects the sorting of the data.

In this case, the sorting of the data is...