Tom.Thomson (5/25/2011)

---

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...

Tom.Thomson (5/18/2011)

---

SanDroid (5/18/2011)

---

Carlton Leach (5/18/2011)

---

Another bug vote here, and another wrong answer for me.

NULL is NULL...fullstop. You never know what NULL is so regardless if you insert, concatenate, stick it...

DugyC (5/24/2011)

---

SanDroid (5/23/2011)

---

After reading this post I went to MSDN online and pasted into the search tool....

So apparently not only...

GilaMonster (5/23/2011)

---

It's more correctly called the 'plan cache' these days. It used to be called the procedure cache, but since it doesn't just store the plans of procedures, the name...

Thanks so much for a nice clear and easy Monday style question! 😉

Peter Trast (5/23/2011)

---

The first table on this linked page suggests the answer I picked (incorrectly). I need to understand this better:

http://msdn.microsoft.com/en-us/library/cc949109(v=sql.100).aspx

The article by Paul has not sufficiently illuminated it for...

jeff.mason (5/20/2011)

---

Richard M Karpel (5/20/2011)

---

If the data is store outside the database this is true but according to the white paper found at http://msdn.microsoft.com/en-us/library/cc949109%28v=sql.100%29.asp Then the limitation does exist...

bugslayer (5/20/2011)

---

Any unexpected user interaction results in errors or false results. In addition, because the product is developed "in secret" without any user inspection throughout the process, the final...

I agree with the other persons that have posted and stated that today Code Projects have application requirements, end user requirements by roles, programing bugs, and end user issues.

With todays...

patla4u (5/19/2011)

---

Thanks

I have used fast load in OLE DB destination and it;s very fast. It will take only 2 min.

Can i know what is exact differece between (Tables and view)

and...

Nice easy and clearly defined two point question! :w00t:

Thanks Steve!

Guess we won't have hundreds of posts arguing the validity of the answer, the sanity of the behavior, or anything else...

LOL... 1974 might be closer to the time.

Or even 1989 when C89 came out...

It...

When...

Nice question and good explination in the Answer...

You Kept it Super Simple!

Funny True Story: While explaining the need to replace Log Shipping with DB Publishing for some Federated Database servers...

jeff.mason (5/18/2011)

---

If you want that sort of functionality, embed the second string in a ISNULL call to replace NULL with an empty string. That's easy, takes no cycles...