I disagree with Chief78CJ7. Nulls are indexed.

You can prove this by creating a simple table, inserting say 1000 non-null rows and a single null row. Add an index and...

According to BOL (look under 'limitations-SQL Server objects'), the maximum no of parameters is 2100.

It doesn't specify whether there is a specific limit on input vs output parameters.

Not...

I think the answer to this is down to where the filtering of data is done.

The query using the where clause (your second example) is filtering the TblLog rows before...

During failure testing, we have seen databases left in 'suspect' mode quite frequently when SQL Server has been stopped in the middle of a transaction log restore.

In the majority of...

You will need to re-run the SQL Server setup program again.

Setup knows that the server software is already installed, so won't actually do a re-install (so you won't lose...

Just what I was after.

Thanks very much Allen.

Your variable @ExecSP must be defined as nvarchar. I suspect you are defining it as varchar

You won't necessarily see deadlocks as they would come back to the client with the dealock error, but have you tried running sp_who2 to see if there is any blocking....

I haven't had a chance to try this out, but changing the update statement to something like this should get the updates done in the correct order.:-

update tablename set colname=@ctr,@ctr=@ctr+1...

I totally agree with both Jeremy and David.

Cursors may not be liked by the 'purists', but they are part of the SQL language, so why shouldn't you use them. Especially...

This should do it:-

declare @ctr int

set @ctr = 0

update tablename set colname=@ctr,@ctr=@ctr+1

SELECT INTO is not logged (see BOL for details), and can be used to create and copy rows into the archive table.

You may also find it quicker to create a...

You will find specific instructions for doing this in the help that comes with SP3

I can't remember what the document is called, but if you unpack the service pack, I...

If you are doing an UPDATE tablename WHERE col=x ..., what may be happening is that SQL Server is reading all of the rows in the remote table over the...

You can set MAXDOP on a whole server basis from the Processor tab on the Server Properties dialog in Enterprise Manager.

But it kind of defeats the object of having multiple...