Viewing 15 posts - 1,411 through 1,425 (of 2,647 total)
TheSQLGuru (3/14/2012)
Gianluca Sartori (3/14/2012)
TheSQLGuru (3/14/2012)
March 14, 2012 at 1:22 pm
I would create a stored procedure and then create a job to run it on a schedule with SQL Server Agent.
March 14, 2012 at 12:13 pm
HowardW (3/13/2012)
A data reader just receives results in a pipe and can...
March 13, 2012 at 2:27 pm
Hmm... So not being an app developer I have a question. Can the developer use the returned results in say the first 10 rows of what will effectively be 1000...
March 13, 2012 at 2:01 pm
The solution is to wait. It is rolling back everything that was done and may take some time.
March 13, 2012 at 1:52 pm
I have yet to find a good post on a practical application of using the fast option. Trust me, I have dug hard. I have demonstrated a clear change...
March 13, 2012 at 1:32 pm
Lynn Pettis (3/13/2012)
SQLKnowItAll (3/13/2012)
mayur birari (3/13/2012)
Yes. it does have a foreign key in table B. I agree it may not be needed since it is also a clustered PK on...
March 13, 2012 at 11:39 am
Lynn Pettis (3/13/2012)
And it could potentially confuse others that may come to this thread.
I'm sorry, but I disagree. I think anyone coming to this thread will be wondering in what...
March 13, 2012 at 11:36 am
mayur birari (3/13/2012)
Yes. it does have a foreign key in table B. I agree it may not be needed since it is also a clustered PK on the same table.
@Lynn...
March 13, 2012 at 11:28 am
Lynn Pettis (3/13/2012)
SQLKnowItAll (3/13/2012)
March 13, 2012 at 11:23 am
Well, I'd like to turn the topic to why this would be used. Would I do a top 100 with a FAST 100? It seems needless to want...
March 13, 2012 at 11:10 am
Eugene Elutin (3/13/2012)
SQLKnowItAll (3/13/2012)
March 13, 2012 at 11:04 am
Ok, let's settle this. Its not about returning found rows faster or immediately. Its about FINDING the n rows faster (possibly), which as a direct result will return...
March 13, 2012 at 10:50 am
Eugene Elutin (3/13/2012)
SQLKnowItAll (3/13/2012)
Is there a non-clustered index on Table B for personid?It's defined as PRIMARY KEY CLUSTERED in the OP posted DDL...
I see that the OP did that,...
March 13, 2012 at 10:13 am
Is there a non-clustered index on Table B for personid?
March 13, 2012 at 10:05 am
Viewing 15 posts - 1,411 through 1,425 (of 2,647 total)