Viewing 15 posts - 15,361 through 15,375 (of 22,219 total)
From the sounds of it, the tables aren't terribly well normalized. This means you're going to be moving a lot more data around every time you want to do updates...
"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:29 am
And if you really want someone to begin to evaluate the effects of your code choices on the structure, bare minimum, you need to include the actual execution plan, but...
"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:25 am
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
Viewing 15 posts - 15,361 through 15,375 (of 22,219 total)