Souvik

It looks as if the backoffice database is taking about 6 minutes to start.  Perhaps there are a lot of transactions to roll forwards and back in that database.  Does...

Michelle

I'm sure Rudy will chip in with his performance tuning shortlist (if he doesn't then search for it on this site) but in the meantime, how often do you update...

Vladimir

Without knowing more about your application, it's impossible for me to offer any specific advice.  For example, I can't think of any reason why you would want users to be...

Darren

That's because you haven't addressed the original problem of needing dynamic SQL or a table-value function.  Although I suggested a way of doing the former, it doesn't scale up very...

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