Viewing 15 posts - 13,411 through 13,425 (of 22,219 total)
It's got to be something along the lines Gail suggests. I just ran through it and it creates a plan and stores it cache just fine.
Another reason you might...
"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 2, 2011 at 4:38 am
While I wrote my own code to defrag indexes (in the book, listed below), I really prefer Michelle Ufford's[/url] code. It works wonders.
"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 2, 2011 at 4:31 am
GilaMonster (2/2/2011)
Koen (da-zero) (2/2/2011)
Koen (da-zero) (2/2/2011)
This is a weird thread:http://www.sqlservercentral.com/Forums/Topic1057267-391-1.aspx
Ugh. If someone else wants to skip in on this thread.
Apparently English doesn't work...
Maybe gibberish?
Wht ru sng? DUDE, I gts teh...
"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 2, 2011 at 4:23 am
rob mcnicol (2/1/2011)
rob mcnicol (1/31/2011)
what tweaks to this process are required to run a server-side trace on analysis services? when i export my Script Trace Definition,...
"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 2, 2011 at 4:20 am
rjohal-500813 (2/2/2011)
Would you also need to simulate a similar server load? Could SQL Server choose a different plan under different load conditions?
But, thinking about it a bit more, of course,...
"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 2, 2011 at 4:18 am
rjohal-500813 (2/2/2011)
Would you also need to simulate a similar server load? Could SQL Server choose a different plan under different load conditions?
No, the optimizer is not monitoring the server. 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
February 2, 2011 at 4:17 am
You have only a few options. Triggers & CASCADE as you already know, or you have to write your code so that it updates both at the same time. You...
"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 2, 2011 at 4:14 am
sqldba_icon (2/1/2011)
Craig Farrell (2/1/2011)
You can also get a double entry when there are two plans because of parallelism. One will parallel split, one won't.
I need to check but could...
"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 1, 2011 at 4:40 pm
Here's a video on how to post an execution plan to SSC.
"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 1, 2011 at 3:29 pm
Absolutely.
I thought of another one too, you need to make sure you're using the same parameters in the test environment that you do in production. That will help to ensure...
"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 1, 2011 at 10:48 am
I was also going to suggest doing a complete rebuild of all statistics, preferably with FULL SCAN.
I know there are some areas where performance degrades on upgrading servers from 2000...
"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 1, 2011 at 10:26 am
Kwisatz78 (2/1/2011)
I am wondering about the accuracy of placing a copy of production into a test environment. If I do this will the query plans also be copied or...
"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 1, 2011 at 10:23 am
sql_butterfly (2/1/2011)
from T1 A
INNER JOIN (select Field1, max(FirstTime) AS FirstTime from T1
group by Field1) B
on A.Field1= B.Field1
and A.FirstTime = B.FirstTime
ORDER BY B.Field1, B.ImportantDate, B.FirstTime
Basically I'm...
"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 1, 2011 at 8:54 am
I didn't even notice that you were talking about UDFs. Assuming you're talking about multi-statement table valued UDFs, my best advice, avoid them like they have AIDS, because, effectively, they...
"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 1, 2011 at 8:23 am
If I were running the interview I'd want to hear a lot more than just that you'd taken the tail backup. I'd want to know which backups you had 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
February 1, 2011 at 6:30 am
Viewing 15 posts - 13,411 through 13,425 (of 22,219 total)