Forum Replies Created

Viewing 15 posts - 151 through 165 (of 363 total)

  • RE: BOL Update

    Thanks

    I'll go ahead and serch the whole C:\Program Files..... for the DateTime, but I do not have a "C:\Program Files\Microsoft SQL Server Books Online" dir. Got VS6, VS.NET, VS.NET 2003.......



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 7:57 am

    #490981

  • RE: Text function in T_sql

    Lars, try the various methods. depending on your data, the REPLACE() may run 5-10 time slower than the REPLICATE() or RIGHT(). Also consider if -1 = '-00001' or '0000-1' for...



    Once you understand the BITs, all the pieces come together

    January 21, 2004 at 7:52 am

    #490980

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

    When unable to type, left banner is just the Blue bordered box

    When I am able to type, the Litespeed ad fills the box almost instantly.

    The footer banner (Compare... 100 times....)...



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 5:31 pm

    #490924

  • RE: Enterprise Manager and Network Traffic

    And... What happens if you put that particular server in another EM Server Group (not the "SQL Server Group"), and leave it's tree collapsed?



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 3:00 pm

    #490912

  • RE: Enterprise Manager and Network Traffic

    Heck , I've got servers that don't even exist anymore. Hope it not slowing me down trying to get to these guys... I guess EM tries to keep the "green...



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 2:02 pm

    #490907

  • RE: BOL Update

    Ok, installed on WinXP PC fine, my "old" PC (don't ask - pre anything you probably have) gives me "... You must install a Windows service pack that contains a...



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 1:34 pm

    #490902

  • RE: Linked Server to AS/400

    One other thing, sometimes when perfoming a query in Q/A to the AS400, a "Client Access provided Login" dialog box may appear under certain configurations. If this is the case,...



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 12:48 pm

    #490899

  • RE: Linked Server to AS/400

    Here is what I say:

    "The Client Access ODBC driver has many configuration options that affect the way the Windows PC and AS400 interact. These options are not staightforward, and the...



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 12:27 pm

    #490893

  • RE: Linked Server to AS/400

    The "not getting all the rows" thing...

    also ODBC config settings.

    Sorry no details, shoot I don't even have an AS400 here /



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 11:53 am

    #490884

  • RE: Pagingfile placement

    NP, just post any results of what you do if you see any significant performance gains / losses depending on what all you're seting up or testing.

    Thanks



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 11:51 am

    #490883

  • RE: Linked Server to AS/400

    I do not know if "SHEAU"."AA_CHEQUE" is identicle to "SHEAU.AA_CHEQUE" ????

    Seems I came across "not getting all the rows" thing... Will look into...

    On the INSERT side, try enumerating the individual column...



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 11:47 am

    #490882

  • RE: Text function in T_sql

    Thanks Lars

    Yes, can be simplified... just remember to deal with negative values if appropriate.

     



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 11:23 am

    #490878

  • RE: Pagingfile placement

    Yes, same min/max, as far as I can remember.... (been a while, and getting older )



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 11:21 am

    #490877

  • RE: How to pass parameters into inline UDF from a sub query

    In a prior post I once wrote:

    @ http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=19016#bm90510

    I was wanting to do the same thing some time ago... I realized that Table Function parameters can NOT be values...



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 11:19 am

    #490876

  • RE: Text function in T_sql

    I use a little udf like

    Create Function fn_LPadZero

     (@Num varchar(20),

      @Length int)

    Returns VarChar(20)

    -- Returns passed integer value left-padded with zeros for length of passed @Length

    -- ie passed value of 123,6 becomes "000123"

    --...



    Once you understand the BITs, all the pieces come together

    January 20, 2004 at 11:08 am

    #490871

Viewing 15 posts - 151 through 165 (of 363 total)