Very nice presentation indeed :w00t:

Hey...

varchar(max) is only available as from SQL2005 !

However, you can concatenate variables to execute with exec.

Here's a little example:.

EXEC (@SQLQry + @SQLQryp1 + @SQLQryp2 + @SQLQryp3 + @SQLQrypx)

Indeed, service broker is a bit hard to monitor and to figure out what's going on.

You really need to play with it, to get the grips.

Here's an overview of my...

Just another flash in the brain ..... or what's left of it;)

When you switched the NICs, did you rename the NIC ?

We tend to use "public network connection" for our...

Forget about AWE for x64 ! Thats what it's all about with 64-bit.

You don't need that unless you go over the standard 64-bit addressing window.

However, you need to set your...

Oh indeed... I did forget to mention that !

- sqlinjection risk

- if the formula contains an error .... try to figure it out.

Be aware it may start with numeric info...

Programming basics : copy/paste 😀

DBA basics: script programming :hehe:

In fact, Jacks solution is better, except for the isnull testing.

There it depends if your columns are allowed to contain nulls or not.

And you should still perform :

if @@ROWCOUNT =...

you should directly move the data into your varriables:

ALTER PROCEDURE [dbo].[getSchedule]

-- Input

@facility char(2),

...

did you try this ?

Declare @weight as char(25)

Declare @output as numeric(18,2)

SET @weight = '2*5+2*5*4'

declare @TheSQL nvarchar(1000)

Set @TheSQL = 'Select @theoutput = ' + @weight

--OutPut should be 50.

exec sp_executesql @stmt =...

or

do the proprietary update:

UPDATE a

SET AccountStatus = 'Enabled'

FROM User a

INNER JOIN sheet1$ b

ON a.emailaddress = b.Emailaddress

We enable deadlock detection at all our instances using:

startup parameters -T1204 and -T3605

so it gets recorded in the sqlserver errorlog file.

/* to start deadlock detection and recording without stop/start...

I would perform a checkdb on that db, just to be sure that is OK.

If it is ok, the cause will be your backup drive

Thanks for this valuable feedback. (with kb refs) :smooooth:

If you still have the occasion ... apply the latest tested cumulative update .

Did you find a reason for your clusterdb to...

If you want a user only to be used from a certain address, you should first create your UserId_to_IPAddress table and then use a logon trigger (you need at least...