Forum Replies Created

Viewing 15 posts - 211 through 225 (of 673 total)

  • RE: That case filter

    Ninja's_RGR'us (7/20/2011)

    SanDroid (7/20/2011)

    Richard Warr (7/20/2011)

    I think all the people who cheated by running the code first and still managed to get the question wrong, and then complain about it, may...

    July 20, 2011 at 8:03 am

    #1355629

  • RE: That case filter

    Richard Warr (7/20/2011)

    I think all the people who cheated by running the code first and still managed to get the question wrong, and then complain about it, may be taking...

    July 20, 2011 at 7:41 am

    #1355597

  • RE: That case filter

    Spotted the Extra Union All a mile away.

    Got the answer right, but never read the question title.

    Had I read the question title I would been like the 50% of those...

    July 20, 2011 at 7:15 am

    #1355575

  • RE: Buffer Manager

    Iulian -207023 (7/19/2011)

    Thank you for the question

    It says on msdn link:

    "You can query the bpool_commit_target and bpool_committed columns in the sys.dm_os_sys_info catalog view to return the number of pages reserved...

    July 19, 2011 at 11:55 am

    #1355071

  • RE: Restoring Features

    Ninja's_RGR'us (7/14/2011)

    SanDroid (7/14/2011)

    Got it wrong because my experiance and M$ docs aparently do not match with that of the rest of the world. 😛 Maybe I should start...

    July 14, 2011 at 1:32 pm

    #1353072

  • RE: Restoring Features

    Got it wrong because my experiance and M$ docs aparently do not match with that of the rest of the world. 😛 Maybe I should start including MS...

    July 14, 2011 at 12:45 pm

    #1353045

  • RE: Second Normal Form

    Tom.Thomson (7/14/2011)

    Lempster (7/14/2011)

    I must admit that I got a bit lost by the description in your first paragraph, but the example that you gave made it clear and confirmed to...

    July 14, 2011 at 12:26 pm

    #1353034

  • RE: DRI or No DRI?

    We call them Relational Database Management Systems for a reason.

    I have yet to see the M$ SQL environment where related Tables joined faster with no defined PK/FK relationships. 😛

    Why do...

    July 14, 2011 at 8:26 am

    #1352853

  • RE: SQL Server Browser

    Boris G (7/12/2011)

    Well as much as i don't want to believe i just ran

    netstat on clustered SQL Server i see sqlbrowser.exe listening to *:*

    Borik

    Exactly... 😎

    July 12, 2011 at 10:44 am

    #1351765

  • RE: SQL Server Browser

    SanDroid (7/12/2011)

    Gianluca Sartori (7/12/2011)

    SanDroid (7/12/2011)

    So after all that research and posting and re-posting....

    What answer to the question about configuring SQL Browser Service on a cluster fits the best? 1433, 1434,...

    July 12, 2011 at 10:41 am

    #1351761

  • RE: SQL Server Browser

    Gianluca Sartori (7/12/2011)

    SanDroid (7/12/2011)

    So after all that research and posting and re-posting....

    What answer to the question about configuring SQL Browser Service on a cluster fits the best? 1433, 1434, or...

    July 12, 2011 at 10:25 am

    #1351751

  • RE: SQL Server Browser

    mtassin (7/12/2011)

    Don't tell me that Microsoft wrote a BOL page wrong? Oh dear... Oh dear...

    I can tell you that from reading that BOL page I'm more confused about TCP/IP...

    July 12, 2011 at 10:22 am

    #1351747

  • RE: SQL Server Browser

    jeff.mason (7/12/2011)

    ...A little later it says this:

    "SQL Server Browser is not a clustered resource and does not support failover from one cluster node to the other. Therefore, in the case...

    July 12, 2011 at 10:17 am

    #1351741

  • RE: SQL Server Browser

    jeff.mason (7/12/2011)

    The answer (assuming you mean the DB engine and not SSAS) is ALWAYS UDP 1434. It may listen on UDP 1434 of IP_ANY, but still UDP 1434.

    We are...

    July 12, 2011 at 10:06 am

    #1351725

  • RE: SQL Server Browser

    jeff.mason (7/12/2011)

    IP_ANY is JUST an address!

    IP_ANY just tells the system to use all IP addresses. It specifies nothing about the port.

    As was already pointed out today...

    July 12, 2011 at 9:56 am

    #1351714

Viewing 15 posts - 211 through 225 (of 673 total)