Traditionally it's considered bad form to hijack someone elses question. Also, when you do this, the only people that are aware of the new question are those that are already...

It really depends on what the error is. Not all errors cause a loss of connection, so you'll still see the RPC or Batch completion event.

Profiler isn't necessarily the place...

You can make the data file any size you want, but then it will consist mostly of free space. Right click the database and check the properties. That's an easy...

NOLOCK is what is known as dirty reads. It prevents shared locks from being placed on data. This can speed up access. BUT, it also means that you can get...

If the calculation is really simple, say adding two columns, then no, storing it doesn't really make sense, but if the calculation is complicated, then it makes more sense to...

rafael_si (5/20/2010)

---

Thanks a lot for you reply. I was thinking that "schemabinding" had something to do with index use becase I can't create an cluster index (sql server 2005) without...

mtassin (5/20/2010)

---

Grant Fritchey (5/20/2010)

---

I'm sorry to disagree with you here, but dynamic queries do get cached. And if you build them using the parameterized approach, they can get reused too....

It depends on the query and your goal. SCHEMA_BINDING and indexed views are different critters. An indexed view is, effectively, a second table because the query that defines it is...

I guess I'm still confused by what you're trying to do. In SQL Server 7,2000,2005,2008, (and I'd say 6.5, but I don't remember it that well) if you are trying...

When I run this:

SELECT * FROM dbo.a;

exec sp_rename 'A' , 'C';

exec sp_rename 'B' , 'A';

exec sp_rename 'C' , 'B';

It works fine, with no blocking.

Are there multiple connections running this at...

I may be wrong here, but this:

ISNULL(pe.Col3, pe.Col4)

is going to cause scans, either table or index, and you won't get seeks. Functions on columns like this render them non-sargeable (search...

You should not be using ROWLOCK like that. There is no way to make a single row read only within the structure of the table. You have to make it...

Check out this article[/url]. It'll get you started.

You're trying to join on NULL. You can't. NULL does not equal NULL.

What's the purpose of the trace? Do you just want to see that they started? Then I'd use the RPC or Batch Start event. If you're trying to see specifically...