Viewing 15 posts - 6,391 through 6,405 (of 7,484 total)
Jamie Longstreet-481950 (9/26/2008)
December 18, 2010 at 10:44 am
I learnt zilch from the explanation; the BoL article referenced doesn't seem to contain any statement supporting the answer it is supposed to support, which is irritating. The discussion...
December 18, 2010 at 9:50 am
Brandie Tarvin (12/17/2010)
Tom.Thomson (12/16/2010)
December 17, 2010 at 8:03 am
Paul White NZ (12/16/2010)
http://www.sqlmag.com/article/sql-server/quaere-verum-clustered-index-scans-part-i.aspxhttp://www.sqlmag.com/article/sql-server/quaere-verum-clustered-index-scans-part-ii.aspx
http://www.sqlmag.com/article/sql-server/quaere-verum-clustered-index-scans-part-iii.aspx
http://sqlblog.com/blogs/paul_white/archive/2010/09/23/a-tale-of-two-index-hints.aspx
That's a wonderful set of stuff. Thanks, Paul.
December 17, 2010 at 6:55 am
Paul White NZ (12/16/2010)
Ok. It was impractical to do. Better?
yes, that's it exactly.
December 17, 2010 at 5:50 am
Paul White NZ (12/15/2010)
December 16, 2010 at 7:16 pm
I saw this after Steve had modified it. I was very confused by the "correct anser" answer, since I thought the option immediately before it was the correct answer....
December 16, 2010 at 6:53 pm
Thanks for teh question. It made me look in BoL, which some say is cheating (and I say is learning).
December 16, 2010 at 6:45 pm
Nils Gustav Stråbø (12/9/2010)
It teaches me nothing about Sql Server or T-SQL (except debugging peculiar T-SQL), and to...
December 16, 2010 at 6:37 pm
Brandie Tarvin (12/15/2010)
Has anyone...
December 16, 2010 at 5:19 pm
WayneS (12/15/2010)
December 16, 2010 at 4:37 pm
Jeff Moden (12/15/2010)
Now.. comparing the two pieces of code above, which will be cheaper CPU wise? A floating point mulitply AND divide or a simple addition?
It's not often I...
December 16, 2010 at 4:24 pm
Viewing 15 posts - 6,391 through 6,405 (of 7,484 total)