To continue where Sean left off:

Or at least add a CHECK constraint:

CHECK (NOT (len(isnull(AlternateName1, '')) = 0 AND (len(AlternateName2) > 0 OR len(AlternateName3) > 0) OR

len(isnull(AlternateName2, '') > 0 AND...

I don't really understand your question. Can you elaborate?

And to add to Jeff's and Gail's posts: restores. A lot of people take backups. Not everyone restore their backups, or understand how they should do in a disaster scenarios.

There...

There are no such procedures or functions exposed. The entire login sequence has a couple of packets of its on the TDS specification, and the verification of SQL logins are...

I don't really have any more ideas that I have offered previously (and in which I don't believe fully). Did you compare StartTime for the INSERT statement with the StartTime...

I don't think that this is a very...

Do you make the same observations, even if you do not include the showplan events in the trace?

I realiased that my post was a little terse, so I should try to qualify it a bit.

Say that you have a trace which captures SP:StmtCompleted. Say that you inside...

Can you attach your data files and your format files?

There is a bug in the SQL Server Central software, so that backslash-n is dropped from the posts, which has serious...

It's difficult to say exactly what is going on without access to the database, but there is an overhead of putting the rows for inserted and deleted to the version...

In addition to Sean's comment - you also help yourself by using a more descriptive subject line for your post. I've noticed that you've...

I am not sure why you would add 10000 stopwords. Stopwords are common words that are useless to search on. For instance words like "then", "for", "and". If you add...

The answer is that it depends on what you want to index. If you want to index texts stored as such, you use varchar or nvarchar. If you want to...

In your example, there is:

<frame line="457" stmtstart="56510" stmtend="56610" sqlhandle="0x03002b009fbde449363f36010ea200000100000000000000"/>

This can be translated to SQL code with

SELECT object_name(objectid),

stmt = substring(text, 56510/2, (56610 - 56510)/2)

FROM ...

When you add an index on a table, all query plans for that table are flushed from the cache and the queries are recompiled. If you have queries on the...