Yet another option is to look at the execution plans. sys.dm_exec_cached_plans has a column usecounts that shows how many times a plan has been used. This won't be perfect because...

And do a search on the site here. There are a bunch of useful articles and scripts on this topic.

1. Answered

2. It depends on the database recovery mode. If it's in simple recovery, there's nothing for you to do because the log is being flushed of all committed transactions...

You can't delete multiple tables at once. Each table will get deleted individually. However, you can use a select statement and joins to determine the data to be deleted. This...

You have to log in to your work network, usually through a Virtual Private Network (VPN) connection. Once you're connected to your work network, you access the server the same...

I've only started testing filestream but, other than what Gail has already outlined, there are no other restrictions on columns in the table. That's a big part of the idea...

Although, with the ordered guid introduced in 2005, you can get a lot less rearrangement if you put the guid into a clustered index. It's still a bit wide. There's...

Another vote for jumpstarttv. I did a bunch of work for Andy on a series of videos introducing execution plan concepts. There are going to over 500 videos there by...

NPR did a report on it several weeks ago. According to the report the show has a pretty firm basis in reality, but instead of a few people in one...

Yeah, open the query plan you posted. It's right there on top, including all the syntax except the query name to create it.

Here's the code (I used SQL 2008 to...

No, you can't index a query (per se), but it's suggesting an index on the table within the query. That bookmark lookup is costing you. If that index, with the...

The bookmark lookup on TRNDTL_BTS08 is chewing up 90% of the cost of the query. The actual update changes a single row (according to this execution plan) but it has...

PeterG (9/15/2008)

---

bskt_skudtl has 650k rows. the specific week i am updating has approx. 17k rows.

The table i am retrieving from (trndtl_bts08) has 150mil rows.

i know how to display...

Matt Miller (9/15/2008)

---

Make sure to go after the multi-threaded aspect of testing. Meaning load-testing with single threads or single connections won't show some of the real uglies out there...

Jeff Moden (9/15/2008)

---

Heh... must be a parallel universe... going through the same thing just now. Our guys are writing a bunch of ETL using C# because they think it's...