Viewing 15 posts - 7,126 through 7,140 (of 8,416 total)
Kwisatz78 (9/8/2009)
😀 so are you saying I should maybe change the min server memory to 1GB? Oh this is 32bit without AWE implemented.
The min/max server memory settings relate to...
September 8, 2009 at 7:43 am
For very large tables (containing the hashbytes or checksum result as part of an indexed computed column) something based around the following can perform quite well...
select e1.id,
...
September 8, 2009 at 7:34 am
Kwisatz78 (9/8/2009)
Wow that was quick, I was just editing the post, please see above 🙂
Likewise :laugh:
September 8, 2009 at 7:22 am
Kwisatz78 (9/8/2009)
How do I check whats allotted, this isn't the max server memory setting is it?
That's what he's after, yes.
edit: Just seen your posted figures. Buffer cache hit...
September 8, 2009 at 7:18 am
ALZDBA (9/8/2009)
So it must be a checkpoint kind of indicator.Does it change after the full index has been rebuilt ?
I agree it seems related - after all rebuilding online with...
September 8, 2009 at 6:59 am
:laugh: You knew the one I meant though!
September 8, 2009 at 6:53 am
Bob Hovious (9/8/2009)
SOM 😛"For the love of small, fluffy bunnies?"
We're even on coffee for the day, Paul.
Ha! I'm glad. 🙂
'Paulpatine'
September 8, 2009 at 6:51 am
I just caught the pre-edit version of that. Please understand that your initial response was frustrating to me as well. Twenty minutes had elapsed since my post outlining...
September 8, 2009 at 6:49 am
Not really - not without writing an awful lot of custom code anyway.
It's probably not what you want, but Paul Randall published a script some time ago to estimate the...
September 8, 2009 at 6:34 am
Yes, FTP was a real 'win' for us - even the latest 2008 Server doesn't do file copy well. It has a bug where a large copy bloats the...
September 8, 2009 at 6:26 am
Bob Hovious (9/8/2009)
the most amazingly cross-purposed debate ever
Where did this take place?
Sorry: http://www.sqlservercentral.com/Forums/Topic783877-357-1.aspx
Paul
September 8, 2009 at 6:21 am
Bob Hovious (9/8/2009)
September 8, 2009 at 6:11 am
GilaMonster (9/8/2009)
My money's on the pigeon.
Do you realize we just had the most amazingly cross-purposed debate ever?
I just realized what had happened - and I want my lost time back!!!
I...
September 8, 2009 at 6:06 am
GilaMonster (9/8/2009)
...stuff...
Oh for the love of small fluffy bunnies! :laugh:
I see what has happened here...
Me, before your first post: "Actually, I might have misread the question first time around...
September 8, 2009 at 6:02 am
The odd thing is that I expected the index rows to be 12 bytes wide - 8 bytes for the RID pointer back to the data (this is a heap)...
September 8, 2009 at 5:44 am
Viewing 15 posts - 7,126 through 7,140 (of 8,416 total)