IN that case, maybe you should think about a FUL TEXT index. With that you can use the CONTAINS clause:

WHERE CONTAINS ( field1, 'blah' or '%' )

DAB

The same holds true for monetary values , '$1,234'.

DAB

YOu said AWE is enabled. In the boot.ini, /PEA and /3GB? Has anyone added anything to the /USERVA switch in boot.ini?

DAB

Colin Betteley (3/19/2008)

I need to pick up a csv file transfer the data to SQL Server and then rename the csv file - adding a date to...

Like Lynn said this looks like it's from a trace. Not only that but from some reporting tool (Crystal, RS) from another server. IF this is indeed from a trace,...

I don't mean to sound condescending but...

Based on your sample data, 0.02343 , that values is NOT less than zero. Values such as -1, -3.1415 are less than zero. Typically...

Glad I could help.

DAB

Yes Jason. Check out this linke http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64044 for the full scans/sec and other acceptable counter values.

DAB

Hans is correct. If you'll indent the joins based on the left parenthesis you will find missing right parenthesis before the GROUP BY clause.

DAB

And the errors you are receiving.

DAB

ALTER PROCEDURE [dbo].[uspFraudReport]

-- Add the parameters for the stored procedure here

(@StartTime datetime = null,

@EndTime datetime = null)

AS

SET NOCOUNT ON

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

Declare ...

One other item to consider in SQL 2005 stored procs is ths use of fully qualified names. So will improve cache hit/miss events.

DAB

As far as PASS sessions this year, abstracts to PASS are due by March 28th so nothing is set.

DAB

Try this...

SELECT g.groupID, cfdn.CustomFieldID,

operand = CASE

...

Not on this forum. This is spcifically for Microsoft SQL Server. However, you can find all that you need at http://dev.mysql.com/.

Due to my experience over the last several years in...