Bear in mind that there have been changes to what's considered valid SQL in SQL 2005. If the app uses any of that it will break on SQL 2005.

Perhaps I...

riga1966 (4/27/2009)

---

If there is SQL Server timeout error will it be captured in SQL Server Log

or you need to configure SQL to start capturing this type of things?

How do I...

You can. I've done so on a number of occasions.

There are...

Any chance you can post the plans as .sqlplan files (zipped)? The xml should be the same across all languages so, if I load it into my management studio, I'll...

Did you look at the link that Grant gave?

There are a lot of...

Because a seek requires a predicate, something to seek on, and neither of your queries has...

Mike Baria (4/27/2009)

---

I wasn't really thinking that indexes would be useless because of the potential sproc recompile, but that the cost to the overall job might outweigh the gain to...

Is Vue still running the MS exams over in the US? I thought MS dropped them completely a couple years...

Since you know what tables and columns are involved, just do an explicit UPDATE STATISTICS for the tables and the stats that you want to update.

UPDATE STATISTICS <Table Name> <Statistics...

Mike Baria (4/27/2009)

---

First question (an easy one): Do existing sprocs get marked for recomiplation automatically after they have been ALTERED? It seems like they should, but I don't...

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic705198-150-1.aspx

Look up DBCC DBReindex in the SQL books online.

Please in the future don't use polls for simple questions.

Thanks

http://msdn.microsoft.com/en-us/library/ms182776(SQL.90).aspx

http://www.prometric.com

You should be able to search for exam centres and book online

Fixes in SP3 - http://support.microsoft.com/?kbid=955706

Fixes in SP2 - http://support.microsoft.com/?kbid=921896

Fixes in SP1 - http://support.microsoft.com/?kbid=913090