Forum Replies Created

Viewing 15 posts - 5,656 through 5,670 (of 6,104 total)

  • RE: how can I trace...

    quote:


    Also keep in mind that stored procedures may require you giving at minimum read rights to the base tables.


    K. Brian Kelley
    @kbriankelley

  • RE: Make sure your Host backs up SQL!!!

    We can look at the banking industry for a precedent. If you choose to put your money in a non-FDIC insured bank, and they are robbed, oh well. ...

    K. Brian Kelley
    @kbriankelley

  • RE: .NET , Revolution or Assault?

    There are companies running significant applications built on the .NET Framework and have been so for a while. So it's already in the real world. The .NET Framework...

    K. Brian Kelley
    @kbriankelley

  • RE: Reducing Round Trips - Part 2

    I'm all for keeping the middle tier stateless because of what we're seeing in a current application (in-house built). It means that clients have to pointed at a single...

    K. Brian Kelley
    @kbriankelley

  • RE: Case in Where clause

    Deuce, your comments match up with what Paul has said earlier. And for ad-hoc queries, SQL Server 7 and 2000 will generate an execute plan, which means it'll see...

    K. Brian Kelley
    @kbriankelley

  • RE: how can I trace...

    LogExplorer will do that.

    Triggers with audit tables work, but can produce a lot of overhead, but sometimes, though, they are the only way to go. Robert Marda...

    K. Brian Kelley
    @kbriankelley

  • RE: Why did you decide to become a DBA/SQL Programmer?

    Correct. If you are a career changer or a kid with a fresh haircut straight out of college, there isn't an entry level slot. Which is why most...

    K. Brian Kelley
    @kbriankelley

  • RE: Make sure your Host backs up SQL!!!

    Bottom line, get it in writing. It's not a question of if, it is a question of when. And when it does happen, without anything in writing, you...

    K. Brian Kelley
    @kbriankelley

  • RE: SQL "Worst Practice SA password"

    Nimda was a pain, but it shouldn't have been as big a problem as it turned out to be. In almost every case if a server had been properly...

    K. Brian Kelley
    @kbriankelley

  • RE: .NET , Revolution or Assault?

    I think what we were referring to was the comment about Microsoft being "given" .NET.

    What you are describing is the main issue with Java. Sun has pulled...

    K. Brian Kelley
    @kbriankelley

  • RE: AWE Memory and SQL Server 2000 Enterprise

    If you have the four instances, you could still have them stepping all over each other. For instance, a query run in development pegs out the processors in the...

    K. Brian Kelley
    @kbriankelley

  • RE: How have you improved the SQL Servers at your work

    Crystal Reports is a reporting tool that creates nice reports for management and non-technical types. Giving them a point and click interface, they build reports on data without knowing...

    K. Brian Kelley
    @kbriankelley

  • RE: Dynamic SQL and Temp table creation

    Are you running this through Query Analyzer or some other client (say a VB program)?

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • RE: Are things THAT different than MS Access?

    Visio is one of those designers you either love or love to hate. Most of the folks I work with fall into the latter. Rational Rose will also...

    K. Brian Kelley
    @kbriankelley

  • RE: Exam 70-228

    Are you looking for test simulation software or are you looking for an actual platform in which to play with queries and the like? I'm assuming the former. ...

    K. Brian Kelley
    @kbriankelley

  • Viewing 15 posts - 5,656 through 5,670 (of 6,104 total)