I guess what I am asking is, can anyone confirm the theory or the behaviour?  When you configure sql to take more memory than it is capable of addressing, does...

The server is configured with /3GB and /PAE.  The issue is that while sql server 2000 enterprise (32-bit) can only handle 8GB, windows 2003 enterprise (32-bit) can address 32GB.  The server...

Thanks!

Couple of questions:

1. Were there cross database joins?

2. Were your PK/FK relationships based on char or int datatypes?

3. Clustered or non-clustered pk's?

Thanks,

steve

So I am still working this issue with MS Support, but I have a favor to ask anyone with a spare minute or two.  Try using:

SET STATISTICS IO  ON

GO

SET STATISTICS...

I agree.  When you view the execution plan I haven't seen a difference between pre-sql92 and sql92 joins.  It generates the same plan.

The ANSI compliant joins are much easier to...

I would recommend that you run weekly maintenance on your databases and run DBCC's to check allocations.  If this was a corrupted table you probably would have seen it by...

Maybe I don't understand what you are asking, but is this what you are looking for?

CREATE Procedure CustomerDetail

(

@CustomerID int,

@FullName varchar(51) OUTPUT,

@EmpNum char(5) OUTPUT,

--@EmpLName varchar(25) OUTPUT,...

I think what you are asking is, Is there a way to see how this occured?  It is possible to view the transaction log file and view the transactions by...

I don't think this will work.  The problem is that cluster resources are managed not by name but by DiskID's.  I think there are some articles about renaming resources and...

This appears to work fine in BCP:

bcp "select top 100 t.col1 + '|' + t.col2 from database..table1 t" queryout c:\textfile.txt -c -Sservername

steve

Can you describe a fbit more of what you need to do?  it is possible for you to reference a temp table from inside the udf...but you can't pass a...

You also need to make sure that you have the correct licensing.  You need Win2k advanced server on both nodes and one license of SQL2k Enterprise Edition for Active/Passive.  Just...

The patindex will definintely work.  The question is which one is the most efficient.  Does the patindex that you propose essentially use a LIKE to do the comparison?  (I know...

I've used the fn_split UDF very effectively in this situation.  Here is a link for the code:

http://www.winnetmag.com/SQLServer/Article/ArticleID/21071/21071.html

it would look something like this:

ALTER PROCEDURE sp_RevByGeo

@mon varchar(255),

@year int

AS

SELECT GEO , CustomerType,...

Thanks.  Yeah I know that it is a bad practice in general to use guid as your clustered index.

I understand what you are saying about SQL Server not moving a...