An additional problem with table variables that I found in practice is that the query processor cannot make use of a parallel query plan with table variables. A procedure...

CHARINDEX() AND PATINDEX() are the SQL functions that you need to identify substring locations but this query is going to be slow. I would support strongly Sushila's suggestion to...

Obviously not the problem in your case, but remember that ADO has timeouts onits connection and command objects and SQL Server has a timeout on connections. Any one of...

From BOL :

GROUP BY Clause

Specifies the groups into which output rows are to be placed and, if aggregate functions are included in the SELECT clause , calculates a summary value...

There is no such thing as a FoxPro 2.x database - just a set of free tables. You will have to import each one individually using OpenQuery. The...

Do you just want to store the document or are you wanting to query on it. If just to store, you can put in a BLOB field (ntext or...

Thanks, good thinking. I share your reservations over performance but there's only one way to find out ...

I suspect that I am going to end up insisting on a...

I would want to know a lot more before even formulating a strategy. First of all, what is the query. A simple SELECT * FROM dbo.[ListOfUsers] is not...

My original design was a separate exe that could read the Excel with VBA, get a bit of extra data from SQL with ADO and an SP and generate a...

That's what I was trying to suggest. The probelm might be with the database but I expect that they wanted you to show that you could think beyond the...

In general terms :

Possible locking / contention issues.

Is there a limit on the number of connections and the last app is waiting silently for a free one?

Network performance? Are...

The Model database that is created automatically when you install SQL Server. Whenever you create a new database, it is created as a copy of the Model database including...

Model will work but setting permissions automatically strikes me as dangerous. Why not write a script which at least you have to conciously run each time?

Passing dates as strings assumes the dateformat on the target and this cannot be guaranteed unless, without fail, all your stored procedures include SET DATEFORMAT (which any of mine that...

See my post (No 9) on the first page of this thread.