Vladimir

If SQL Server is locking the whole table, it is because it judges that it is more efficient to do so than to issue multiple row or page locks, for...

Darren

You need to use dynamic SQL for the last bit.  Something like this (not tested):

DECLARE  @sql

SET  @sql = 'SELECT * FROM table WHERE country IN (' + ISNULL(@new_country, @country) + ')'

EXEC  @sql

Better still, look up the syntax of sp_executesql.

You...

Bart

Generally speaking, we reindex every week and update statistics once a day.  Reindexing automatically updates statistics, so there is little value in updating once a month the day after the...

Ravi

I don't know, but you may find the answer if you examine the code of the stored procedure sp_configure.

John

Assuming you want to replace every '&' with a '+':

UPDATE MyTable SET

  col1 = REPLACE(col1, '&', '+'),

  col2 = REPLACE(col2, '&', '+'),

  col3 = REPLACE(col3, '&', '+'),

  col4 = REPLACE(col4, '&', '+')

John

Mick

You don't say whether it's the same character that needs changing in all places, or if so whether all occurrences of that character should be changed.  However, a good place...

Chandu

It looks as if you're trying to overwrite a database on the destination server that has a different name from the database that was backed up.  Is that right?  I'm...

You will find the default value in the documentation.  If it's the same as for SQL Server 2000, it's 0.

John

I would be surprised if this is anything to do with the fact you a restoring from a clustered environment to a "normal" server.  But please will you provide more...

You should be able to use sp_configure:

sp_configure 'affinity mask'

I think you will need to insert the result set into a temporary table or table variable and select...

Mmmm.... I didn't find anything on that page about execution times.  But I like rstone's idea of SET STATISTICS TIME ON.

John

Joe

If I understand correctly, then each of the attributes will correspond to a column that the user can create dynamically.  If you have a finite list of these, why not...

Chris

Just to add to what Sameer said (apologies if I'm just repeating what's in the links he gave):

Don't shrink your database or log files if they're only going to grow...

For the most part, SQL Server doesn't really care that it's running on a cluster.  I've never tried to rebuild master on a cluster, but I don't imagine the procedure...

Claudia

Sorry, I don't know anything about dBase 5.  You'll probably have to write something in VB or ActiveX for your DTS package that generates the file name according to the...