Viewing 15 posts - 15,376 through 15,390 (of 22,219 total)
tripower (4/23/2010)
Grant Fritchey (4/23/2010)
SELECT...
FROM Contractor INNER JOIN
...
"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 23, 2010 at 9:00 am
Adam Bean (4/23/2010)
It turns out that the label is very confusing. There is a bug filed on it in the SQL bug database and it will hopefully get fixed...
"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 23, 2010 at 8:54 am
Jason Shadonix (4/23/2010)
"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 23, 2010 at 8:23 am
Lynn Pettis (4/23/2010)
Just checked one of my SQL Server 2008 installations, same thing as yours. Interesting. I think this requires more research, just not right now.
I'm sure I'm...
"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 23, 2010 at 8:15 am
Adam Machanic (4/23/2010)
"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 23, 2010 at 8:10 am
Paul White NZ (4/23/2010)
Grant Fritchey (4/23/2010)
"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 23, 2010 at 8:07 am
dmoldovan (4/23/2010)
Select the events and other trace properties in the GUI, start the trace, immediately stop it and select File ---> Export. This way you'll obtain 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
April 23, 2010 at 7:45 am
tripower (4/23/2010)
SELECT [Contract].ProjNumber, [Contract].Description, [Contractor].[Name], [Contractor].City,
MIN([Estimate].Estimate) as "Lowest Estimate"
FROM ...
"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 23, 2010 at 7:42 am
Notice how both rows have the same index_id. There's only one index there. A row is returned for each level that the index has in the B-Tree. Here's an MSDN...
"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 23, 2010 at 7:36 am
Paul White NZ (4/23/2010)
Grant Fritchey (4/23/2010)
INSERT INTO dbo.x (x.nodatetime)I never knew you could specify a table alias (x) in the INSERT column list...how interesting.
Yeah, I didn't either. It was a...
"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 23, 2010 at 7:15 am
What does the execution plan look like?
"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 23, 2010 at 7:12 am
That's not a standard TsQL function, so you must have written it. Without the code, it's hard to know what's happenning. If you post the code for the function, you...
"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 23, 2010 at 7:11 am
It sounds like you must have the trace events set up wrong.
BTW, you shouldn't run Profiler directly against production systems, especially if it's a system that is already experiencing performance...
"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 23, 2010 at 7:09 am
Of course it's going to show a connection problem. You can't connect users when the license is exceeded.
But as Gail says, this won't cause performance issues on 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
April 23, 2010 at 7:07 am
The Dixie Flatline (4/23/2010)
What I can't understand is why some people think that 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
April 23, 2010 at 7:05 am
Viewing 15 posts - 15,376 through 15,390 (of 22,219 total)