Forum Replies Created

Viewing 15 posts - 1 through 15 (of 23 total)

  • RE: How do I limit user access to certain time of day

    So if you use Net Nanny, and have a server job that adds pr0n at 8 am, then removes it at 5 pm .....

  • RE: Riddle me this....

    Actually, we figured out a way.

    The application holds the application role connection string with an encrypted password. The decryption key is placed in a table on it's own database...

  • RE: How do I limit user access to certain time of day

    I'm no network guy, but if you are running NT authentication for db access can't the users (user group) at the NT level be granted access to a particular server...

  • RE: Backing up database larger than 50GB

    It may be the IRPStackSize bug. You can google it, but essentially you need to alter/set a registry setting. The max value is 50, but I'm finding that...

  • RE: The IT Employee Benchmark

    It's why every IT department should have one or two openings permanently available in case someone that's really valuable comes along. Identifying that person can be hard, and to a...

  • RE: Riddle me this....

    Thanks, Steve. At least now I know that I'm not missing something that would invoke the "durr" response 😀

  • RE: In The Zone

    I think you bring up a good point, Ron, about "when" the zone can happen. While I occasionally hit the zone during work hours (if the difficultly level of...

  • RE: The Vacation Dilemma

    I used to be a surety bond underwriter, and for employee dishonesty bonds the primary message to employers was "Make your key staff take vacations and have someone else do...

  • RE: Innovation

    Seems like maybe innovation, as used here, is being muddled a bit with R&D. Innovation is the end result - and arguably the implementation - of a successful R&D...

  • RE: Global temp table vs hit and run on existing table

    Man, I didn't even make the "Database Pros Who Need Your Help!" cut :crying:

    Allow me to rephrase.

    Which statement is "more true", and why?

    "I would rather spork my eyes out than...

  • RE: A Worthwhile Goal

    If it's not too tangential, I'd notch my answer just a bit deeper and say that being data-centric is most important. By example, the business I work for started...

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Ah, I see my confusion, thank you. Without the cross-join there will be 11,260 rows populated. So in the 11,000 example it really doesn't make a difference. ...

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    *sigh*

    Ok, so I guess I'm the only one who doesn't get this part, but:

    in

    SELECT TOP 11000 --equates to more than 30 years of dates ...

  • RE: Writing

    Derek Karpinski (5/9/2008)


    Don't implode. Just far too messy.. And I'm out of shovels and bin liners 🙂 Eeek. Consider the remains....

    Trying to write a poem using only T-SQL keywords....

  • RE: Writing

    Funny timing, this. I was tempted this week to write a bit explaining the COLUMNS-UPDATED because BOL bites on that topic. But it filtered down to not knowing...

Viewing 15 posts - 1 through 15 (of 23 total)