Forum Replies Created

Viewing 15 posts - 451 through 465 (of 533 total)

  • RE: Best config for 8 HDD

    How many IO channels do you have?

    What kind of database are you expecting to run (OLTP/OLAP/hybrid)?

    How many transactions per second?

    How critical is your data ... how many seconds/minutes/hours can you...

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SQL Server being hammered by failed login attempts

    hein-1120388 (4/21/2010)


    That may be true but you can still use IP blocking to kill a specific offender without killing your customers.

    The attacker's IP varies over time. I need less maintenance...

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SQL Server being hammered by failed login attempts

    You understand there are two methods to IP blocking?

    1. Block everything and only specifically allow access by specific IP addresses.

    2. Leave everything open by default. Take a look at...

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: define composite primary key with more than 900 bytes

    Andrew Watson-478275 (4/21/2010)


    At the risk of uttering a heresy, is SQL even the best place to do the comparison? Assuming the records are being keyed into some front-end system,...

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SQL Server being hammered by failed login attempts

    I'm not going to use the IP range blocking either, so I'm not sure what the firewall will offer.

    Now if you're saying that the firewall is not going to solve...

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SQL Server being hammered by failed login attempts

    If you have any servers open to the Internet be prepared to spend a lot of time and effort on security. If you don't know what to do (such...

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Each GROUP BY error message when there is no literal?

    I would highly suggest cleaning up your code. SQL doesn't care if you mash everything together, but for the sake of yourself and others it would be a great...

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Alternative to Cursor for Inserts

    This would be for all records in your hypothetical. You can obviously narrow down the action with your WHERE.

    insert into OrganisationAssignments (OrganisationID, Initials_Assigned, RoleID)

    select

    oNot.OrganisationID,

    oa.Initials_Assigned,

    oa.RoleID

    from OrganisationAssignments oa

    join OrganisationGroupLookup oYes--the current...

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: using try/Catch in SLQ SERVER 2008

    There may be a better way to do it, but I know you can set an output parameter and assign it the value of the error code (or 0 if...

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SQL Express 2008 Edition NEEDED!!

    What exactly are you trying to do? Install client tools to connect to a separate server?

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SQL Express 2008 Edition NEEDED!!

    http://www.microsoft.com/express/Database/%5B/url%5D

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Managing Permissions accessing Data

    john.acb (4/14/2010)


    Hello once again...

    Thanks again for your reply... I understand what your trying to say. The problem is, my system is gonna be "audited", therefore i'm gonna have SQL recording...

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Managing Permissions accessing Data

    john.acb (4/16/2010)


    Hiring a DBA is out of the question at my company! I'm the next best thing :p

    I understood what you said and that's the approach i was thinking of,...

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Talking baseball

    Michael Valentine Jones (4/16/2010)


    bteraberry (4/16/2010)


    Michael Valentine Jones (4/7/2010)


    And yes, get rid of the draft. If nothing else, just for pure fairness. How would your salary look if you...

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Talking baseball

    Michael Valentine Jones (4/16/2010)


    bteraberry (4/16/2010)


    Michael Valentine Jones (4/7/2010)


    In other words, I am suggesting that Baseball (and other sports) operate under the same market conditions that almost every other business operates...

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 451 through 465 (of 533 total)