mpeters-878100 (11/11/2009)

---

I had a similar problem with one of my queries, what i did is hard coded the date time values into the where clause and ran the query, then...

I agree with Sergiy, especially if you have numerous queries that make use of the eventDueDate column in the WHERE clause of queries or if this is a frequent path...

Is this actually being run from within a stored procedure?

If so, may I suggest that you read the second article I reference in my signature block below regarding performance issues?...

If I may, if you have room on the database server to complete your backup locally, I'd do that and THEN move the backup file to the other server. ...

A full backup does not truncate the transaction log. This is only done by a backup log (transaction log backup). Also, please understand that a log truncation is...

JakesterUK (11/11/2009)

---

I am fairly sure the SP is as optimised as it can be, however, I've posted it below: -

ALTER PROCEDURE CheckContext

@CxID int,

...

Assuming that SSMS is running on your PC and you can connect to the SQL Server instance in question from SSMS, in a query window run this:

select @@servername

It would help if you provided the actual error message you are getting.

Slightly confused here, could you explain your problem a little more? It may help to have the DDL for the table involved plus any code you have already attempted...

It would help to see the actual code, the DDL for the tables involved, some sample data for the tables involved, and finally the expected results based on the sample...

Does this code help you?

declare @MyDate datetime;

set @MyDate = getdate();

select convert(varchar(30), @MyDate, 113);

select case when datepart(hh, @MyDate) > 12 then replace(convert(varchar(30), @MyDate, 113), cast(datepart(hh, @MyDate) as varchar), cast((datepart(hh, @MyDate) -...

Are you sure you are trying to install SQL Server 2005 Standard Edition? It almost looks like you are trying to install a web edition.

Have you checked the setup...

Schemas can be used to simplify permissions for different users. For example, you could have schemas from Sales, Purchasing, Inventory; and the users in those departments could be granted...

This is basically the same question you asked here just worded slightly differently.

Same thing,...

Integer arthimetic. Do this:

select cast(73982597/1000000.0 as numeric(8,6))