Ninja,

Thanks, but unfortunately, I can't post any specific examples of our calculations.  The data itself would not be meaningful without the calculations that produced them, and I can't post these...

Hi everyone and thanks for your comments.

Unfortunately I clearly didn't define my problem clearly enough because we seem to have gone on to a side issue questioning the database design, rather...

Whilst I obviously agree that you want your CV and covering letter to be as accurate and impressive as possible, I was a little surprised over the very narrow band...

Still doesn't seem to be corrected.  Oh well...

I wonder if it could be caused by a badly fragmented index?   Perhaps because of the physical position of the max records on the disk it is able to find...

Steve, Bernard, thanks for your answers.  I managed to fix the problem by un-registering the server in Enterprise Manager and the re-registering it under the name (local) rather than the...

What I usually do when hit with a problem like this is to first work out which bit of the procedure is taking the most time.  I do this by putting...

In your code, the variable @cont_descCursor is undefined.  Perhaps that is the source of your problem.

Your stored procedure has returns 2 resultsets:

Select unit, JobCCNO,  [FULL NAME], SSN, EMPLNO ,[Unit Desc],  Department, Manager     from dbo.WinEmp

select *  from dbo.WinEmp  E ....etc

So in grid mode, 2 grids are...

You could use a trigger to get the row count e.g.

CREATE TABLE [dbo].[RowCounts] (

 [MyID] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,

 [Counter] [int] NULL

) ON [PRIMARY]

GO

CREATE TRIGGER [CountRows] ON [dbo].[RowCounts]

FOR...

My job is fairly dull a lot of the time with bouts of overwork and panic, and not particularly well paid. But, I get to work from home almost everyday, which...

You could use the Convert function to format the date as a string which does not include the time:

e.g.

WHERE Convert(varchar,table1.date,103) = Convert(varchar,table2.date,103)

One think I particularly like is that you can cut and paste into (or from) Excel.  I often have to send adhoc data samples in excel to our test team...

Thanks everyone, looks like the first thing we will do is get more memory, and some more disk and then move the data and logs to separate file systems.

Thanks for your thoughts Mike, I had been wondering if moving the databases around might give us a boost, certainly I have found that having tempdb on a different array to...