Viewing 15 posts - 16,366 through 16,380 (of 22,219 total)
The problem is, because the systems are radically different, as well as different versions of SQL Server, you're comparing apples to cannonballs. Best advice is what the post above says,...
"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
October 7, 2009 at 7:47 am
Follow the advice in Gails articles or pick up a book on performance tuning (<cough>, look down, <cough>). You need to gather metrics to identify where your bottlenecks are, 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
October 7, 2009 at 7:44 am
What about using VARCHAR(MAX) and use sp_executesql. According to BOL the @stmt parameter in sp_executesql is only limited by available memory.
"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
October 7, 2009 at 7:40 am
sys.dm_exec_query_stats is what I would recommend as well, but remember that it only shows the queries that are currently in cache. If queries have been executed during the day 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
October 7, 2009 at 7:38 am
You should be able to see the operations that are taking so much CPU within SQL Server. If nothing else, take a look at sys.dm_exec_requests to see what operations are...
"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
October 7, 2009 at 7:36 am
Are the other objects being referenced views or tables? You could start trying to figure out what's happening by looking at the actual execution plan for the query and 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
October 7, 2009 at 7:32 am
You'll be able to run three instances of SQL Server on this system, certainly. The question is, what will they be doing? How much data are you storing, how many...
"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
October 7, 2009 at 7:27 am
2Tall (10/6/2009)
"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
October 7, 2009 at 7:24 am
Or, instead of running in SSMS in sqlcmd mode (great idea, btw), just go and run the scripts in sqlcmd directly.
"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
October 7, 2009 at 7:14 am
Definately not. The key is the key is the key. Whatever you have as the primary key in the parent table, that should be the foreign key in the related...
"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
October 7, 2009 at 7:04 am
They almost describe themselves. A SQL Login is a login defined within the SQL Server system itself. It doesn't have existence outside of the SQL Server instance on which it...
"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
October 7, 2009 at 6:59 am
GSquared (10/6/2009)
"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
October 6, 2009 at 9:13 am
Lynn Pettis (10/6/2009)
Grant Fritchey (10/6/2009)
RBarryYoung (10/5/2009)
Now all I need to do is to keep this up for three years... And for at...
"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
October 6, 2009 at 6:53 am
Bob Hovious 24601 (10/6/2009)
But I haven't started using dinosaur names...
"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
October 6, 2009 at 6:51 am
RBarryYoung (10/5/2009)
Now all I need to do is to keep this up for three years... And for at least four people to...
"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
October 6, 2009 at 5:30 am
Viewing 15 posts - 16,366 through 16,380 (of 22,219 total)