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 |
|
nobby
Yak Posting Veteran
58 Posts |
 Posted - 2008-01-30 : 18:39:20
|
| Hi fairly new to sql but getting the hang of it but now i have started to work with some large qty of data i keep gettingqueries timing out.i have a large table of data millions of records can't check how many because every time i open the few that gives me the total records it times out the same with another view that gives me the max date both these views work on identical smaller samples of data.Is there a setting i can increase or is there some size limits i have exceededAny help much appreciatedHope i have explained this in enough detailNigel |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-31 : 23:53:46
|
| Are you accesing them for some application? or directly firing queries in SSMS/QA? |
 |
|
|
nobby
Yak Posting Veteran
58 Posts |
Posted - 2008-02-01 : 01:14:56
|
| Directly using SQL Server Management Studio Express |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-02 : 00:00:39
|
| Don't open table that way, you can check row count in properties page or run t-sql in query window. |
|
|
|
|
|
|
Sql express server 2005 timeout