MSSMS Unable to create any indexes on a table with > 10 mil rows
-
I can't create any indexes from managment studio on tables with 10 > million records.
I get this nasty error:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
When i use the query window and use the create index statement it works fine.
Can someone help?
Alex S -
Check that you have set a execution timeout
Within Registered Servers
- Select Server
- Right click Properties
- Select 'Connection Properties' tab
-
I figured it out.
I was using modify table ---->(manage keys-indexes) window to create indexes instead of right clicking indexes under tables.
Thanks
Alex S -
Still... why should one timeout and not the other ?!?!?.
Thanx for letting us know about this.
-
I get the same timeout error when i try to open a view (right click -->open view) that returns over 5 mil records.
But after Adrians comment it's all good.
Thanks Adrian
Alex S -
Here's a good one :
1 - Why are you opening a view and select all of its records?
2 - I hope you're doing that on a developpement box?!?!
-
1. There are 20 mil records and i'm only showing 5 mil.
2. And there are 120 columns i'm only selecting 35.
Yes it's dev ...in live i'll have to show all 20 mil.
View will be used in a report
Alex S -
OHG, never seen a report like that! I hope you summarise the data; I wouldn't want to wait after the printer on that one
. -
Yeah the report is huge it contains Email Addresses and contest info from all of our websites.
Alex S -
Work for ebay or something??
-
nope just another media company
Alex S -
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply