The first hit on Google for the keywords sql server cpu bottleneck:

http://www.sql-server-performance.com/tips/performance_monitor_cpu_counter_p1.aspx

A little research won't harm you.

You should start a new thread for your question instead of hijacking...

Since your database is in full recovery mode, can't you take a tail log backup and do a point-in-time restore right before you deleted the data?

Good, but difficult question. I had to read quite some BOL pages to get this one right.

And only 1 point?

Brandie Tarvin (1/6/2011)

---

Jack Corbett (1/6/2011)

---

I also want to encourage all you who are PASS members to opt-in to the session voting for SQLRally. See my this post which has...

Thanks for sharing!

I thought this was a pretty accurate description:

😀 (an oldie but a goodie)

At first glance this seems like a situation that the MERGE statement could handle.

http://msdn.microsoft.com/en-us/library/bb510625(v=SQL.100).aspx

What have you tried so far? Any issues?

cengland0 (1/10/2011)

---

Koen (da-zero) (1/10/2011)

---

What kind of trigger? The question asks if it is possible with a trigger. So it is up to you to find out if there is a...

cengland0 (1/10/2011)

---

Got this one wrong because I didn't understand the wording of the question.

Is it possible, using a trigger, to update a data row before commiting the insert...

1) Usually you do the design in the database itself, using Management Studio. So you create the tables there and of course, while you create them, you give them names.

2)...

ALZDBA (1/10/2011)

---

Indeed, Antwerp was a mess this morning. Slippery roads and unadapted driving style causing "fun" traffic jams all over the place 🙁

Regarding the pastries, I was aiming for the...

Unfortunately I've never been in Zelzate before.

And "lost monday" is particulary popular in...

Tom.Thomson (1/9/2011)

---

?? :ermm:

Do you Americans work to 14th night instead of 12th ??

Or...