When setting up a customer's site that requires external terminal server access with a minimum of fuss, we have their simple ADSL/Cable router+firewall forward 3390 externally to 3389 internally.  The...

When the problem occurs, could you run a profiler trace and turn on LOTS of stuff (eg, catching exceptions, outputting all sql statements executed within SPs, etc - both start...

I only asked Remi cause I reckon I could bet the farm (if I owned one!) that Remi would be the one to answer the question after I posted it.....

183 columns is HUGE!   I hope you aren't selecting them all with select * all of the time - best to partition it and...

This site

format the date using the convert command...

EG

declare @x datetime

set @x = getDate()

convert(varchar(50), @x, 120) 

120 = ODBC,  121 = ODBC + milliseconds,  126 = ISO (used in XML)

The date would need to...

SQL should be able to cope with the volume of data you stored in FoxPro, although you might consider partitioning some of those wide tables and joining on them when...

Thanks 4 the advice... Wasn't aware of that attaching trick - shall keep it in mind for future.

A cause is always lovely to find, but the fix is the one...

Good article!

We are thinking that at some stage we would let people sync data from our doc management system (normally hosted on...

How else could SQL "sniff" the parameters?  It would need something to work with as a basis for forming the query plan.  I haven't...

Look at

http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx

Or try to add a WITH RECOMPILE to your stored proc (not sure if you can add it to your UDF - I suppose you can) so that...

And as Remi suggested, created a computed column to store the 6 rightmost characters.  Consider what you would do if faced with the same situation using a phonebook's index.  If...

Or use unicode columns - the nchar, nvarchar and ntext datatypes rather then char, varchar and text...  They should accept anything!

I had trouble like that once...  Had no idea how to fix it - I dropped clustered indices, recreated them, etc, etc - ran repairs which never fixed the problem...

For your first problem, take the 10 queries, put them into a query analyser window one by one and run them, but make sure you goto Query->Show Execution Plan.

Then look...