Forum Replies Created

Viewing 15 posts - 91 through 105 (of 109 total)

  • RE: SQL Trigger

    In addition to Lowell's solution above, the other options include:

    --creating a CLR UDF to dump files (fastest solution)

    --creating an audit table to store the changes and then using SSIS task...

  • RE: Enhancing the readability of your code: Table aliasing in sql

    Readability cannot ever be the concern because each has a different level of comprehension. If uppercase or lowercase throws one off, then the level of comprehension is probably not the...

  • RE: Where and Join On Clause the Same?

    An explanation of why the order of evaluation, "from" followed by "where" has this effect is in order here. Merely stating that the order of evaluation as the reason misses...

  • RE: Letting People Go Securely

    This issue is so focussed on one side, the leaving employee, that we seem to forget the complete equation. The single most important factor on whether employees will play nice...

  • RE: Chargeback

    On the whole any kind of charge back system is detrimental to the organization in general and IT in particular. It will not work as a sustained activity. It may...

  • RE: The Value of Your Time

    I once found out such reviews were not for the "approval" per se, but the CEO wanted to know where everyone's going. It was his way of keeping track of...

  • RE: Organizational tools that can help you be a better DBA

    Not to forget delicious, which is browser, os, and whatever agnostic. I can lookup via iPhone or an equivalent PDA. Firefox-based tools are good, but not depending on Firefox is...

  • RE: Global Warming and Business Intelligence

    "Computers help us get more work done, but they also allow us to make mistakes very, very fast."

    That line reminds me of a button I used to have outside my...

  • RE: Conservative or Risky?

    Was there ever a "long-term, perpetual entity"? On the other hand every major profitable idea came about by taking risks. What may appear as a risky move may in fact...

  • RE: Industry Experience... Required?

    Steve Jones - Editor (1/4/2009)


    Tweaking code and working with tables is a lot of what we do. We develop new code at times, which may be more or less than...

  • RE: Industry Experience... Required?

    Industry experience is not about data, tables, functions, and procedures in that industry. It's the set of practices, methods, standards, innovations, etc., that databases serve. Often the question is about...

  • RE: No Non-Competes

    cweedtwo (9/18/2008)


    What intellectual property you process is the only way most of use earn a living - don't sign your rights away

    This should be first/last word on this topic!

  • RE: No Non-Competes

    Instead of exclusion clauses, I'd rather insist on what's "compete" and "disclosure". Let the company define each: let them put names of competitors, companies, places, programs, etc. Review it annually...

  • RE: No Non-Competes

    From a purely capitalist perspective, non-competes are anachronistic. They have no business in business. If everyone who works for a company thinks that they have the secret to the coke...

  • RE: Temporary Tables

    CTE's are very useful, but temp tables have their uses. Speaking from experience, after switching a CTE to temp table in one procedure, the execution time dropped from 40 minutes...

Viewing 15 posts - 91 through 105 (of 109 total)