SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint
March 10, 2010 on 7:30 pm | In SQL Authority | No CommentsRecently I received the following two questions from readers and both the questions have very similar answers. Question 1: I have a unique requirement where I do not want to use any index of the table; how can I achieve this? Question 2: Currently my table uses clustered index and does seek operation; how can I convert seek to scan?
More here:
SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint
SQLAuthority Book Review – Professional SQL Server 2008 Internals and Troubleshooting
March 9, 2010 on 7:30 pm | In SQL Authority | No CommentsProfessional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven Wort Link to Amazon (Worldwide) Link to Flipkart (India) Brief Review: Having a book on internal and associating that with real life is “almost” an impossible task. The reason for using the word “almost” is because this book has accomplished this very well
Continued here:
SQLAuthority Book Review – Professional SQL Server 2008 Internals and Troubleshooting
SQL SERVER – Improve Performance by Reducing IO – Creating Covered Index
March 8, 2010 on 7:30 pm | In SQL Authority | No CommentsThis blog post is in the response of the T-SQL Tuesday #004: IO by Mike Walsh . The subject of this month is IO. Here is my quick blog post on how Cover Index can Improve Performance by Reducing IO.
Excerpt from:
SQL SERVER – Improve Performance by Reducing IO – Creating Covered Index
Powered by WordPress with Pool theme design by Borja Fernandez.
Entries and comments feeds.
Valid XHTML and CSS. ^Top^