sjimmo (12/2/2010)

---

Once again, since there is not a field for comments about the object, how can you say that comments are returned? The truth of the matter is that the...

Bad question.

To me, the author was seeking to see whether we think that the comments are stripped out during compilation and only "true" code is saved in the text column,...

Iulian -207023 (11/18/2010)

---

One innocent remark that does not minimize the high value of the question. I am thinking to drop tbl1 and tb2 tables at the end of the script:

DROP...

Here's a weird situation where having a clustered indexed view was a life saver --

At my last job, we had a table that stored notes for claims. This table...

mojo-168709 (11/15/2010)

---

Using the code supplied, I got this result:

-- uspPrintError prints error information about the error that caused -- execution to jump to the CATCH block...

It is correct to say that removing the GO between the EXEC call and the SELECT against the DMV changes the behavior. Clearly there is some caching going on...

cengland0 (11/9/2010)

---

Not saying it's a grammar mistake. ...

Jeff Moden (11/1/2010)

---

What I'm even more concerned about is lost learning due to the fact that certain programs and formats are no longer available. Imagine, for instance, if someday...

Eric Russell 13013 (10/25/2010)[hrIn the event of a merger, new primary keys conforming to the parent company's database schema are assigned as transactional records are migrated over. For example, a...

Thomas-282729 (10/24/2010)

---

Robert Frasca (10/12/2010)

---

Other than for merge and updatable transactional replication, I've yet to hear an argument as to why an identifier has to be globallyunique. Sure, it sounds...

Another issue that is milder but chafes me is the concept that the PK field is usually the clustered index. Certainly this is default, and certainly this sometimes makes...

Hugo Kornelis (10/22/2010)

---

I got it wrong. I blame my total lack of interest in the R2 release.

But a quick question - if Multi-Server Administration was a new feature in SQL...

I thought that we were supposed to stop using the xps as they were going to be deprecated....?

You COULD use one maintenance plan with 3 tasks inside, but yes, you will need three separate tasks. T-SQL is not appropriate for manipulation of files; you almost would...

PaulB-TheOneAndOnly (10/15/2010)

---

Steve Jones - SSC Editor (10/15/2010)

---

I would have thought so, but if people entered data in a new system, you can't restore without losing that data. So you need...