Forum Replies Created

Viewing 15 posts - 256 through 270 (of 921 total)

  • RE: NT 4 support, when will it end ?

    It's a phased retirement; explained here:

    http://www.microsoft.com/ntserver/ProductInfo/Availability/Retiring.asp

    January 13, 2004 at 7:50 am

    #489745

  • RE: Need help converting chars to a date result

    Revising Frank's solution for the OP's data types:

    declare @myyear char,  @mydays char(3)

    set @myyear = '3'

    set @mydays = '057'

    select dateadd(d,@mydays-1,'200' + @myyear)

    January 12, 2004 at 3:27 pm

    #489656

  • RE: SQL Date Problem

    That's exactly backwards advice.  Putting the column values in a function makes the predicate non-sargable.  Even just converting the values (as your solution also...

    January 12, 2004 at 7:20 am

    #489598

  • RE: Using 3 GB of RAM

    Terry-

    Those symptoms sound consistent with enabling AWE but not having the /pae parameter correctly entered in the boot.ini file. 

    January 9, 2004 at 11:45 am

    #489431

  • RE: Using 3 GB of RAM

    Terry--

    Okay, then. 

    Did the SQL Server service login account have the Lock pages in memory privilege?

    Did you set awe enabled to 1 in the SQL Server configuration?

    Are you using multiple...

    January 9, 2004 at 10:53 am

    #489424

  • RE: Using 3 GB of RAM

    You must use Windows 2000 Advanced Server or Datacenter Server, or Windows Server 2003 Enterprise Edition or Datacenter Edition.

    January 9, 2004 at 9:42 am

    #489415

  • RE: best practice for sub select in sproc

    How about just:

    CREATE PROCEDURE dbo.spProductMaxDetailsGet

    AS

    SELECT TOP 1 WITH TIES *

    January 9, 2004 at 9:35 am

    #489412

  • RE: Using 3 GB of RAM

    Terry--

    What versions and editions of SQL Server and Windows Server?

    January 9, 2004 at 9:25 am

    #489406

  • RE: Using 3 GB of RAM

    No; that's only when using AWE memory, i.e. memory greater than 4GB by using the /PAE option.

    January 9, 2004 at 8:04 am

    #489383

  • RE: SQL Date Problem

    WHERE LastDate = CONVERT(char(10),GETDATE(),111)

    Why use varchar(10) for dates instead of one of the temporal data types?

    January 9, 2004 at 7:36 am

    #489366

  • RE: SQL Server Maximum Size

    That's 1,048,516 Terabytes, not 1.05 Terabytes.  For each database.  Instances have no bearing on this limitation.

    January 9, 2004 at 7:32 am

    #489362

  • RE: SQL Server Maximum Size

    1,048,516TB for SQL Server 7 or SQL Server 2000, unless you're using MSDE where it's limited to 2GB.  No difference when using instances.

    January 9, 2004 at 6:55 am

    #489351

  • RE: Using 3 GB of RAM

    I can't restart a server with 4GB right now to verify this, but I believe that using just -g will be the same as not using the switch.  You will instead...

    January 9, 2004 at 6:49 am

    #489350

  • RE: help

    If you're using the result as a number, cast it to decimal.  If you're just displaying the result, you can use STR().

    SELECT CAST(Elevation*1./Height AS dec(9,2)), STR(Elevation*1./Height,10,2)

    Multiplying by 1. is the lazy...

    January 9, 2004 at 6:26 am

    #489339

  • RE: Using 3 GB of RAM

    That's normal.  SQL Server 2000 will not reserve the last 384M for its memory pool.  It still uses memory outside its pool for processes like extended stored procedures, distributed queries, and tran log...

    January 9, 2004 at 5:47 am

    #489333

Viewing 15 posts - 256 through 270 (of 921 total)