Viewing 15 posts - 5,866 through 5,880 (of 7,484 total)
SanDroid (5/25/2011)
GilaMonster (5/25/2011)
If the table is partitioned, lock escalation will be allowed to partition. After the lock is escalated to the partition level, the lock will not be escalated later...
May 25, 2011 at 9:31 am
michael.kaufmann (5/25/2011)
Tom.Thomson (5/25/2011)
But "partition" locks? Surely Heap locks, B-Tree locks (HoBT locks for short)? I don't think the term "partition lock" occurs anywhere in BoL...
May 25, 2011 at 5:23 am
Nice question.
But "partition" locks? Surely Heap locks, B-Tree locks (HoBT locks for short)? I don't think the term "partition lock" occurs anywhere in BoL for SQL...
May 25, 2011 at 3:15 am
SanDroid (5/24/2011)
Tom.Thomson (5/18/2011)
SanDroid (5/18/2011)
Carlton Leach (5/18/2011)
NULL is NULL...fullstop. You never know what NULL is so regardless if you insert, concatenate, stick...
May 24, 2011 at 10:38 am
forsqlserver (5/24/2011)
What is the difference between query plans and compiled batch plans?
"query plans" includes compiled stored procedure plans as well as compiled batch plans.
May 24, 2011 at 6:55 am
crookj (5/23/2011)
Ray K (5/23/2011)
WOTD: WOTD.(Yes, in other words, WOTD is today's WOTD!)
WOTD: QOTD 😀
Joe
QOTD: Is QOTD a WORD as in WOTD?
May 23, 2011 at 11:26 am
SQLRNNR (5/23/2011)
GilaMonster (5/23/2011)
Jack Corbett (5/23/2011)
Just because I've touched it doesn't mean I'm an expert.It doesn't? Really?
😉
Wish more people thought that way.
No experts are those who have heard of...
May 23, 2011 at 11:22 am
Greg Edwards-268690 (5/23/2011)
If you want feedback, I could run this by a coworker or two.Kind of applies to our job, building the data warehouse. 🙂
Or that's the theory....
If you...
May 23, 2011 at 11:15 am
Nice question.
But it could have been turned into a real nightmare by having another option "plan cache" as (here) and still requiring a single answer. Or into an even...
May 23, 2011 at 6:42 am
GilaMonster (5/23/2011)
Now this is funny...http://blog.jitbit.com/2011/05/what-if-drivers-were-hired-like.html
Yes, true-to-life always makes the best humour.
May 23, 2011 at 6:36 am
Jan Van der Eecken (5/22/2011)
@tom, how is your article (series) on Normalization going?
I sent the first one to Steve a while back, waiting for feedback - 1NF is the...
May 22, 2011 at 11:54 am
GilaMonster (5/20/2011)
May 21, 2011 at 8:05 am
Nice question; the 8.3 naming red herring made me think hard.
May 20, 2011 at 5:19 am
mister.magoo (5/19/2011)
[rant]This takes the biscuit http://www.sqlservercentral.com/Forums/FindPost1112017.aspx
[/rant]
Having read that, I'm tempted to belive that he was intending to take something else as well as the biscuit.
May 20, 2011 at 5:01 am
Viewing 15 posts - 5,866 through 5,880 (of 7,484 total)