Cheers for the input guys.

In regards to sp_help_revlogin, i noticed on the http://support.microsoft.com/kb/246133 page it lists a new sp for 2000-2005, specifically 'sp_help_revlogin_2000_to_2005 '

Is this one compatible for moving 2000-2008?

parsename!!!!!!!!!!!!! how have i never come accross this function before?!?! Cheers for that!

Following now works perfect:

SELECT BRANCH_NO,

BRANCH_STARTRANGE,

...

Nice Article,

One point of note however; your article seems to focus strictly on Fibre, is this because SQL Server is best suited to Fibre? what about SANS built on...

Had already tried that, made no major difference i'm afraid, i have just tried it again and it had no effect either.

GilaMonster (11/28/2008)

---

p.s. Unrelated to the performance problem,...

parameter sniffing? oooo new term for me, I had a quick read about P-Sniffing but I did not make much sense of it. The code of the SP in question...

Hello everyone, sorry for the delay in my reply, just a quick note, i found the issue, it was as you suggested 'Lock pages is memory' permission.

I did already know...

hello there, its a 32bit system, with 4GB installed, windows has detected the full 4 GB in system information etc.

sp_configure returns

minimum: 0

maximum: 1

config_value: 1

run_value: 0

hmmm, yes based on that i have come up with a simple sub-select approach:

select * from SELECT DailyMileageID, MileageAtStartOfShift, MileageAtEndOfShift, MileageAtEndOfShift - MileageAtStartOfShift AS DayMileage, MileageAtEndOfShift...

a very nice article indeed, however i recently had the same issue on SQL Server 8.0, Is their a related atricle/method for SQL 8?