Forum Replies Created

Viewing 15 posts - 526 through 540 (of 1,034 total)

  • RE: SQL Server Agent job information

    does this depend on NUMA or whether or not my boot sector is on ISCSI or RAID3892?

    thanks for an easy one... at least this morning I didn't have to try...

  • RE: Precedence

    martin catherall (7/24/2011)


    I got the question correct, but I answered it on the basis that the two where clauses were different.

    Where ID = 20 OR modelID = 20 ---...

  • RE: PBM Alert

    Richard Warr (7/22/2011)


    No, not everybody 🙂

    But, if you've been following the discussions on some recent questions you'll note that some people take the prospect of a point very seriously.

    I...

  • RE: Login Properties

    JestersGrind (7/21/2011)


    I tried it on several of our servers, both 2005 and 2008, and received '1900-01-01 00:00:00.000'. All of these were enterprise edition. I also tried it on...

  • RE: Login Properties

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


    paul s-306273 (7/21/2011)


    I'm surprised that the answer isn't null.

    Can somebody prove or disprove that.

    (I don't have the facility to do this myself - sorry!)

    I'll add to this. I...

  • RE: Naming Conventions

    Jeff Moden (7/18/2011)


    It's just me, I know, but I name my tables after what a single row of any given table contains. Part of the...

  • RE: SQL Server Browser

    jeff.mason (7/12/2011)


    Again, I ask you -- if you were to change the browser to another port, or to "IP_ANY" (if that were possible which it isn't), where would you do...

  • RE: SQL Server Browser

    SanDroid (7/12/2011)


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

  • RE: SQL Server Browser

    jeff.mason (7/12/2011)


    mtassin (7/12/2011)


    Trey Staker (7/12/2011)


    Thanks for the question. I learned a lot not only from the question but especially from the discussion. I did't know what IP_ANY was.

    I'm...

  • RE: SQL Server Browser

    Trey Staker (7/12/2011)


    Thanks for the question. I learned a lot not only from the question but especially from the discussion. I did't know what IP_ANY was.

    I'm beginning to...

  • RE: SQL Server Browser

    mtassin (7/12/2011)


    Gianluca Sartori (7/12/2011)


    I don't give a damn about the points, I just want to make sure I understand things correctly. 🙂

    I have to agree. IP_ANY is a flag...

  • RE: SQL Server Browser

    Gianluca Sartori (7/12/2011)


    I don't give a damn about the points, I just want to make sure I understand things correctly. 🙂

    I have to agree. IP_ANY is a flag that...

  • RE: partion of RAM between SQL server and Cluster server

    niravbhat (7/7/2011)


    server have 75 GB and we have add 28 GB more to Cluster server.

    Each cluster node has 75 GB of Ram?

    What are you dedicating the remaining 47 GB...

  • RE: The RECOMPILE Options

    Marry Krissmess (7/7/2011)


    anil_kumar32 (7/7/2011)


    [font="Times New Roman"]

    Good things that comes with SP are security, less network traffic and SQL injection aviodance.

    [/font]

    Attention with security. Sometimes SPs execute with admin permissions even...

  • RE: Passed My Exam

    Congrats!

    How difficult did it seem to you? My biggest concern having never sat a cert test is a self-criticism that tells me I don't know enough.... so I sit...

Viewing 15 posts - 526 through 540 (of 1,034 total)