Forum Replies Created

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

  • RE: I can not type into the message body.

    Same here.  It just never seems to finish loading.

    I've had better luck setting explorer not to validate pages (i.e. "Check for a newer version of the page"... "Everytime you start...

  • RE: SQL server does not listen on TCP/IP in Windows Server 2003

    I realize this is not particularly helpful but I've installed W2003 twice now and both are working via TCP/IP.  Perhaps a conflict on the port, is something else running on...

  • RE: New Forums are Live!

    I think you put the new format up prematurely.  It's not working.  The link to report errors is not working ("The resource cannot be found").

    When I log in I always...

  • RE: Whether to use or not a Stored Procedure

    On rereading the question I think I answered something you did not ask -- whether or not to use Dynamic SQL.

    You are asking whether you are better off issuing the...

  • RE: Whether to use or not a Stored Procedure

    Depending on what exactly would generate the dynamic sql, I have become a firm believer in doing just that for most such queries.

    Everything is "it depends", but assuming your tables...

  • RE: Do the certifications add value?

    This has become something of a general hiring thread and is interesting.

    quote:


    As for (1):

    That risk you'll always have. You...

  • RE: Generate Sequence Number Safely

    If you are replicating the table with updates occurring on the subscriber and publisher take care to plan carefully what you do in this regard since coming up with sequential...

  • RE: result to produce single row from multiple rows

    It's pretty easy to make your own sequence number from any list that has unique values by just doing an inner select and count greater (or less). Here's an...

  • RE: Do the certifications add value?

    I'm very interested in the idea that you expected to take a test. Is that common?

    I've frequently sat an interviewee down in front of a terminal and asked them...

  • RE: result to produce single row from multiple rows

    I didn't try to write this precisely, but the way I've done it looks vaguely like this:

    select field1, field2, field3, -- << regular fields

    ...

  • RE: Windows 2003 performance

    How did memory change between them? I.e. is the 4GB additional something that might have changed, e.g. using AWE whereas you were not, or such?

    We plan to go from...

  • RE: Do the certifications add value?

    Brian, How do you weed out resumes?

    My hat is off to anyone who carefully reads each one. That's the "right" way. But it isn't practical with resume...

  • RE: OS Upgrade

    Re johncyriac and trusted users -- is this on a domain or a workgroup? If your trusted users are domain users AND this isn't the only domain controller, this...

  • RE: SQL Recommendations

    As Graeme said, keep it simple. Front page may not be the best way, if you aren't ready for Dot.Net (and the hurdle to get into it is higher...

  • RE: SQL query to return column names

    Example: (change table name from 'Title' to whatever you want)

    select sc.name

    from sysobjects so

    inner join syscolumns sc on sc.id=so.id

    where so.type='U' and so.name = 'Title'

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