I believe that when you return rows through EM, it begins return rows immediately, fetching more rows in the background.
Starting with the basics, can you issue a query in QA that returns just one or a few rows? How big is your table. In a C/S environment, you would rarely return all rows form a tx table.
Understand that when you return all rows, it is going to be a full table-scan. i.e., no optimization and no indexs (unless I suppose the fields you are returning are all found in an index).
FWIW, based on your facts, while there is likely a "problem", it does not rest with SQL Server.
>Hi Guys,
>
>I am having a very strange problem. When I run a query in enterprise manager(server machine,open table, return all rows, click on sql button and type the query there) it runs super fast. When i run the same query in the query analyzer on the server machine it hangs. This also happens If i run this query from a VFp Client or .net. it just hangs. can someone help me.
>
>The Sql server is running on Windows 2003, 1 gb mem, 300 gb hdd.
>The LDF file is 110 GB
>the MDF File is 17 GB. No backup of the transaction log has ever been run. The IT Manager only let me know this 1 day ago.
>
>TIA.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only