Viewing 9 posts - 31 through 40 (of 40 total)
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?
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
March 12, 2009 at 8:42 am
parsename!!!!!!!!!!!!! how have i never come accross this function before?!?! Cheers for that!
Following now works perfect:
SELECT BRANCH_NO,
BRANCH_STARTRANGE,
...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
January 13, 2009 at 4:08 am
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...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
January 8, 2009 at 4:21 am
GilaMonster (11/28/2008)
sp_recompile 'usp_SummaryOfCashReceiptsByCalMonth'
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)
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
November 28, 2008 at 5:55 am
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...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
November 28, 2008 at 5:07 am
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...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
May 27, 2008 at 2:04 am
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
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
May 13, 2008 at 10:58 am
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...
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
March 13, 2008 at 3:51 am
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?
Knock Knock, Who's There?, sp underscore, sp underscore who?
spid1, spid2, spid3....
March 13, 2008 at 3:05 am
Viewing 9 posts - 31 through 40 (of 40 total)