Forum Replies Created

Viewing 15 posts - 61 through 75 (of 411 total)

  • RE: Undocumented Extended and Stored Procedures

    JStiney, that is an excellent procedure. Thank you.

  • RE: Undocumented Extended and Stored Procedures

    Steve Jones - Editor (11/20/2009)


    I made a few changes to the formatting, so the article should read better now.

    Thank you. The changes are not very noticeable in FireFox to...

  • RE: REPLACE Multiple Spaces with One

    As always an excellent article. Situations like this do make me wish that they would incorporate true Regex into the core engine, but of course I can also see...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    All I can say is that this is a fantastic article with a great discussion of the different techniques and an explanation to why one is superior.

  • RE: Preventing usage of "SELECT *..."

    ndrd (11/6/2009)


    the solution provided does not work on oracle. does it really work on some other RDBMS....i doubt? kindly clarify if some alterations required!

    It works quite well in MS SQL...

  • RE: Preventing usage of "SELECT *..."

    A very interesting article with a solution I had not considered.

    Of course, to echo so many others I do not think it is practical. I am quite comfortable with...

  • RE: How to Connect to a SQL 2005 Server When You Are Completely Locked Out

    john.vanda (11/3/2009)


    This happens if you don't want your outsourced IT Dept. seeing accounting data, such as payroll. SQL Server single user mode must use a separate set of permissions that,...

  • RE: Testing a BAK file

    Can I ask why you cannot restore it if you want to test it?

    Gail's advice about "Verify Only" is good and that is reliable the vast majority of...

  • RE: Getting started with SQL Azure

    Robert, I think that it would be wise to treat all but the most generic of customer information, and certainly anything personally identifiable, as at least somewhat sensitive.

    However, there is...

  • RE: Getting started with SQL Azure

    Robert DeFazio, I am truly impressed with your answer. It seems well thought out and researched. But you seem to see no value in the Cloud whatsoever. ...

  • RE: Getting started with SQL Azure

    GRE-452109 (10/22/2009)


    How do we think the Cloud will affect the 'employability' of the DBA?

    Do we think it will reduce the amount of DBA jobs available? (as a results of adavantage...

  • RE: Concatenating Rows

    a.everett (10/14/2009)


    so as newbie in the top post quotes why not just use a select @var+ to concatenate.

    You said it thats fine for 1 entity granted can see that.

    But just...

  • RE: SQL & the JOIN Operator

    Excellent article.

    I'll echo several other posts and point out I frequently use cross joins for test data or simply when I need to have a huge number of...

  • RE: COPY_ONLY Backups

    Charles Kincaid (9/30/2009)


    Vliet is correct. So are many of the other points raised. Yet there was one thing missed. Yet we have seen the following many times:

    (1)...

  • RE: The Dynamic Tally or Numbers Table

    Great article Lynn. It seems that even if you aren't permitted to change the schema that if you are going to use it multiple times you might get better...

Viewing 15 posts - 61 through 75 (of 411 total)