Forum Replies Created

Viewing 15 posts - 256 through 270 (of 552 total)

  • RE: Memory-Optimized Table Filegroups

    Good one, Steve, thank you for the post.

    (initially.. all he choices were seems to right, after reading each one very very carefully.. was able to select the correct one)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 27, 2014 at 3:17 am

    #1716627

  • RE: Get User In Reporting Services

    Stewart "Arturius" Campbell (5/26/2014)

    ...as I could not get it working using T-SQL.

    .. you mean, the auto insert?

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 26, 2014 at 11:29 am

    #1716515

  • RE: Get User In Reporting Services

    Good one, Andy, thank you for the post.

    I got tricked by first two options, and I did not select the first one and selected the other feasible two. Even though...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 26, 2014 at 2:47 am

    #1716455

  • RE: Temp table limitations

    SQLRNNR (5/23/2014)

    I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

    Temp tables can be partitioned....

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 23, 2014 at 11:20 am

    #1716190

  • RE: Temp table limitations

    Thank you for post, SJ, simply nice.

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 23, 2014 at 2:42 am

    #1715986

  • RE: Log Files

    Thank you the post, SJ, simple one and nice.... but I did get it wrong.

    I opened the LFV and saw these (with sub selection under each, except agent) "SQL Server",...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 22, 2014 at 3:38 am

    #1715610

  • RE: Heaps rebuild

    Thank for the post, very interesting one.

    (Out of 4, I got 2 correct, but learnt a lot today) 🙂

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 21, 2014 at 5:26 am

    #1715282

  • RE: Running Out Of Foreign Keys

    Hugo Kornelis (5/20/2014)

    I decided to run a quick experiment to see if I could find any limits. Here is the code I used to create a table with lots of...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 21, 2014 at 3:24 am

    #1715256

  • RE: Running Out Of Foreign Keys

    TomThomson (5/20/2014)

    Good shooting, Hugo1 🙂 I was too lazy to experiment :blush:, so I'm glad to see your results.

    edit: "Hugo1"! My left little finger has failed me...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 21, 2014 at 3:21 am

    #1715254

  • RE: Running Out Of Foreign Keys

    Thank you for the post, Andy, interesting one.

    "If 249 and 999 sound familiar those have been the limits on the number of indexes, not foreign keys making those answers incorrect,"......

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 20, 2014 at 3:14 am

    #1714832

  • RE: Server Settings

    Thank you for the post, free_mascot, good one.

    Actually in real I have no idea how this works, probably wouldn't get a chance to see it... but on the bright side...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 19, 2014 at 3:55 am

    #1714550

  • RE: Upgrading cardinality

    Thank you for the post, SJ, interesting one.

    Learnt something new, and then learnt what I learnt is not correct and then I learnt the correct way. Also voted on the...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 15, 2014 at 12:03 pm

    #1713971

  • RE: Drop Me? No, I Don't Think So

    Awesome, this was really cool post. I narrowed down to 2 and 6, and then was thinking if the db was offline then how server will access it... then with...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 14, 2014 at 1:01 pm

    #1713584

  • RE: Filetable paths

    Thank you for the post, ST, very very interesting one.

    (As I am using this feature for the first time, I just created a FT and was looking in to the...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 13, 2014 at 3:57 am

    #1712953

  • RE: Datatypes In Your Mind

    Andy Warren (5/12/2014)

    Stephen, writing the QOTD is a lot of fun. Not easy, but fun. I've got a bunch of posts on the lessons learned/tried so far at http://sqlandy.com/tag/question-of-the-day/ that...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

    May 12, 2014 at 11:21 am

    #1712801

Viewing 15 posts - 256 through 270 (of 552 total)