Forum Replies Created

Viewing 15 posts - 2,251 through 2,265 (of 3,348 total)

  • RE: Concurrent Administration

    Steve Jones - SSC Editor (1/25/2012)

    I didn't see the note about starting the shrink and changing the files.

    I'll update the question to clarify.

    <nitpick>

    I still disagree with the question and answer....

    January 25, 2012 at 9:15 am

    #1438275

  • RE: Concurrent Administration

    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

    #1438162

  • RE: billy-yons and billy-yons of rows

    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

    #1436793

  • RE: billy-yons and billy-yons of rows

    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

    #1436792

  • RE: billy-yons and billy-yons of rows

    paul.knibbs (1/20/2012)

    Hugo Kornelis (1/20/2012)

    Sounds plausible. Pages do have a page number.

    (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

    #1436417

  • RE: billy-yons and billy-yons of rows

    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

    #1436414

  • RE: billy-yons and billy-yons of rows

    paul.knibbs (1/20/2012)

    Hugo Kornelis (1/20/2012)

    I don't know the exact cause of the 16 TB limit for each file. Maybe it has to do with the structure of special pages that apply...

    January 20, 2012 at 4:51 am

    #1436372

  • RE: billy-yons and billy-yons of rows

    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

    #1436369

  • RE: billy-yons and billy-yons of rows

    Hugo Kornelis (1/20/2012)

    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...

    January 20, 2012 at 4:10 am

    #1436359

  • RE: billy-yons and billy-yons of rows

    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

    #1436342

  • RE: billy-yons and billy-yons of rows

    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

    #1436337

  • RE: Multiple Inserts

    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

    #1434919

  • RE: Multiple Inserts

    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

    #1434586

  • RE: Query Plan Execution Order

    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

    #1433907

  • RE: Query Plan Execution Order

    Sergiy (1/13/2012)

    So, here we go.

    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

    #1433084

Viewing 15 posts - 2,251 through 2,265 (of 3,348 total)