Got it wrong, but learned something - which is the key

Hugo,

The knowledge tested is good, but the way the question has been built suggests to me that the author tried...

Sorry Wayne,

On my system I get:

SELECT TOP (5) * FROM #Test WHERE RowID > 5000; - 5001

SELECT TOP (5) * FROM...

Did you use SS 2005 to create the publicatin and subscription? To go from 2K to 2K5, you must use the 2K5 SSMS to create everything.

Also, make sure that you...

Please provide the schema, all indexes and the select that is hanging.

I have databases with tables much greater than this and do not have issues.

Heres a link that might help you:

http://furrukhbaig.wordpress.com/2007/08/22/parameter-sniffing/

Good question - but, I think the answers and explanation are lacking.

The order of the clustered index is based upon the columns which make up the clustered index. (Change the...

Try here:

http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-2005-replication.aspx

Good Monday morning question - math test and logic while clearing the cobwebs and trying to get my first cup of coffee;-)

Made me think, question and reread.

Rahul The Dba

Welcome to the forum. Good question. Many will complain about simplicity or the number of times that this type of question has been asked, but it is...

Craig,

Excellent article. Can't wait to see the next one.

Redgate's SQL Backup does in fact encrypt with either 128 or 256 bit encryption, your choice, as well as multiple levels of compression for the database dump.

I went looking for your desk, thought that you were sitting next to me or at least close by:hehe:

I standardize on a minimum of 2 years...

Understood - now you can convert the extracted file by modifying the script to change the end of record. This has been a issue since files were being creaed on...

Convert the file before SSIS uses it.

Craig, This is a common issue when dealing with files from Unix/OS2 systems. The end of record mark for those systems is a LF and not CR/LF as a windows/DOS...