Viewing 15 posts - 15,376 through 15,390 (of 22,232 total)
SQL Server 2008 R2 is an incremental release, primarily focused on BI.
The next full version of SQL Server is due out in 2011, but I wouldn't count on it until,...
"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 7:22 am
I'd start off with the Books Online. It covers a very large swath of this material right off the bat. After that, do a search on MSDN. Any time you're...
"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 7:16 am
First, the advice to use ALTER INDEX is correct. But, just a point of clarification, DBCC DBREINDEX does support schema's. It just doesn't support the ability to run across databases....
"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 7:06 am
Or it could simply be blatant misuse of temporary tables. You reall need to get a look directly at your code to try to identify the issues.
As a starting point,...
"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 7:03 am
Can you get the information running this query?
SELECT CONVERT(sysname, SERVERPROPERTY('servername'));
If not, you may have an issue with the server, it's configuration, your connections... not sure.
"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:59 am
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
Viewing 15 posts - 15,376 through 15,390 (of 22,232 total)