Yes, read the BOL article I referenced to set the query timeout to the required value for each of the linked servers.

Hi,

This isn't a procedure that's shipped with SQL server, it sounds like a bespoke one that your company has written (usp stands for User Stored Procedure) to do some monitoring....

Please see the below from BOL:

http://msdn.microsoft.com/en-us/library/ms178532.aspx

0 doesn't mean unlimited in the case of query timeout, it means that it's set to the same as the remote query timeout server option...

Ritesh Medhe (1/29/2010)

---

is there any sepcial kind of optimisation setting that needs to be done if SS2008 is running on AMD? I ran same SQL query on Intel and AMD...

I think the most likely cause is that you have a query timeout set on the linked server properties.

I believe the OP is saying that the databases are on SAN, not local disks.

Need some more information to answer the original question, but assuming you're using SQL 2008 Enterprise...

It's nothing to do with defaults. The variable is being set to 0.

The problem is that you're setting the variable to be itself + 1 in the same row as...

I would say the only way to absolutely guarantee data deletion would be very extreme.

E.g. do the delete, create a new database and set up SSIS packages to import all...

OK. Please note that I gave you an example of Dynamic SQL. SQL Injection is what you need to avoid - e.g. if people can enter free text into the...

You can call openquery dynamically, but as always you need to be careful about sql injection.

e.g.

DECLARE @sql VARCHAR(8000)

SET @sql='select master.dbo.fx_Traveltime(''''2023RS'''',''''1161AE'''',-120)'

SET @sql='SELECT * FROM OPENQUERY(linked_sql2005_servername,'''+@sql+''')'

EXEC(@sql)

Have you checked out things like this...

Calling it through OPENQUERY and passing the parameters inside the query text is about as efficiently as you'll be able to do it, but it's not massively efficient compared to...

I tend to use gvim for anything that won't open in notepad++. It's a gui version of a very popular linux editor that can run on Windows.

The syntax can be...

Prior to SQL 2008 ISNULL was considerably faster than COALESCE. This makes sense as the code behind ISNULL has to deal with a fixed number of input variables (2) and...

Ok, what's probably happening is that when you've got actual values in the IN, it's able to only bring back the rows that meet that criteria, but the optimiser is...

The system tables are very well tuned and SQL definitely can scale beyond 1 million tables. It will make using any gui tool that enumerates tables an ongoing nightmare, but...