Viewing 15 posts - 241 through 255 (of 8,416 total)
Sergiy (9/16/2012)
September 16, 2012 at 4:46 am
Evil Kraig F (9/14/2012)
I certainly hope so! I'll bring the beer. 😀
Nice save!
September 14, 2012 at 5:52 pm
Peter Brinkhaus (9/14/2012)
Looking at the syntax definition of the FROM clause the binding error makes perfect sense.
That does make sense, thanks!
BTW: Never post anything ever again, Peter. You have...
September 14, 2012 at 5:33 pm
Evil Kraig F (9/14/2012)
He might have meant as far away from civilization as possible, in which case New Zealand might have been more accurate... 😛
Noting all this down, Mr Farrell....
September 14, 2012 at 5:27 pm
Gianluca Sartori (9/14/2012)
If that happens, I'll run away and hide as far as I can.Uh, wait... isn't that New Zealand?
C'mon Paul, get the guest room ready! 😀
According to http://www.antipodemap.com/...
September 14, 2012 at 5:19 pm
Gianluca Sartori (9/14/2012)
I never thought it could be that hard!
I know exactly what I...
September 14, 2012 at 4:50 pm
Gianluca Sartori (9/14/2012)
SQL Kiwi (9/14/2012)
Good grief, we have all been wrong about things from time to time.Speak for yourself! 😛
Oh. :crying:
September 14, 2012 at 4:44 pm
GilaMonster (9/14/2012)
Really tempted to go really sarcastic at this point. "Oh noooes. 2 pages displaced!"
:laugh: Yes. I hope people have their popcorn handy.
September 14, 2012 at 4:41 pm
ScottPletcher (9/14/2012)
Not much.
Here's a quick script then:
-- Run this in one query window
USE tempdb;
GO
CREATE PROCEDURE dbo.Forever
AS
BEGIN
SET NOCOUNT ON;
WHILE 1 = 1
...
September 14, 2012 at 4:36 pm
ScottPletcher (9/14/2012)
September 14, 2012 at 4:29 pm
ScottPletcher (9/14/2012)
SQL Kiwi (9/14/2012)
My guess is that there is no special cache for definitions; the pages of sys.sysobjvalues are cached in the buffer pool just like the pages of any...
September 14, 2012 at 4:16 pm
ScottPletcher (9/14/2012)
September 14, 2012 at 4:08 pm
ScottPletcher (9/14/2012)
I never claimed they took space in the plan cache, as I made clear earlier.
The procedure cache and plan cache are two names for the same thing.
The original source...
September 14, 2012 at 3:44 pm
GilaMonster (9/14/2012)
Up for some more misconception correcting?
Sorry I had gone to bed. What a disappointing reply, "I never stated, or implied, that...". Good grief, we have all been...
September 14, 2012 at 3:20 pm
ScottPletcher (9/14/2012)
You do realize that comments still take up space in the proc cache, right?
They take up no space in the plan cache. The plan cache is the new...
September 14, 2012 at 3:15 pm
Viewing 15 posts - 241 through 255 (of 8,416 total)