Viewing 15 posts - 10,981 through 10,995 (of 22,219 total)
Just remember that this is only going to show the executions since the last time a given query was loaded into cache. Recompiles or aging out of cache will change...
"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
April 27, 2012 at 6:41 am
I'm not so sure I'd use a trigger. Those things are notorious performance and maintenance headaches.
What about using the OUTPUT clause. You can output the IDs generated from an INSERT...
"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
April 27, 2012 at 5:08 am
Just a different technology set. Go for it.
And, if there isn't a MySqlServerCentral, you get to go and create it. Although you might want to change the name.
"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
April 27, 2012 at 5:05 am
Data growth? Additional resource use leading to contention? Do you have memory, cpu & IO tracking over the same two time periods to compare how the whole system was behaving?
"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
April 27, 2012 at 5:02 am
There's no need for proof. It's right there in the SQL Server documentation as provided by Microsoft, the people who wrote the software.
"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
April 27, 2012 at 5:00 am
Retire? What's that word mean?
I'll be a geek til the day I die. If I'm lucky, I'll get paid for it most of the way.
"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
April 27, 2012 at 4:47 am
danaanderson (4/26/2012)
"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
April 27, 2012 at 4:38 am
20,000 rows is not that much. Even tripling it to 60,000 rows is still not much. Returning four columns doesn't mean much because I don't know the data types 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
April 26, 2012 at 1:21 pm
If FK3 is used in queries where the other two columns are not referenced in either JOIN criteria or WHERE clauses, then yeah, it might benefit from a nonclustered index....
"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
April 26, 2012 at 1:17 pm
Larry Page(Ehsan.Akbar) (4/26/2012)
Mark Fitzgerald-331224 (4/26/2012)
Larry Page(Ehsan.Akbar) (4/26/2012)
Grant Fritchey (4/26/2012)
Larry Page(Ehsan.Akbar) (4/26/2012)
Grant Fritchey (4/26/2012)
Larry Page(Ehsan.Akbar) (4/26/2012)
Grant Fritchey (4/26/2012)
"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
April 26, 2012 at 10:53 am
There are a bunch of ways ot tell what version of SQL Server you have. Microsoft has them documented here. The best is to query directly:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY...
"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
April 26, 2012 at 10:22 am
Larry Page(Ehsan.Akbar) (4/26/2012)
Grant Fritchey (4/26/2012)
Larry Page(Ehsan.Akbar) (4/26/2012)
Grant Fritchey (4/26/2012)
"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
April 26, 2012 at 7:45 am
Thomas Stringer (4/26/2012)
Great information and summary, Grant.
Thanks. I've had a little practice laying out that information though, so it's not that big an accomplishment.
"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
April 26, 2012 at 7:44 am
I found a bug in AlwaysOn. Anyone want to vote on it?
"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
April 26, 2012 at 7:43 am
Looks like it's a bug. I just submitted this on Connect if you want to go vote for it.
"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
April 26, 2012 at 7:39 am
Viewing 15 posts - 10,981 through 10,995 (of 22,219 total)