Viewing 15 posts - 18,331 through 18,345 (of 22,219 total)
samalex (2/18/2009)
Thanks for the replies... if you have a moment I have some questions now that I have VS2008 DB Edition installed and have been using it 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
February 18, 2009 at 5:53 pm
GSquared (2/18/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
February 18, 2009 at 5:46 pm
I assume with the code formatting we'll be able to put a semi-colon in the code without having to sweat getting smiley faces:
SELECT * FROM (SELECT * FROM dbo.MyTable);
"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
February 18, 2009 at 5:42 pm
We've been using it pretty extensively for years. Yeah, it pretty much takes over as a development mechanism on your databases. However, it doesn't replace SSMS. There's still stuff that...
"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
February 18, 2009 at 1:27 pm
Given my druthers, I go with a singular object name, but I've long ago stopped worrying about some of the silly stuff. This is especially true when we have people...
"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
February 18, 2009 at 12:48 pm
Chris Lane (2/18/2009)
Question
QuestionID PK
QuestionGroup Or Just Group? Group by itself seems to vague.
QuestionGroupID...
"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
February 18, 2009 at 12:30 pm
So, we have a Survey, a Question, and a Group? What's the Group do and how does it relate to both Question & Survey? It really depends on how 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
February 18, 2009 at 12:09 pm
skt5000 (2/18/2009)
Unfortunately, still at 30 secsJim
And are you still seeing parallelism in the execution plan?
There has to be something going on, something different. If you simply air drop a database...
"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
February 18, 2009 at 12:05 pm
just as an experiment, try using a query hint on the query itself to set the max degree of parallelism to 1, just to see. Use: OPTION (MAXDOP 1)
"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
February 18, 2009 at 10:40 am
I would. Is the old server a single CPU machine?
"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
February 18, 2009 at 9:11 am
The parallelism settings are a SQL Server level setting, not on the database. You'll need to look there.
Hardware always matters. If your database is really tiny, memory might not...
"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
February 18, 2009 at 9:07 am
distant star (2/18/2009)
I am working on an automation script using detach-attach method for which I need help of you colleagues.
Following is the plan which has to be executed using a...
"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
February 18, 2009 at 8:53 am
skt5000 (2/18/2009)
nameminimummaximumconfig_valuerun_value
max text repl size (B)0214748364721474836472147483647
and the old is set at 65536....
"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
February 18, 2009 at 8:50 am
Are the parameters the same for each execution?
"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
February 18, 2009 at 8:13 am
Yeah, sorry, guess I should have said that too. There's nothing wrong with Express. It allows for less memory and fewer CPU's, but it will use the memory & cpu...
"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
February 18, 2009 at 8:10 am
Viewing 15 posts - 18,331 through 18,345 (of 22,219 total)