How large on these tables? How many rows exist and how many pages in the index?

Or, possibly create a view as:

CREATE VIEW dbo.vEmailList AS

SELECT TOP(10000)

column1

,column2

...

FYI - changing/setting the option for sqlservercentral.com to display pages in Compatibility Mode fixes this little problem 🙂

Sorry for coming across as harsh - but, it is better that you learn how to avoid this now than to be bitten later. Especially in this situation where...

Barry, if you check Narayana Vyas Kondreddi website (http://vyaskn.tripod.com you'll see that is the exact reason this was created.

john (10/23/2008)

---

Thanks Gila that was exactly the issue. I hate it when it is something like that.

To the other point. Yes I understand injection but this...

So, why don't you use SQLCMD instead? That is the new command line tool for SQL Server 2005.

BTW - errors like that would also show up in SSMS if...

What kind of errors are you getting?

Take a look at the DMV's:

sys.dm_db_index_operational_stats

sys.dm_db_index_usage_stats

You should be able to get the information you want by looking at only the heaps and clustered indexes. That is, indexes with an...

Lookup CASE in Books Online. You need to replace the IIF with CASE - but, that should be the only change.

Well, sure - that is why I originally asked how many rows you had in your Tally table. However, even if you limit your Tally table to 11,000 rows...

Not really - it is actually simpler than that. The where clause has to be evaluated for every row in the set. Since your table has 1,000,000 rows...

You cannot connect to SQL Server 2005 Reporting Services from the 2008 client tools. You need to use the 2005 client tools.

Remember how queries work:

First, process the joins. In this case there are no joins - so we need to work on the full set of data which is 1,000,000...

How many rows do you have in your Tally table? I run this fine with 11000 rows.