Lynn Pettis (12/22/2008)

---

On this note, it should be known that...

RBarryYoung (12/21/2008)

---

Robert Frasca (12/21/2008)

---

Different kinds of types. Now we're playing a little loose and fast with the Queen's English. 🙂 (They are synonyms.)

...

I believe they are...

RBarryYoung (12/21/2008)

---

Ah yes, typology is always good for a donnybrook or two...

Well, I got it wrong, but I am going to go with Steve on this one. The issue...

Steve Jones - Editor (12/19/2008)

---

We can argue about whether an indexed view should be a type of index or not, but right now MS is choosing to call it that....

GilaMonster (12/19/2008)

---

Heap, no. It doesn't have the b-tree structure, it's not an index.

Don't forget spatial indexes...

Hi folks,

Sorry, I can't agree with this. Just because it's listed in the documentation under a column labeled "index type" doesn't make it so. An indexed view is...

Didn't declare @tablename.

The transaction log exists to maintain database integrity regardless of the recovery model. If you start a backup and then start an intensive set of update transactions then the...

PaulB (10/16/2008)

---

Okay... lets try to get to the bottom line on this stuff.

You should create a PK when you want to have RI enforced.

If you want to enforce uniqueness an...

Don't mean to be fussy but a table can have a PK and be a heap table. A table without a clustered index is part of the heap. ...

I've followed this debate with interest but I'm afraid that Paul has not convinced me. I want to be able to uniquely identify every row in my database for...

They're both "local" in the sense that they're on the local machine versus online. Specifically, they're both in the SQL_Server_install_path\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\FTDATA directory by default.

This is out of SQL...

The term "local" thesaurus isn't really accurate. There is a language-specific thesaurus and a global thesaurus. Both are "local".

I guess I'm a little hazy on the difference between "information" and "data".:)

Seriously, the proper answer probably should be msdb. My presumption is that he was trying...

By the way, I learned about the technique for generating the trace script I described in my earlier post from a presentation by Andy Kelly at the New England SQL...