The tool isn't the problem, the way people use it is. In my experience, 'moronic' activities in databases are more...

Jeff Moden (5/19/2012)

---

IMHO, hash partitioning isn't just a waste of time, it's a move in the wrong direction. You're adding complexity to make things worse. It's kind of...

Surprising answer. I had no clue so guessed (wrong).

mtassin (5/18/2012)

---

When you use Primary Key with no other qualifiers in a create table statement several things happen.

1. The column is immediately flagged as NOT NULL

2. A Clustered Index is...

bitbucket-25253 (5/17/2012)

---

Well my answer was declared to be incorrect, so went to read the explanation, following the link given ..... nada / nothing / not a word to support what...

Lynn Pettis (5/19/2012)

---

I can see this discussion going on forever. I think it is time to stop as it is quite apparent that the author is not going to be...

Highlighting (and the CTRL+] shortcut to switch between braces at the same level) is only functional when the built-in IntelliSense is enabled. This can be an irritating restriction if...

I see you asked the exact same question on SQLteam:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=174825

The reason you are getting an error with the VALUES clause on that thread is because you are not running SQL...

Possibly a small improvement:

CREATE TABLE #TableA

(

UserID integer NOT NULL,

LastName nvarchar(50) NOT NULL,

...

The sample data you provided has a number of problems. DtAdded is the same for every row. There is no row 11 (specified in the results). To...

Gullimeel (5/19/2012)

---

MINDOP : If i get you right you would like MINDOP to be used so that query will be execute only if it could use a parallel degree equal...

Well you have the memory grant reported in an 'actual' execution plan, and the DMV (while the query is executing). The extra information might be useful for some...

The DMV provides a number of runtime performance metrics to compare (e.g. elapsed time, processor...

That's exactly right. Interestingly (though not usefully!) you can tell the...

gemisigo (5/18/2012)

---

Thanks for the thorough explanation, Paul. Finally, we've got an answer for both 'where' and 'why'. As this is only used in a development tool and it's quite salient...