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 |
|
PTW
Starting Member
1 Post |
 Posted - 2012-02-09 : 06:34:05
|
| Hi,I'm new to SQL so forgive me if this is a no brainer.I have SQL view -If I execute it by right clicking it in the object explore and selecting the top 1000 rows. The view executes fine (after approximately 1 minute results are returned). However, if I open it in design view and then execute this using the ! from the tool bar the query will time out 30 s later. I have checked tools > options and the SQL time out is set to zero (no time out)Why is sql being executed differently ?Many thanks in advancePhil |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-09 : 13:38:12
|
| Because you're pulling a ton of data, and burning system resources.What are you trying to do anyway? Not often you need to manually review ALL of the records.Try filtering the data with a WHERE clause.Make sure the underlying tables are indexed on the join columns, and on the likely filter predicates (columns used in where clause). |
 |
|
|
|
|
|
A view excuted when open design times out