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 |
|
sinjin67
Yak Posting Veteran
53 Posts |
 Posted - 2008-09-04 : 18:39:33
|
| Greetings,I have been reading that if you setup an Index on yourtable and use a "Contains" function in your .net codethat it will not use the Index at all. Can anyone tellme if this is true..also if anyone can tell me is their a formula to applyor use when figuring out how much memory a SQL servermight need to run at best performence. In my caseI have 1 table with about 550,000 records and thatcould grow to a million in a short time. I am looking to upgrade my server and any input wouldbe great. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-04 : 18:56:42
|
| There is no specific formula as you said. If it is high OLTP and growing huge you could have Enterprise Edition. You can enjoy Table partitioning with it. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-09-05 : 01:56:14
|
| Initiall focus on creating the most suitable indexes and writing the most efficient queriesJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
Indexing and memory