How long does this command take?

select *

Into #temp

from [Audit]

where CreatedWhen between GetYear() and GetYear()-365

Yeah, that's pre-Google and pre-Wikipedia

You might want to contact the Microsoft SQL Customer Advisory Team. Their website is here: http://sqlcat.com/

Please post the query plan also.

Sure, they've all seen that movie. 🙂

Actually, this is something that many of my clients have asked me to do: participate as a technical interviewer in their engagement of prospective employees.

Sorry I forgot two of the statistics:

Physical disk: Disk bytes/sec

Physical disk: Disk transfers/sec

If you could also get these numbers from times when the performance is OK,...

Well you didn't really answer most of my questions...

The Physical disk:Avg Sec/write counter is high on drive where tlog files reside.

The MS...

Ah. Let me guess: you are running on SQL Server 2000? (or else your DB compatibility level is...

You should worry about your Log file before you add a second data file.

What is your disk configuration? How are your user and TempDB data and log files allocated to these disks?

What are your PerfMon Physical disk statistics during this problem? ...

Glad we could help. Be sure to let us know how it works out.

In that case, this may serve you better:

ALTER PROCEDURE [dbo].[sp_ProfitStar] @date datetime AS

SET NOCOUNT ON;

Declare @DayBegin datetime, @DayNext as datetime

Select @DayBegin = DateAdd(dd, DateDiff(dd, 0,...

Well, it seemed like the dynamic SQL and all of these conversions back and forth were unnecessary so I did without them. Anyway, this is how I would do...

Why are all of these dates being converted to VARCHAR and then back to DATETIME again? Does this accomplish anything?