Forum Replies Created

Viewing 15 posts - 406 through 420 (of 820 total)

  • RE: The Vermillion Screen of Death (Raw Materials Comic Strip)

    Thanks Steve. Good move doing this.

    Hey gang, I looked up "Vermillion". Wikipedia spells it with one "L". For all the "natural ingredients" folk just look at what...

  • RE: Chargeback

    I guess I'm lucky, if you can call it that. Most of my work has been for IT companies. Typically I'm the resource that get shared. Then...

  • RE: The Scary DBA

    I knew of a mythical organization where "got root?" had real meaning. One server had root root as the credential for root. After getting flamed for SA no...

  • RE: The Value of Your Time

    We all pitch in when needed. Sometimes going and doing something outside the norm can be a mini vacation. Anything can be abused.

    One day a fellow...

  • RE: Date and Time dimension creation and population T-SQL

    Thanks. I had to go into view source and grab it. No big thing that. Then I had to turn all the non-breaking-space codes into spaces, all...

  • RE: Full Databasestructure knowledge

    I wrote at Dot Net program to list the tables. I then added a table called doc_fields that has table name, column name, and comments. My lister merged...

  • RE: Date and Time dimension creation and population T-SQL

    That's better. Using a number that represents a date on some particular scale is more reasonable. It reminds me of the Unix time stamp. It also reminds...

  • RE: Which database is installed MSDE or SQL Server Express?

    Perry Whittle (2/12/2009)


    connect to each instance and execute

    select serverproperty('edition'), serverproperty('productversion')

    note the results down for each instance you connect to

    That works great. I wonder if this works for Compact Edition?

  • RE: Date and Time dimension creation and population T-SQL

    Great article.

    I was not able to copy and paste the code into SSMS. Had unicode characters and syntax errors that I could not see.

    I also have lots of tables...

  • RE: Complicated Comments

    I wrote some stuff in Perl as that was what was available on the web server. It was not that bad to write code. You start with the...

  • RE: Complicated Comments

    Good point. But then

    /*

    Good comment not.

    -/**/*/

    does work. Does this remind you of the Perl parser?

  • RE: Export Data in Text File Using BCP

    Good article. One suggestion would be to use the pipe character ( | ) as the default separator. Some people and place names have embedded commas. Some...

  • RE: Complicated Comments

    Let me see if I can show what is going on here and why. Lets number the lines

    (00) PRINT '1' -- /* ;PRINT '2' */ ;PRINT '3' /*

    (01) PRINT...

  • RE: Automate Default Constraints

    You are very welcome.

    Congratulations on writing a good article and taking criticism. Keep up the good work.

  • RE: Automate Default Constraints

    Good article.

    You should put a check in for columns that support NULL. They don't need defaults and in many cases should not have them. For example I'm doing...

Viewing 15 posts - 406 through 420 (of 820 total)