Viewing 15 posts - 12,631 through 12,645 (of 22,224 total)
Steve Jones - SSC Editor (4/28/2011)
I posted a note about understanding your access patterns for data, meaning hitting tables...
"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 28, 2011 at 12:25 pm
One, you're posting in the SQL Server 2005 forum. You might want to take this question to that forum.
Two, the old SQL Server software had a mechanism for generating scripts...
"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 28, 2011 at 8:18 am
Depends. Do you want to just do it, or do you want to do it programatically? If you just need a script, right click on the database, select Tasks and...
"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 28, 2011 at 8:05 am
spadavala82 (4/28/2011)
The Data base Schema will never decreases the Query Performance. If you are not mentioned the schema when you are executing the query check the execution time, and...
"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 28, 2011 at 7:41 am
From the error, I would assume that you have a value that is not numeric stored in that column.
"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 28, 2011 at 5:12 am
Tempdb is used by so much it's hard to list it all. I suppose if you had terrabytes of memory and gigabytes of data you might not see tempdb used...
"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 28, 2011 at 5:09 am
I can't see that exec plan. When I opened it I got chinese characters.
"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 28, 2011 at 5:05 am
It does depend on how you define "schema." I would include picking the clustered index as a fundamental part of database design and that certainly affects performance. Also, primary keys...
"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 28, 2011 at 4:54 am
I had a system where we ran a basic query trace 24/7 for years. Other than dealing with the data that came out of, there was no real issues there...
"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 27, 2011 at 11:29 am
David Egnoski (4/27/2011)
"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 27, 2011 at 9:55 am
Not sure, I'd have to see the scripts that were run and what modifications you made and how you made them. Are you sure you were connected to the correct...
"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 27, 2011 at 9:50 am
Nothing you ever do on a server is free. Yes, it impacts performance, but not very much at all. It should only take out some shared read locks on system...
"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 27, 2011 at 8:57 am
There have been tests, and you can search for them online, that show that a well defined clustered index speeds up inserts over and above having a heap table. I...
"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 27, 2011 at 8:20 am
GilaMonster (4/27/2011)
Grant Fritchey (4/27/2011)
Where was the company store located again?Cambridge? Or Denver?
With all your points I figured you'd just buy the store and move it down to SA to force...
"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 27, 2011 at 8:18 am
You need to look in the project properties for the database. It's set to recreate the entire database. You can have it do incremental builds. This article[/url] is a bit...
"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 27, 2011 at 8:03 am
Viewing 15 posts - 12,631 through 12,645 (of 22,224 total)