I'm something of an amateur when it comes to table indexing and tuning and was hoping everyone could recommend some quick-read resources that I can better my knowledge and understanding. I know there are books that cover these topics but I really need some quick solutions and need to better understand these things as quickly as possible. Thanks!
- James
Indexes and tuning resources
Hot Topic
- AdventureWorks db for 101 Samples
- error applying initial snapshot
- Unable to use SSMSE to connect to SQL Express server on secondary IP address
- Keyboard not working (backspace and arrow keys) when viewing 2000 DTS packages from 2005 (backward compatibility)
- Management Studio Express CTP update now available
- Sql Reporting Services
- P2P Replication Conflicts
- unable to send mails through sql server2000
- Less data is coming to PDF when i am exporting reporting services 2005 report to PDF format
- How to check if row exists...
SQL Server
- SQL Server Mobile with Visual Studio 2003
- SQL Mobile Get Started Tutorial
- Update errors on a SmallDateTime field
- SSIS
- Insufficient Log Data
- Parallel activations with GET CONV GROUP
- Product Level is insufficient for component "xxx"
- Installation of SQL server 2005 Developer Edition Sep CTP
- Multiple threads
- Help! Printing Error from client (browser)
Indexes and tuning resources
Sandeepn75
Your best bets are
Books Online (either intalled locally or online at http://msdn2.microsoft.com/en-us/library/ms313868.aspx).
SQL TechNet center at (there are whitepapers and webcasts)
http://www.microsoft.com/technet/prodtechnol/sql/default.mspx
and other resources such as (look for learning links, they may cross-ref the above info)
http://www.microsoft.com/sql/default.mspx
Regards,
Boris.