Viewing 15 posts - 2,251 through 2,265 (of 3,347 total)
I knew I had a 50/50 chance of getting it wrong, because the documentation itself supports both answers.
The table at the top of the linked page says that full backup...
January 25, 2012 at 4:35 am
Revenant (1/20/2012)
I thought about this for a while, and I think it would make sense to redefine COUNT() as a function returning BIGINT. After all, there is an implicit...
January 21, 2012 at 3:18 am
L' Eomot Inversé (1/20/2012)
Hugo Kornelis (1/20/2012)
Just for kicks, I decided to do the math. (See "Estimating the size of a clustered index" in Books Online)
But why a clustered index? ...
January 21, 2012 at 3:15 am
paul.knibbs (1/20/2012)
Hugo Kornelis (1/20/2012)
(Though I don't understand why MS would choose to use a signed integer to store page numbers; it's not as...
January 20, 2012 at 6:03 am
Thomas Abraham (1/20/2012)
Hugo Kornelis (1/20/2012)
Just for kicks ......you would need to have almost 200 million of those machines.
You left out the most important part of the calculation, for the money...
January 20, 2012 at 5:58 am
paul.knibbs (1/20/2012)
Hugo Kornelis (1/20/2012)
January 20, 2012 at 4:51 am
paul.knibbs (1/20/2012)
Hugo Kornelis (1/20/2012)
with its current supported maximum database size of "only" 524,272 terabytes, it seriously falls short for this kind of challenge.
What actually imposes that limit? It seems a...
January 20, 2012 at 4:40 am
Hugo Kornelis (1/20/2012)
Richard Warr (1/20/2012)
January 20, 2012 at 4:10 am
Richard Warr (1/20/2012)
Or from http://msdn.microsoft.com/en-us/library/ms175997.aspx we see that COUNT() returns an Integer. What happens to SELECT COUNT(1) FROM myTable when myTable contains more rows than an integer can store?
You get...
January 20, 2012 at 3:17 am
Toreador (1/20/2012)
I hope those who answered 32767 were joking!
Maybe they were misreading "rows" for "columns"?
January 20, 2012 at 3:04 am
SQL Kiwi (1/17/2012)
Like this...? (the stupid trick here is to put double-quotes around the hex colour value *and* the leading # sign. Awesome.)
Thanks, Paul. I missed the double-quotes.
I have...
January 17, 2012 at 4:40 pm
A good question, and it's hard to see how anbody could contest the correct answer.
Although in the spirit of nitpicking, I could argue that the format one should use would...
January 17, 2012 at 7:00 am
Hi Paul and Sergiy,
Can you please drop this? You are now both reiterating the same point again and again.
Sergiy has made his point that he disagrees with the answer (and...
January 16, 2012 at 12:17 am
Sergiy (1/13/2012)
If to read "is executed" as "being processed" then table scans are executed at the same time as the stream aggregate. And the stream aggregate is...
January 13, 2012 at 2:25 am
Sergiy (1/12/2012)
JOIN is executed (eliminating the extra row) BEFORE aggregation even starts to evaluate any upcoming values.
Yes - before aggregation starts to evaluate any upcoming values. But after it starts...
January 13, 2012 at 12:54 am
Viewing 15 posts - 2,251 through 2,265 (of 3,347 total)