Viewing 15 posts - 16,231 through 16,245 (of 22,226 total)
The Red Gate database documentation tool, SQL Doc, will do it I think.
The problem is, it's really easy to get a circular reference. All you need is a set of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 29, 2009 at 4:55 am
Bob Hovious 24601 (10/28/2009)
Come to think of it, I need to get...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 29, 2009 at 4:33 am
CirquedeSQLeil (10/28/2009)
No Pass this year (much like Jeff). However I was able to swing SQL Connections in Vegas :w00t:
Look me up in Vegas. I'm presenting there as well.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 28, 2009 at 4:52 pm
GilaMonster (10/28/2009)
CirquedeSQLeil (10/28/2009)
Anybody know anything more about it, opinions or otherwise?
I know a great deal about it. Would you be interested in my highly biased opinion? (I'm one of the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 28, 2009 at 4:23 pm
Roy Ernest (10/28/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 28, 2009 at 4:21 pm
Thanks for posting what worked. It's always good to know and it helps people who find the thread later.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 28, 2009 at 8:45 am
From a performance standpoint that's a fairly wide clustered index. I sure would hesitate to make it wider, but the best way to fix it would be to add something...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 28, 2009 at 5:30 am
If you can't trust your hosting organization, you need to get a different one. Those guys should be lawyered up to the max and under 17 layers of NDA. If...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 27, 2009 at 7:42 pm
Bob Hovious 24601 (10/27/2009)
I stumbled into it, but that's just because I'm willing to go stumbling around in the dark. 😉
Well now that I can do, but I usually...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 27, 2009 at 7:38 pm
I'm game. I don't care what I program in. My issue, and it's been my issue for a while, is that the "replacements" for SQL don't seem to be attempting...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 27, 2009 at 7:09 pm
Bob Hovious 24601 (10/27/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 27, 2009 at 7:03 pm
Is that primary key dependent on a datetime or time field? You could be getting duplicate values during the insert under high loads.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 27, 2009 at 1:15 pm
Excellent! Thanks for reporting back what worked.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 27, 2009 at 11:05 am
You might want to try setting up a server-side trace. That will allow you to capture all the calls against the database. Another option is to look at SQL Server...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 27, 2009 at 8:37 am
Jeff Moden (10/27/2009)
Bob Hovious 24601 (10/26/2009)
Really sorry to hear that, Jeff.(Say... are you going to finish the rest of those pork chops..... ??)
Now THAT's funny! :-P...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 27, 2009 at 7:41 am
Viewing 15 posts - 16,231 through 16,245 (of 22,226 total)