Forum Replies Created

Viewing 15 posts - 136 through 150 (of 363 total)

  • RE: BOL Update

    OK, will do tomorrow... heading out for the day

    Thanks

    PS, Awful late in the day for you Frank

    January 21, 2004 at 3:44 pm

    #491048

  • RE: BOL Update

    I still see "What's New in Microsoft SQL Server 2000"

    Could be the "contents" comes from the .COL file ????

    How about something I can...



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 3:26 pm

    #491045

  • RE: Optimizing querries to avoid timeouts

    Generally speaking, the WHERE clause of the SELECT statement limits the number of records the query will return. As with most any client side application, you want to query for...



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 2:16 pm

    #491033

  • RE: SP not using optimal exec plan

    Also, does the SP produce #Temp tables with data you are "massively" processing or have many rows in them.



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 1:57 pm

    #491030

  • RE: Global Sequencer

    Did you know that SQL Srv. will effectively "drop" a table from the execution plan if:

    1. View is like SELECT ... UNION ... UNION ... UNION ... UNION ... etc.

    2....



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 12:27 pm

    #491020

  • RE: Global Sequencer

    That will work(around) fine.

    BTW, Are you "vertically" partitioning for the purpose of query performance against the VIEW? so that SQL Srv. "drops" curtain tables from the execution plan as the...



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 11:57 am

    #491016

  • RE: Performance Issue w/ IF Exists

    Can you post the queries you are using in context?



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 11:49 am

    #491015

  • RE: Can not type in Mesage body - happening again

    Andy, I can sometimes edit even when the left banner is not "complete".

    I can always edit when the left banner is complete.



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 11:37 am

    #491012

  • RE: Global Sequencer

    Ozamora, 

    A GUID will produce a globally unique identifier, if that is what you need, then that's the ticket.

    If you just need some ever incrementing unique numbers, then the...



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 10:14 am

    #491005

  • RE: Global Sequencer

    Above should work for as many tables as you want...

    Table1 ... GlobalUnq INT IDENTITY(1, 100) ... 101, 201, 301, 401...

    Table2 ... GlobalUnq INT IDENTITY(2, 100) ... 102, 202, 302, 402...

    Table3...



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 9:27 am

    #491002

  • RE: Global Sequencer

    You could use the IDENTITY [ ( seed , increment ) ] property with varying seeds and increments.

    Table1 ... GlobalUnq INT IDENTITY(1, 3) ... 1, 4, 7, 10...

    Table2 ... GlobalUnq...



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 9:09 am

    #490998

  • RE: BOL Update

    Frank, the "en" is most likely because you have the ENglish BOL on a German language O/S ???

    I just have to SQL80.??? files.

    Copied the tsqlref.chm (2MB), got "mismatch version" message, copied...



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 9:00 am

    #490997

  • RE: BOL Update

    Do either of you have an SQL80.chw (~ 5+ MB) dated appropriately?

    I think that's the one.

    Sorry, edited chm -> chw.



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 8:28 am

    #490995

  • RE: BOL Update

    Shortcut just points to that 12KB "SQL80.COL" file in ...\80\tools\books dir



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 8:07 am

    #490986

  • RE: SQLBill - Juror

    Did you at least get your "wireless" setup out of the deal?



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 8:04 am

    #490985

    • Viewing 15 posts - 136 through 150 (of 363 total)