The profiler probably also asked you to update statistics. Always a good idea.

Yes, you are using the profiler correctly.

Patrick

Venting good.

We have several SQL Server databases and one system DBA and I'm helping out as a part-time Apps DBA. It takes a lot of coordination to keep everyone...

Frank -

Developers/Project Managers/DBAs all drink. My doctor once put me on a no caffeine, no alcohol diet. "Doc, do you know what I do for a living?"

Yes, I am...

How large are these temp tables? It sounds as if QA is selecting a table scan execution plan.

I recently used the table variable in a function and found it to...

Ah, sorry, the error is on the ID column, not the Spanish column.

What eljeffo said should be true.

Patrick

Also, just reading the message - your Spanish column has NULL values, but your column in db2 does not allow NULLs.

Is that true? If it...

My question is are you in charge of maintenance of this beast?

When someone else decides to use the table and basic commands fail who will they call? The developer?...

In the app, check what the join columns are. If you want to speed up queries you can index those columns. But there is a balance, because if you are...

Yes, if the drink is green that's probably not good for me. Good advice.

I drink a single malt, but in France I'll try cognacs. I'm not sure about French beers.

Patrick

I can out-drink the Irish? I doubt that also. I'll be in France later this year for a business seminar. I'll see what I can do there.

Patrick

Check the Execution plan in QA.

See if the stored procedure is using indexes, etc. Is this a select, update or delete statement? What are the indexes on the table?...

Markus -

You are right - in a heavily transacted database this would not be a good idea.

We discussed this in design mode and the table is not in that...

Another option is to use the templates in Query Analyzer. They would help with the formatting.

I would recommend something like "Professional SQL Server 2000 Programming" if you are just starting...

We use datetime when the majority of the queries run against the table will be based on a range of dates. It is the clustered index for that table and...

In a sense they (TECH ED) are right. Profiler is a developer tool, but it is not something they should run. You need to set up what events you want...