Viewing 15 posts - 1,921 through 1,935 (of 18,926 total)
No because indexing 100K rows takes a whole lot of ressources.
Quite often the index is useless, because you scan the whole temp table when joining to something else, apart from...
October 18, 2011 at 7:50 pm
Actually the first test would be to see if removing it helps.
Step 2 would be to see where and how that table is used.
Most of the time when you use...
October 18, 2011 at 5:33 pm
express 2k8 R2 has a 1 cpu, 1 gb ram & 10 GB per db limit (no user limit)
Free and should be enough to get off the ground.
October 18, 2011 at 4:54 pm
SQLRNNR (10/18/2011)
Sean Lange (10/18/2011)
Oh look at the pants, time to go home.All pants are off!!
Stop it with the 5 fingers discount & my pants!
October 18, 2011 at 4:22 pm
Sean Lange (10/18/2011)
Ninja's_RGR'us (10/18/2011)
@steve-2, looks like we figured out how to get your 300 hits in your pants daily, just as you requested from us 😀
Now that is some pantastic...
October 18, 2011 at 4:02 pm
....Filling in the pants to get it up to a nice round number.
October 18, 2011 at 4:01 pm
@steve-2, looks like we figured out how to get your 300 hits in your pants daily, just as you requested from us 😀
October 18, 2011 at 3:58 pm
GilaMonster (10/18/2011)
sdownen05 (10/18/2011)
October 18, 2011 at 11:01 am
SQLRNNR (10/18/2011)
Ninja's_RGR'us (10/18/2011)
Ninja's_RGR'us (10/18/2011)
SQLRNNR (10/18/2011)
Grant Fritchey (10/18/2011)
Pants? Aren't pants optional these days? They were last week. Now I'm working from home...BRAIN BLEACH
Oh Crap, me too now :sick:.
That did it! (rated...
October 18, 2011 at 10:47 am
This is a duplicate thread.
Resolution available here : http://www.sqlservercentral.com/Forums/Topic1191993-359-1.aspx#bm1192187
October 18, 2011 at 10:45 am
Ninja's_RGR'us (10/18/2011)
SQLRNNR (10/18/2011)
Grant Fritchey (10/18/2011)
Pants? Aren't pants optional these days? They were last week. Now I'm working from home...BRAIN BLEACH
Oh Crap, me too now :sick:.
That did it! (rated G)... as...
October 18, 2011 at 10:39 am
SQLRNNR (10/18/2011)
Grant Fritchey (10/18/2011)
Pants? Aren't pants optional these days? They were last week. Now I'm working from home...BRAIN BLEACH
Oh Crap, me too now :sick:.
October 18, 2011 at 10:31 am
So you want to delete duplicates or something similar?
October 18, 2011 at 10:09 am
Assuming SQL 2K.
INDEXPROPERTY has pretty much all the info you want but I don't have a fully build script for ya.
Gail wants to know if you mistakenly posted in the...
October 18, 2011 at 10:03 am
Viewing 15 posts - 1,921 through 1,935 (of 18,926 total)