For info on execution plans, there's a great book available from redgate (free when you download an evaluation of any of their tools) on reading execution plans.

Or you can...

Anirban Paul (8/20/2008)

---

Training definitely has its value but lot of companies (Read Management) do not keen of providing quality training to their people. One because of cost and second beacuase...

It's a simple text file and will open in...

I think the problem is those 00000000 values. They aren't convertable to datetime.

Try this

update tablename set newcolumn=CAST(oldcolumn AS DATETIME) WHERE ISDATE(oldcolumn)=1

A couple people already have.

As I said, back in my reply to your first...

There aren't before triggers in SQL Server. Look up the Instead Of trigger in Books online for the other kind of trigger.

Here's a link to the other thread.

http://www.sqlservercentral.com/Forums/FindPost554864.aspx

Ashwin: It's prefered if you don't create multiple postings on the same subject, as it tends to result in people spending time answering questions...

How are you viewing the number of work tables created? Perfmon?

Work tables are created by the query processor in order to process certain query constructs (sorts, hashes, I think spools,...

Glad to hear you came right.

@@Error is what you're looking for.

One thing to be careful of is that @@Error contains the status of the last statement. Every single statement within SQL (including things like...

The account that's used to start SQL isn't the one that SQL runs under. If you go into the SQL Server configuration manager you can set the account that SQL...

Great. Can you post the table's create statement, the index definitions and the query itself please?

if you're using SQL 2005, right click the exec plan, choose save as. Save the file as a .sqlplan...

Yes, and the index creation scripts would also be useful please.

gohsiauken (8/19/2008)

---

I have anohter question about trigger, does SQL server has AFTER [Insert, Delete]? Examples as

CREATE TRIGGER Product_tUpdateAfter800

on dbo.Product AFTER update

CREATE TRIGGER Product_tInsertAfter800

on dbo.Product AFTER Insert

CREATE TRIGGER Product_tIDeleteAfter800

on dbo.Product AFTER...