Viewing 15 posts - 20,386 through 20,400 (of 22,197 total)
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....
May 15, 2008 at 5:38 am
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...
May 15, 2008 at 5:28 am
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...
May 15, 2008 at 5:23 am
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...
May 14, 2008 at 1:34 pm
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...
May 14, 2008 at 11:44 am
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...
May 14, 2008 at 8:02 am
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....
May 14, 2008 at 7:41 am
Best of luck on speaking Gail. I've submitted two abstracts this year as well.
May 14, 2008 at 6:40 am
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.
May 14, 2008 at 6:26 am
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...
May 14, 2008 at 6:15 am
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...
May 14, 2008 at 5:40 am
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.
May 14, 2008 at 5:34 am
You could use Profiler to capture the actual execution time.
May 13, 2008 at 6:39 am
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,...
May 13, 2008 at 6:12 am
Viewing 15 posts - 20,386 through 20,400 (of 22,197 total)