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 Comments

Recently 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 Comments

Professional 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 Comments

This 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

Next Page »

Powered by WordPress with Pool theme design by Borja Fernandez.
Entries and comments feeds. Valid XHTML and CSS. ^Top^