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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 27, 2011 at 7:13 am

    #1359211

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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 25, 2011 at 6:56 am

    #1357737

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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 22, 2011 at 7:05 am

    #1357025

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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 21, 2011 at 9:48 am

    #1356550

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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 21, 2011 at 9:18 am

    #1356502

  • RE: Naming Conventions

    Jeff Moden (7/18/2011)

    Mark-101232 (7/18/2011)

    Have a look here

    http://databases.aspfaq.com/database/what-naming-convention-should-i-use-in-my-database.html

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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 18, 2011 at 7:02 am

    #1354206

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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 12, 2011 at 10:30 am

    #1351756

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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 12, 2011 at 10:09 am

    #1351730

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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 12, 2011 at 10:07 am

    #1351728

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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 12, 2011 at 9:51 am

    #1351704

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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 12, 2011 at 7:25 am

    #1351561

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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 12, 2011 at 7:21 am

    #1351556

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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 7, 2011 at 12:48 pm

    #1349947

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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 7, 2011 at 8:09 am

    #1349731

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


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

    July 1, 2011 at 9:28 am

    #1347107

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