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 |
|
fasihakbar590
Starting Member
4 Posts |
 Posted - 2010-12-15 : 11:11:04
|
| Hi,Issue 1:-If I have 2 millions records in a database table in SQL Server and I want to search some specific record from that table.My question is that how I should go for search so that Server should not be hanged up. And performance wise what is the best way to search that record?Issue 2:-Can anyone please send me the Link of some article which will explain completely the "Clustered and Non-Clustered indexes". And how we can implement these two practically? It will be highly appreciated if that article explain with Snap Shots/Images.Thanks & Regards in advance,M.Fasihfasihakbar590 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
fasihakbar590
Starting Member
4 Posts |
Posted - 2010-12-15 : 11:40:52
|
quote:
Originally posted by russell
Proper indexes and SARGable queries are the answer to your first question.If you Google the term "Clustered Index" you'll get thousands of results.Have a look at these 2 articleshttp://www.sql-server-performance.com/articles/per/index_data_structures_p1.aspxhttp://www.sql-server-performance.com/tips/t_sql_where_p2.aspx
I could not found good article among Thousands of google results.So that's why asking for easy and more understandable article if someone knows about it.Thanks,Fasihfasihakbar590 |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-15 : 11:44:01
|
| Ok, please review the 2 I posted. Hope this helps. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
Two Issues Needs to be answered