Forum Replies Created

Viewing 15 posts - 16 through 30 (of 56 total)

  • RE: DTS Hashing

    Thank you all for your comments!

    True, this is not a true hash but I needed something to title the article. I'll be more careful in the future.

    I also use...


    Cheers,

    Alex

    Rogue DBA

  • RE: Coding Standards Part 2 - Formatting

    I agree with everything but using aliases. Though it makes it more difficult to read sometimes because of lengthy table names, debugging and modifications are much easier.

    For instance, If...


    Cheers,

    Alex

    Rogue DBA

  • RE: Question of the Day for 12 Dec 2005

    Damn Microsoft inconsistencies, I assumed it was the same syntax as the FULL TEXT INDEX option:

    ALTER FULLTEXT INDEX ON HumanResources.JobCandidate ENABLE

    I guess I'll start checking MSDN every time before answering...


    Cheers,

    Alex

    Rogue DBA

  • RE: ASP - Reaping the benifits of SQL 2000''s FOR XML clause.

    I know, Im coming to this article a bit late but .. this rox! I've been looking for something simple to implement and this definitely hits the head of the...


    Cheers,

    Alex

    Rogue DBA

  • RE: Anti-Offshore

    This debate will go on forever. I see two problems really. The first is the current generation of executive management. Gone are the days when the officers of a company...


    Cheers,

    Alex

    Rogue DBA

  • RE: Take Care of Your Own

    I've asked this very question numerous times and never gotten an answer. If you feel the urge to write about socio-economic issues in the U.S. then start your own blog....


    Cheers,

    Alex

    Rogue DBA

  • RE: DTS Standards

    I agree that the naming convention should certainly be used to clearly identify sources and destinations as well as transform steps. As for using descriptive text at the top of...


    Cheers,

    Alex

    Rogue DBA

  • RE: Return of the users from hell!

    The most amusing thing about this article is being able to throw the respondents into one category or another based on their replies.

    I love this! Job well done. You...


    Cheers,

    Alex

    Rogue DBA

  • RE: User Defined Data Types in SQL Server 2005

    In my opinion the use of UDTs carry little advantage. If you refer to Peter's example all the way back on page 1 about using a UDT to hold an...


    Cheers,

    Alex

    Rogue DBA

  • RE: Check Your SQL Server Identity

    Using this as a way to educate and bring developers up to speed makes sense. Using this as a question for a prospective DBA or developer is hogwash. There are...


    Cheers,

    Alex

    Rogue DBA

  • RE: Worst Practices - Not Using Primary Keys and Clustered Indexes

    I agree that a PK on EVERY table is an essential part of database design. As far as the clustered index is concerned, I follow the "let the ends justify...


    Cheers,

    Alex

    Rogue DBA

  • RE: IT Unions

    Well, the Bill Gates comment was over the top but in general, I agree whole heartedly. I did find this comment by Mr. Jones in his editorial most interesting:

    "I've long...


    Cheers,

    Alex

    Rogue DBA

  • RE: Using Technology to Terrorize

    Though I appreciate the "informational value" of this editorial, I wonder now if this will become just one more politically oriented message board. Stick to doing what you've done so...


    Cheers,

    Alex

    Rogue DBA

  • RE: Help with DBCC Results

    I agree, for a table with only 2000 rows, your best bet would be to copy out the data to a separate table, then apply the index. You could simply...


    Cheers,

    Alex

    Rogue DBA

  • RE: Backups & Log Files on Shared Server

    First, I'm appalled that a hosting company would follow such practices. Please take the advice of the other posters and find a new host.

    Second, being simple enough to do, using...


    Cheers,

    Alex

    Rogue DBA

Viewing 15 posts - 16 through 30 (of 56 total)