Forum Replies Created

Viewing 15 posts - 241 through 255 (of 267 total)

  • RE: Table Variable Question or not?

    GMan, I have two thoughts to share with you:

    1. The order of clauses in your SELECT ... INTO statement is incorrect. The correct order is SELECT columns INTO...

    December 31, 2003 at 3:33 pm

    #488412

  • RE: Confused About a NULL

    Your query:

    Select Distinct Location From esi_PricesTemp Where Location In (Select GridPoint From esi_PriceHistoryLocations) Order By Location

    In order for a row from esi_PricesTemp to be included in the resultset, the WHERE...

    December 31, 2003 at 3:10 pm

    #488411

  • RE: Do the certifications add value?

    I didn't have time to read all these posts (true confessions), so at the risk of being repetitive, let me add my 0.02: in my opinion, certifications can help...

    December 31, 2003 at 2:54 pm

    #488410

  • RE: QOD 12/31

    quote:

    Since SQL 2000 databases have a limit of 1,048,516 TB, doesn’t that mean that a table cannot exceed that limit?

    December 31, 2003 at 2:47 pm

    #488409

  • RE: Sniped by QOD (26-Dec-2003)

    quote:

    Anyone heard anything back from an admin (or other with the site)?

    Nope. Maybe they'll...

    December 29, 2003 at 10:53 pm

    #488119

  • RE: Sniped by QOD (26-Dec-2003)

    You know, I wonder if the question might have been a repeat, and maybe I missed it the first time around. I haven't missed many questions (only 4, I...

    December 28, 2003 at 5:32 pm

    #487872

  • RE: Sniped by QOD (26-Dec-2003)

    quote:

    But, unlike you, I have no complaints.... for me, it said I'd gotten it right.

    December 28, 2003 at 12:18 pm

    #487863

  • RE: SQLServer.com listserv insanity

    Fair enough. Thanks for the reply, though! If it keeps up, I'll just build a filter based on the RE: line instead.

    Chris

    December 23, 2003 at 2:13 pm

    #487679

  • RE: SQL Server VS. Oracle

    quote:

    BTW, wouldn't Oracle's RAW file be the same as the file used by SQL Server? all tables in SQL Server are contained...

    December 23, 2003 at 10:09 am

    #487634

  • RE: SQL Server VS. Oracle

    quote:

    ...I find T-sql much easier and versitile than pl/sql...

    I have gobs and gobs and gobs...

    December 23, 2003 at 9:55 am

    #487633

  • RE: Aggregate functions

    As far as I know, you can only write user-defined functions that are scalar or table-valued, not aggregate.

    Edited by - chrisleonard on 12/09/2003 10:54:37 AM

    December 9, 2003 at 10:54 am

    #485372

  • RE: QOD 11/25

    quote:

    quote:

    I've never actually done ANY IO tuning so extent size to me is irrelevant.

    ...

    December 2, 2003 at 7:45 am

    #484278

  • RE: QOD 11/25

    I don't mean to sound arrogant about this, but the only shock I had with this question was that it was worth 3 points. This is a simple question...

    November 26, 2003 at 10:30 am

    #483786

  • RE: poor Question of the day 7_13_2003

    quote:

    Yup. I spent over a year doing this stuff every waking hour when I was working on a SQL Server Security book...

    July 16, 2003 at 2:28 pm

    #465744

  • RE: poor Question of the day 7_13_2003

    quote:

    <rant>

    Keep in mind that Andy, Brian, and Steve have full time jobs of their own. SQLServerCentral.com represents a labor of love for...

    July 16, 2003 at 2:27 pm

    #465743

Viewing 15 posts - 241 through 255 (of 267 total)