Forum Replies Created

Viewing 15 posts - 286 through 300 (of 584 total)

  • RE: Tablesample

    Thanks for an interesting question. However, this may be the first time I'm satisfied with having got a wrong answer. I had the same issues with the question as did...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    September 19, 2012 at 7:30 am

    #1539550

  • RE: FILTER

    ronmoses (9/18/2012)

    I'm confused. The result I'm getting is 8, and I'd be curious to know why.

    Unless I'm missing something, it's because you repeated the SELECT 1,'AB' three times.

    (Edited to...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    September 18, 2012 at 6:18 am

    #1539050

  • RE: FILTER

    Hugo Kornelis (9/18/2012)

    ... This may all be due to my English reading skills (I'm not a native English speaker), but in any case, I wanted to add a comment to...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    September 18, 2012 at 6:13 am

    #1539044

  • RE: Backups

    palotaiarpad (9/17/2012)

    I guessed and won. I thought, SQL Server stores the compression flag in the header and not at the data part of the backup. And as the header remains,...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    September 17, 2012 at 7:00 am

    #1538576

  • RE: DBA Basics

    Naseer, thanks for contributing the question.

    Anyone know why the SMS Take Offline command runs so slowly?

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    September 14, 2012 at 7:49 am

    #1537830

  • RE: GO Part 2

    Thanks for the question. I got it right, but did so with a semi-educated guess. I reasoned that, if the answer was FALSE, this is a useless question of a...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    September 13, 2012 at 4:58 am

    #1537129

  • RE: Administration

    SQL Kiwi (9/11/2012)

    The question didn't mention trace flag 610 (which would enable minimal-logging in this scenario) so I assumed it was off, and was rewarded with a green tick and...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    September 11, 2012 at 5:42 am

    #1536174

  • RE: GO Part 1

    Thanks for the question. Went for six, as I focused on the iterations, without thinking about the select returning the just inserted rows. But, as others have said, this was...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    September 7, 2012 at 9:20 am

    #1535129

  • RE: APPLY - 1

    Thanks for the great question Ron. Eagerly anticipating the follow on questions.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    September 6, 2012 at 7:58 am

    #1534481

  • RE: Labor Day 2012

    sknox (9/3/2012)

    GRRR! ANOTHER answer without a Books Online reference! How are we supposed to verify this against the official Microsoft documentation!!!?

    😀

    Think of it as an undocumented "feature". I needed the...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    September 3, 2012 at 2:43 pm

    #1533062

  • RE: Table Variable

    bitbucket-25253 (8/31/2012)

    Rather suprised at the number of incorrect answers. Would have thought that the percent correct would be closer to 100

    You overestimate how awake some of us are in...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    August 31, 2012 at 5:43 am

    #1532322

  • RE: Table Variable

    Andrew Watson-478275 (8/31/2012)

    A better supporting document/respected DBA is this blog posting by Steve Jones

    http://www.sqlservercentral.com/blogs/steve_jones/2012/08/03/identity-insert-and-table-variables-connect-issue/

    It may just be an astounding coincidence, but the layout of Steve's example and the one...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    August 31, 2012 at 5:39 am

    #1532315

  • RE: Index types 2

    Thanks for the question Hugo. I should have stretched out before running that hard early in the morning. I think I strained something! 🙂 I certainly learned something.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    August 30, 2012 at 5:53 am

    #1531808

  • RE: Using Sparse Columns with SELECT ... INTO

    Thanks for the question Wayne! I don't use XML in my current work, so I had to do a bit of guessing. Went with what seemed reasonable and got it...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    August 29, 2012 at 5:16 am

    #1531310

  • RE: ISDATE

    bitbucket-25253 (8/28/2012)

    Hugo Kornelis (8/28/2012)

    I've raised a documentation bug for this issue: https://connect.microsoft.com/SQLServer/feedback/details/759944/documentation-of-isdate-function-incorrect

    Hugo thanks - went and voted as a bug that I could reproduce, now I wish all would do...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    August 28, 2012 at 5:54 am

    #1530729

Viewing 15 posts - 286 through 300 (of 584 total)