No announcements
Found 28682 threads
-
1 Voteswhat index scan and seek - table scan and seek
Index seek is always preferred.Answered | 4 Replies | 9635 Views | Created by yangamuniprasad - Thursday, July 5, 2012 4:25 AM | Last reply by Sunil Kumar Gupta - Sunday, October 28, 2012 4:51 PM
-
3 Votes
Predicate and Seek Predicate
Hi, this info is helpful :-) May I know if Predicate and Seek Predicate in the same execution plan ?Answered | 3 Replies | 27835 Views | Created by Madhavan Amarnath - Wednesday, April 3, 2013 6:10 AM | Last reply by Simly - Thursday, September 5, 2013 9:55 AM -
0 Votes
Index Seek
It has to evaluate the cost of seeking to those pages or scanning those pages.Answered | 19 Replies | 2826 Views | Created by kali786 - Friday, June 8, 2012 2:48 PM | Last reply by Adam Haines - Friday, June 8, 2012 5:18 PM -
0 Votes
Different between Predicate and Seek Predicate under the same Index Seek (nonclustered)
A Seek Predicate is where SQL looks up a value that it can find in an index.Answered | 2 Replies | 1566 Views | Created by Simly - Thursday, September 5, 2013 11:05 AM | Last reply by Kevin Urquhart - Friday, September 6, 2013 8:13 AM -
0 Votes
Problem with seeking in source transform
Source can seeking at Pause or Starting(Running) state but not in Stopped state!!!!Answered | 4 Replies | 5501 Views | Created by FedorkS [Elecard] - Thursday, May 21, 2009 11:38 AM | Last reply by Shoot [ Elecard ] - Tuesday, June 9, 2009 12:10 PM -
1 Votes
Seeking with a custom IMFByteStream implementation.
IMFByteStream::SetCurrentPosition or seek may be invoked between BeginRead and EndRead, seems that you can just refuse the seek operation and return failure during the Begin/End ...Answered | 3 Replies | 7516 Views | Created by Steve_1 - Wednesday, August 25, 2010 10:38 AM | Last reply by gremount - Tuesday, June 21, 2011 1:51 AM -
3 Votes
Seek, Scan, Lookup & Update
Hi, Its the same...but for best performance we look for Index seek and tune are queries to use seek only....So to see which are unused index or rarely used index ...Answered | 1 Replies | 3038 Views | Created by Kalyan Chakravarthi (MCP) - Wednesday, September 5, 2012 12:18 PM | Last reply by Ashish_DbaSQL - Wednesday, September 5, 2012 12:33 PM -
1 Votes
Quickly seek record
Hi all, How can we Quickly seek record in table or dataset in VB like seek Command In Vfp like set order to ...Answered | 3 Replies | 997 Views | Created by jasvee - Saturday, September 17, 2016 4:48 AM | Last reply by Reed Kimble - Saturday, September 17, 2016 2:21 PM -
0 Votes
Seek
Pls see the following ...Answered | 6 Replies | 5638 Views | Created by Ashru - Wednesday, April 21, 2010 9:20 AM | Last reply by Brad_Schulz - Wednesday, April 21, 2010 4:02 PM -
0 Votes
Index Scan or Index seek
For example if you have a relatively small table with a few entries, an index scan could cost less than an index seek depending on HOW the query was written which starts us on the query ...Answered | 2 Replies | 5395 Views | Created by Zainu - Thursday, November 5, 2009 7:45 AM | Last reply by Arif Hasan - Thursday, November 5, 2009 12:25 PM -
0 Votes
64 Bit Seeking?
>I am making a general IO handler for files and devices, but I will be >using them on things greater than 4 GB's (0x00000001 00000000) and >IOStream's ...Answered | 2 Replies | 4157 Views | Created by Dalavin, Skepherd of Furries - Sunday, July 11, 2010 9:56 AM | Last reply by Tim Roberts - Tuesday, July 13, 2010 5:37 AM -
0 Votes
IImagingFactory::CreateImageFromStream seek problem
However all decoders I tried call the Seek function of the stream.Answered | 1 Replies | 3635 Views | Created by georgo - Thursday, July 16, 2009 10:34 AM | Last reply by JenniFer Light - Monday, July 20, 2009 3:32 AM -
1 Votes
index scan to seek
[EmailAddress] like N'%67@adventure-works.com')) |--Clustered Index Seek(OBJECT:([AdventureWorks].Answered | 11 Replies | 7181 Views | Created by psingla - Wednesday, May 4, 2011 7:27 PM | Last reply by Kent Waldrop - Thursday, May 5, 2011 5:47 PM -
1 Votes
error cannot seek file
On PC 2 all the ntime I read an error: CANNOT SEEK FILE I try to use the same WMV videos from the same external HD IOMEGA 500 Gb...Answered | 4 Replies | 9119 Views | Created by A confused user named michal - Thursday, May 22, 2008 8:10 PM | Last reply by -niX- - Thursday, September 16, 2010 10:09 AM -
0 Votes
seek(0,0)
The frmStr.Seek(0,0) sets the write head to the begining of the document, but if what i am writing is a smaller document than the original, the result is that the XML is not well formed.Answered | 2 Replies | 7705 Views | Created by Lou8566 - Tuesday, September 11, 2007 4:46 PM | Last reply by Lou8566 - Wednesday, September 12, 2007 9:27 PM -
0 Votes
seek bar
Hi, I know there is already a similar topic but I can't figure it out, I need to make seek bar for my media player (using slider).Answered | 5 Replies | 3100 Views | Created by alenn - Wednesday, September 28, 2011 4:26 PM | Last reply by Sheldon _Xiao - Tuesday, October 11, 2011 8:16 AM -
0 Votes
Goal Seek multiple rows
Hi everyone, I need to make a vba macro that does a goal seek function over rows in which the goal value is found in cell M1.Answered | 1 Replies | 6925 Views | Created by eureka18 - Wednesday, December 15, 2010 11:00 AM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Wednesday, December 15, 2010 10:45 PM -
0 Votes
Goal Seek in Access
I'm trying to write a code in visual basic to perform the Excel version of Goal Seek in Access, but I'm having trouble.Answered | 2 Replies | 4325 Views | Created by FinancialAnalyst17 - Tuesday, October 25, 2011 9:56 PM | Last reply by FinancialAnalyst17 - Friday, December 9, 2011 5:37 PM -
0 Votes
Index scan vs index seek
After changing the alternate_id column from varchar to nvarchar the index seek occuring for procedure executions.Answered | 23 Replies | 7691 Views | Created by surendrakavali - Thursday, March 14, 2013 7:18 AM | Last reply by Jackson_1990 - Saturday, October 19, 2013 4:57 AM -
1 Votes
Is index seek always better than index scan
An index seek is where SQL server uses the b-tree structure of the index to seek directly to matching records.Answered | 5 Replies | 8302 Views | Created by Catherine0824 - Wednesday, May 9, 2012 7:10 AM | Last reply by Maggie Luo - Thursday, May 10, 2012 4:42 AM - Items 1 to 20 of 28682 Next ›
No announcements
