SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint

Posted by pinaldave on SQL Authority See other posts from SQL Authority or by pinaldave
Published on Thu, 11 Mar 2010 01:30:40 +0000 Indexed on 2010/03/12 1:37 UTC
Read the original article Hit count: 883

Filed under:

Pinal Dave

|

Readers Question

|

sql

|

SQL Authority

|

SQL Index

|

SQL Optimization

|

SQL Performance

|

SQL Query

|

SQL Scripts

|

SQL Server

|

SQL Tips and Tricks

|

T SQL

|

Technology

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 [...]

© SQL Authority or respective owner

Related posts about Pinal Dave

SQLAuthority News – Pinal Dave: Blogger, MVP and now Interviewee by Michael J Swart

as seen on SQL Authority - Search for 'SQL Authority'
Michael J. Swart is a very unique person. I have often exchanged emails with him and also used a couple of his scripts in my presentations (with his permission). Every time I conduct spatial database presentation, I always start with his script where he has drawn the wonderful image of Botticelli’s… >>> More
SQLAuthority News – Uncut and Unedited Video Interview of Pinal Dave

as seen on SQL Authority - Search for 'SQL Authority'
Earlier this year Lohith (@kashyapa) from Bangalore took my ‘Uncut and Unedited’ video interview. It was really fun to answer his questions as it was very different from regular interview. He asked few personal details few technical details and made me show few secrets. I think if you… >>> More
There seems to be some 'lingering' SSH connections on my server. How do I fix it?

as seen on Server Fault - Search for 'Server Fault'
[root@server mike]# w 14:43:35 up 83 days, 1:25, 1 user, load average: 0.00, 0.00, 0.00 USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT mike pts/1 dsl-IP.w 14:43 0.00s 0.01s 0.03s sshd: mike [priv] [root@server mike]# ps aux | grep ssh root 1350 0.0 0.1… >>> More
SQLAuthority News – DotNET Challenge of Sorting Generic List

as seen on SQL Authority - Search for 'SQL Authority'
This is a quick announcement of .NET challenge posted by Nupur Dave. She has asked very interesting question. If you are interested in learning .NET and winning iPAD by Red-Gate. I strongly suggest that all of you should attempt the quiz. Here is the question: How to insert an item in sorted generic… >>> More
SQLAuthority News – SQL Server Technology Evangelists and Evangelism

as seen on SQL Authority - Search for 'SQL Authority'
This is the exact conversation that I had with three people during the recent SQL Server Public Training. Person 1: “Are you an SQL Server Evangelist?” Pinal : “No, but Vinod Kumar is.” Person 1: “Who are you?” Person 2: “He is Pinal, haha!” Person 1: “I… >>> More

Related posts about Readers Question

Ask the Readers: Share Your Tips for Defeating Viruses and Malware

as seen on How to geek - Search for 'How to geek'
We’ve shared some of our best tips for dealing with malware over the years, and now it’s your turn! Share your favorite tips for protecting against, or getting rid of viruses and other types of malicious software. Unfortunately, if you’re a PC user it’s a given that you have to play defense against… >>> More
test questiontest question test question test question? [closed]

as seen on Stack Overflow - Search for 'Stack Overflow'
TestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestionTestQuestio… >>> More
PHP Browser Game Question - Pretty General Language Suitability and Approach Question

as seen on Game Development - Search for 'Game Development'
I'm developing a browser game, using PHP, but I'm unsure if the way I'm going about doing it is to be encouraged anymore. It's basically one of those MMOs where you level up various buildings and what have you, but, you then commit some abstract fighting entity that the game gives you, to an automated… >>> More
Testing on Device Other Than the Known Brand Question (Local and Imported Phone Question)

as seen on Game Development - Search for 'Game Development'
I have a question. When testing a device by using Eclipse, it's easy to install and add device software with these specific brands commonly used in game testing like Samsung, Google, T-Mobile, and HTC; according to the Android Developers website. What if I'm using other brands that runs on Android… >>> More
question about prime question

as seen on Stack Overflow - Search for 'Stack Overflow'
i know that there are many binary operations to show that something is true for example we can show if number is power of two or something else is there some theory or special binary method to show if number is prime? thanks >>> More