Viewing 15 posts - 15,376 through 15,390 (of 22,227 total)
It really depends on the error you're getting. I was able to compile the procedure on my machine, but since I don't have your structures, I'm getting an error because...
"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, 2010 at 6:55 am
It does create a system index, that's how SQL Server maintains the unique values in the table. But, there are no statistics for the index, so it won't really be...
"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, 2010 at 6:48 am
chandrashekarthota (4/26/2010)
closing down my site for few weeks just because of plagiarism and I have
learned...
"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, 2010 at 5:27 am
tripower (4/23/2010)
I don't know what to say it is bringing back all of the estimates.
I'm not arguing, at all. I believe you.
You might try adjusting the WHERE cluase in 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 9:59 am
natalie.davies (4/23/2010)
I remember being very confused when having a look at one of the shiny...
"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:56 am
Shark Energy (4/23/2010)
Good call on...
"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:23 am
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
Viewing 15 posts - 15,376 through 15,390 (of 22,227 total)