Forum Replies Created

Viewing 15 posts - 166 through 180 (of 363 total)

  • RE: Linked Server to AS/400

    Use just like a regular table in SQL2K...

    select * from OpenQuery(AS400, 'select * from "F.M.AS400Table" ') AnAS400TableAlias

    Insert into OpenQuery(AS400, 'select fld1 from "F.M.AS400Table" ') AnAS400TableAlias

    Select QSL2kFld1 From SQLTable

     

    Notice AS400 query was...



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 11:00 am

    #490870

  • RE: Pagingfile placement

    Win2k - (RightClick) My Computer - Properties - Advanced - Performance Options

     



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 10:53 am

    #490865

  • RE: Linked Server to AS/400

    Not specific to your "error"....

    We create a linked server on an ODBC entry using Client Access.

    CA version must match AS400 O/S etc...

    OLEDB not so kind as the ODBC ???

    Just thoughts,...



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 9:53 am

    #490850

  • RE: BOL Update

    Thanks Frank....

    MS Site has - "

    Download Size:

    13 KB - 34452 KB

    Don't they know how big it is?



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 9:50 am

    #490849

  • RE: VB Equivalent Format function for T-SQL?

    I used to write "Here's a shameless plug..." got tired of doing that.



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 7:56 am

    #490822

  • RE: VB Equivalent Format function for T-SQL?

    As far a Date Formating, I submitted into the scripts section of this site, VB-like SQL UDF.

    Check out @ http://www.sqlservercentral.com/scripts/contributions/1007.asp

     



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 7:33 am

    #490815

  • RE: OR / IN

    If you look at query plan for a query with an "IN" clause with 2 or more values, you'll see an "OR" happening, so perfomance wise, IN & OR may be...



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 7:24 am

    #490810

  • RE: SQLBill - Juror

    Get / rent a wireless / CDPD laptop setup. Tell them you're taking notes.

    And sit in the back.



    Once you understand the BITs, all the pieces come together

    January 16, 2004 at 3:35 pm

    #490559

  • RE: Fun with datetime

    I just want to know what I have to do 800 years from now when I'm dealing with my "current date" code.

    Signed L....



    Once you understand the BITs, all the pieces come together

    January 16, 2004 at 2:46 pm

    #490555

  • RE: Pagingfile placement

    Giro,

    The reason is, the O/S will recreate the pagefile when it is restarted, or dynamically size according to needs. Many, many O/S operations use this file, not only for...



    Once you understand the BITs, all the pieces come together

    January 16, 2004 at 2:28 pm

    #490550

  • RE: Newbie question - Views & delete

    Good questions can contribute just as much, or even more than good answers, and always are better than bad answers.



    Once you understand the BITs, all the pieces come together

    January 16, 2004 at 1:11 pm

    #490534

  • RE: Job fails because remote server insert fails. Need testing method.

    Funny, I was just on anther thread about linked servers... I do not want to make a "permanent" linked server, for various reasons... but maybe the "failer" of being able...



    Once you understand the BITs, all the pieces come together

    January 16, 2004 at 12:24 pm

    #490519

  • RE: syntax for querying to another sql server

    BOL - SysServer - IsRemote = "1 if server is a remote server, else 0 if server is a linked server."

    hmmmm

    I added a Linked...



    Once you understand the BITs, all the pieces come together

    January 16, 2004 at 12:05 pm

    #490514

  • RE: syntax for querying to another sql server

    Try...

      SELECT SRVName, IsRemote, * FROM Master.dbo.sysServers

    to get started.

    BOL about SysServers table has notes on IsRemote column I do not think are quite right...

    Looking deeper... will post more



    Once you understand the BITs, all the pieces come together

    January 16, 2004 at 11:55 am

    #490510

  • RE: Pagingfile placement

    I agree, but I think having it fixed sized is of greatest performance importance.

    I like to "fix size" as early in the PC installation process as possible so that the

    permanent,...



    Once you understand the BITs, all the pieces come together

    January 16, 2004 at 11:49 am

    #490507

Viewing 15 posts - 166 through 180 (of 363 total)