I'd suggest running Profiler and either capturing or generating execution plans for the longest running queries. You might also take a look at the dynamic management view dm_db_missing_index_details, *_Group_stats, *_Groups....

Is this part of a bigger batch?

I fiddle around with a bamboo flute, but honestly, I can't carry a tune in a bucket.

On my team, of 14, we have one musician (not counting my screetches). So...

Last question, the columns are dependently or independently overriden? Meaning, if you override one, you may override another at another time, but those overrides are not related? By putting them...

The attempt to insert a row incremented the value. It then rolled back because of the constraint violation, but the increment remained. Identity fields will increment, but they don't guarantee...

We're going through similar circumstances. Look around the site here at some of the discussions on Object Relational Modeling, Hibernate, nHibernate and LINQ. I also posted some of my research...

Notice the topic heading: "Anything that is NOT about SQL"

You should repost this in the 2000 or 2005 General discussions.

It sounds like the database is still a publisher and is...

I'll bet attendence goes down slightly if you charge. I'm good with it. I think it's a fine idea even, but I do think a few less people will show....

Best of luck on speaking Gail. I've submitted two abstracts this year as well.

Outstanding.

Not only does it remind me of WAY too many of the projects I've worked on, it also reminds me of WAY too many trips with the kids.

Speaking as a PASS volunteer who will (hopefully) get comped on admission, I'd be willing to both pay a fee AND forego prizes in favor of those who registered through...

Are the columns individually overridden? If so and you're planning on storing a sparsely populated table, I sure hope you don't have do searches on the data. Without the filtered...

It sounds like you may be on the right track. Just remember that Profiler is only going to show you what happened, not what could happen.

You could use Profiler to capture the actual execution time.

There's no way to know in advance how long a query will take. You can look at an execution plan for the estimated cost, but because of I/O contention, CPU,...