Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Best Way to Calculate Age

    All three queries returned the wrong answer for me. My birthdate is this month and each returned an age one year older than actual. The third expression is...

  • RE: Dynamic Management Views

    Thanks Erich, that worked. Actually, I had to replace the DB_ID function with the literal value of the database id and voila! It works! Thanks again.

  • RE: Dynamic Management Views

    Thanks Dave. I agree with your comment on the index tuning wizard. I ran it once; it recommended a clustered index that covered about ten columns on a...

  • RE: Dynamic Management Views

    Thanks Paul! It's the compatibility level; this database was created with the compatibility level set at 80, probably because it was "imported" from SQL 2000. The...

  • RE: Dynamic Management Views

    Lucky,

    Thanks for responding so quickly. It doesn't seem to matter what I do; if the current database is not master, no go. I just closed out SSMS and...

  • RE: The In-House Expert

    I just wanted to comment on the "shoestring staff to maintain operations and then use consultants for any additional or specialized work" question. I work for an automotive supplier...

  • RE: Connecting to AS400 DB2

    I have tried using DTS to convert an AS400 file to an SQL table...  I gave up.  I had the (apparently common) problem of having the DTS package run fine...

Viewing 7 posts - 1 through 7 (of 7 total)