This also happens when you use a query hint on a filtered index that does not fall within the parameters of the where clause

Well either the second parameter of the dbo.eProcedure stored procedure is of type VARCHAR, or column1 of table1 is of type VARCHAR.

Perhaps make sure @eValue is the same type...

Another option would be to do the delete on an insert trigger, it would add additional overhead on the table, but if the table does not have too much activity...

Do you have a DATETIME column on the table? You would need it to delete rows older than 30 minutes. To do that you can use the DATEADD function in...

Your example does not clearly show a CTE, but if I presume your first select statement is the CTE then the way you would select items would be like this:

;

WITH...

What about data older than 7 days, do you want to keep it there?

I don't think you can truncate committed data selectively from the log. It's a all or nothing...

you can do this:

SELECT PostCode, COUNT(Postcode) FROM

(

SELECT DISTINCT Address1, Address2, City, Postcode, Postcode

FROM AddressTable

) AS Sub

GROUP BY Postcode

HAVING COUNT(Postcode) > 1

Another way of doing it is to process a batch of rows at a time in a while loop. For instance copy 100,000 rows at a time until they all...

Both servers currently runs the SQL service under the domain's Administrator account.

Hi

The ports seems to be fine on both servers

I can Tellnet to that server name and port and it connects immediately. I can also Tellnet back from that server to...

Almost sounds more like a crystal problem than a SQL problem.

You could pass the date value as a string to the stored procedure and then convert the string to proper...

I presume the stored procedure does not even get executed because the date value passed into the date parameters fails the conversion.

Can't you format the date value in the report...

What are the values you are passing into the stored procedure? Can you post that code as well?

And what data type is the column MWAPPTS.ADATE ?

Hi Stef

I've noticed before with large varchar columns as the primary key the inserts takes very long. The chance of each new primary key value to be inserted to be...

Have installed the latest service packs?

This error was addressed in service pack 1, but I'm not sure if it will help with a 30Mb query.

I also found this article by...