Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2001-04-19 : 09:44:33
|
| Man. I am reverse engineering a program that we have here at work from a 3rd party vender. The problem is that the program is slow. Amoung several tables missing stats, I found that the query is using the FASTFIRSTROW hint. When you look in BOL it says not to use FASTFIRSTROW because it is there only for backward compatablity. BOL also says to use FAST N instead. I thought "OK, let me check my handy little microsoft book..." looked it up and to my suprise there was no reverence to FAST N, only a reference to FASTFIRSTROW?!? This is a Microsoft Press book... so which contains the blunder BOL or the Perf Tuning book?DanielSQL Server DBA |
|
|
|
|
|
SQL 7 Perf Tuning Tech Reference book