Forum Replies Created

Viewing 15 posts - 241 through 255 (of 316 total)

  • RE: Transactions

    Thank you for the great question.

    September 25, 2012 at 6:47 am

    #1541831

  • RE: Extended Events I

    Great question. Way to start Monday off right.

    September 24, 2012 at 6:08 am

    #1541358

  • RE: Administration

    Thanks for the great question.

    September 11, 2012 at 6:20 am

    #1536185

  • RE: T-SQL

    Thanks for the easy question on Monday to build up my confidence this morning. 🙂

    September 10, 2012 at 7:44 am

    #1535689

  • RE: GO Part 1

    jeff.mason (9/7/2012)

    What's really bad is understanding the question correctly and screwing up the loop counts because it is early in the morning. I counted the 5 loops but forgot...

    September 7, 2012 at 6:57 am

    #1535035

  • RE: APPLY - 1

    Thank you for the excellent question this morning Ron. I had to dig around in my head this morning for a while to figure it out, but caffeine makes it...

    September 6, 2012 at 6:44 am

    #1534433

  • RE: Table Variable

    Thank you for the terrific question. I must say it almost bit me this morning until I took a second look. Zombie mode almost had me this morning, but then...

    September 4, 2012 at 6:38 am

    #1533238

  • RE: Table Variable

    sknox (8/31/2012)

    Agreed. Also, if you haven't voted on the Connect submission for this issue, please consider doing so:

    https://connect.microsoft.com/SQLServer/feedback/details/757012/set-identity-insert-on-table-variables

    You got my vote!

    This was a great easy question for Friday and leading...

    August 31, 2012 at 7:13 am

    #1532372

  • RE: Index types 2

    Thomas Abraham (8/30/2012)

    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.

    For...

    August 30, 2012 at 6:48 am

    #1531843

  • RE: ISDATE

    Thomas Abraham (8/28/2012)

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

    August 28, 2012 at 6:51 am

    #1530767

  • RE: nt given output server2000

    You're only selecting INTO a #temp table. To get results back you're going to have to select from that #temp table.

    August 23, 2012 at 7:21 am

    #1529233

  • RE: Inserts

    It's too early to be thinking about 1's and 0's. :pinch: Thanks for the great question, but I guess it would help if I read the question all the way...

    August 23, 2012 at 7:09 am

    #1529226

  • RE: Check status of SPN?

    Thomas Abraham (8/22/2012)

    (Bob Brown) (8/22/2012)

    Not familiar with SPN but the question got me to look it up. Thanks.

    That's probably the best benefit of QotD. You get people posting...

    August 22, 2012 at 7:18 am

    #1528614

  • RE: Basic of T-SQL

    Rich Weissler (8/20/2012)

    Now, had there been an option of "Table A will return 10 rows and Table B will return 7 rows" ... that could have been interesting.

    I'll agree with...

    August 20, 2012 at 6:39 am

    #1527557

  • RE: Table Variable

    Thomas Abraham (8/16/2012)

    Nice question. Thanks for the contribution. Never thought of truncating a temp table. But, it reminded me about limitations of this feature.

    + 1

    August 16, 2012 at 7:18 am

    #1526556

Viewing 15 posts - 241 through 255 (of 316 total)