Viewing 15 posts - 15,376 through 15,390 (of 22,221 total)
dtipser (4/23/2010)
If you are running SQL Server 2008 64 bits on Windows 2008 64 bits the advanced properties shows as in attachment file.
How did you get the advanced properties for...
"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:21 am
Steve Jones - Editor (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 9:19 am
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
Viewing 15 posts - 15,376 through 15,390 (of 22,221 total)