Viewing 15 posts - 19,006 through 19,020 (of 26,484 total)
Your right, the disk access alone won't answer that entirely, but it is a significant part of the difference. The other part is the time it takes to deliver...
August 26, 2009 at 3:37 pm
First run of the query had to actually access the data from disk. The second time the data has been cached.
August 26, 2009 at 2:42 pm
Depends on how you purchased your SQL Server 2005 licenses. I'd check with your vendor.
August 26, 2009 at 2:38 pm
Alvin Ramard (8/26/2009)
What's worse than OP too lazy to search how to do something simple and asking in the thread?OP that send you a PM asking the question.
Nevermind, I found...
August 26, 2009 at 11:56 am
GSquared (8/26/2009)
Alvin Ramard (8/26/2009)
What's worse than OP too lazy to search how to do something simple and asking in the thread?OP that send you a PM asking the question.
I get...
August 26, 2009 at 11:52 am
Alvin Ramard (8/26/2009)
What's worse than OP too lazy to search how to do something simple and asking in the thread?OP that send you a PM asking the question.
So, what was...
August 26, 2009 at 11:49 am
rambilla4 (8/25/2009)
Please see my post here http://www.sqlservercentral.com/Forums/Topic771695-146-1.aspx.
I'm also discussing the same from last 4 days and every body saying UTC time stamp is by design for log shipping .trn...
August 25, 2009 at 11:59 pm
Once you start using it for production purposes while the active databases are on the primary server, yes.
August 25, 2009 at 9:37 pm
Thing is, even an idiot deserves a chance to repent. I still have another cheek to turn, and perhaps he will make an effort next time. It is...
August 25, 2009 at 9:34 pm
cjohn5552 (8/25/2009)
Hahaha, that's funny. No wonder I was having trouble finding documentation for those "keywords". Sorry for the misunderstanding.
No problem, it's why we are here, to help clear up misunderstandings...
August 25, 2009 at 3:02 pm
I'll get back to you more this evening if I can. Have things I need to do right now. If not tonight, definately tomorrow evening.
August 25, 2009 at 2:00 pm
sjsubscribe (8/25/2009)
August 25, 2009 at 1:58 pm
SQLBOT (8/25/2009)
... and also an ability for the OP to mark the thread as answered. ...
This is the only part I don't agree with and I think there are many...
August 25, 2009 at 1:07 pm
Gus, are (did) you use CHECKSUM or BINARY_CHECKSUM? If I was going this direction, I would look at the later. Of course, I don't have the volume of...
August 25, 2009 at 12:30 pm
cjohn5552 (8/25/2009)
A colleague of mine showed me a query employing some methods of controlling query flow that I am not familiar with--in particular, the usage of...
August 25, 2009 at 12:03 pm
Viewing 15 posts - 19,006 through 19,020 (of 26,484 total)