Here's another interesting reference (this is the one that I found when researching the question):

http://sqlstudies.com/2013/08/26/the-effect-of-vlf-size-on-shrinking-the-log/%5B/url%5D

gerry anderson (11/22/2013)

---

I gave the example a try, mychar LIKE '[a-z]dam' returns only Bdam. While mychar like '[A-Z]dam' returns Adam and Bdam. Is this a result of the...

The question did provide me with an opportunity to research. I am normally quite uninterested in these options - have not used them ever, and know that they have been...

L' Eomot Inversé (11/9/2013)

---

Of course this may be all screwed up by the existence of indexes that the optimiser may decide are better to use than the tables themselves, which...

I worked it out in my head, got it right, then ran the query on my system and got a different result: error in query. On my system NAME and...

L' Eomot Inversé (11/4/2013)

---

the explanation is wrong even when there is no join. It is unlikely that there will be a "unique sort", because there is no need for...

steve.jacobs (11/4/2013)

---

twin.devil, you stated it perfectly, it is a trap...

Hi Razzgor,

Thanks for posting the plan. Like I said, I'm not a spatial expert - but I do know a fair bit about plans. So let's start with some generic...

I am not an expert on Spatial data, but I do know a few things:

* The reply by Ville-Pekka is incorrect. I think he is confusing two features. Indexed views...

I almost got it wrong - noticed just at the last moment that the savepoint and one of the transactions have the same name. For the record - giving savepoints...

PHYData DBA (10/22/2013)

---

Hugo Kornelis (10/22/2013)

---

Yes,...

Yes, it will. You are...

crussell-931424 (10/21/2013)

---

I can't win on these. If you read it exactly as it is written then people complain that we should have understood what the question was really asking in...

A good question. I missed my point, because I once again made the mistake of trusting the documentation.

http://technet.microsoft.com/en-us/library/ms181647.aspx says that if sp_recompile specifies a table or view, all the stored...

From the article:

Actually, no. I...