Viewing 15 posts - 13,486 through 13,500 (of 22,219 total)
We haven't run into anything either. Check the documentation on Microsoft's web site to see what is being changed. Run tests on it prior to running it in production. That's...
"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
January 26, 2011 at 7:49 am
You have to make a choice. What does an empty string mean as an integer? Is it NULL? Is it 0? You have to supply something because a number can't...
"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
January 26, 2011 at 7:48 am
If you only need the list of UKEY, why are you selecting all the other columns?
Not having all your code to understand completely what's going on, I may get this...
"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
January 26, 2011 at 7:28 am
The only suggestion I can make is to start using Roles within the database in addition to AD groups. Yes, if the AD server goes offline it can and does...
"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
January 26, 2011 at 6:11 am
It doesn't make any sense that the time would vary, a recompile fixes the time, but you're looking at identical execution plans. Based on the situation you describe, the exec...
"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
January 26, 2011 at 6:02 am
There's no way to directly manage the size of cache. If that's all the cache that is getting used, that's all SQL Server needs. I'd double check to be 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
January 26, 2011 at 5:57 am
Hey, whoa! If you take away the phrase "It works on my machine" you've just eliminated 2/3 of any conversation I have with developers. What are they supposed to say...
"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
January 26, 2011 at 5:45 am
Little Nick (1/26/2011)
tq mam. your answer so sexy 🙂
Just so you know, this is a professional forum. That type of comment is serious breach of protocol. You should behave here...
"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
January 26, 2011 at 5:42 am
spmaguire (1/25/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
January 25, 2011 at 3:56 pm
Derrick Smith (1/25/2011)
isuckatsql (1/25/2011)
I ran an execution plan, but dont really have any experience in this area, so i opened a ticket with Microsoft.Thanks again!
If you post the execution plans...
"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
January 25, 2011 at 1:34 pm
Then I suspect either the text is very small or FTI is not being used. Again, the exec plan should tell the tale.
"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
January 25, 2011 at 12:28 pm
I'd check the execution plans. That's going to tell you what each operation is leading to. I would suspect that both LIKE and CONTAINS leads to a scan, but 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
January 25, 2011 at 12:07 pm
SAnjy N (1/25/2011)
Thanks, I have only remote access. And I am not comfortable with Execution Plans. How to read them!
If you search on the web you can find 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
January 25, 2011 at 11:47 am
Is anything else running on the servers? If not, it's SQL Server that is probably causing the issue. Do you have monitoring set up so you can observe the behaviors...
"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
January 25, 2011 at 11:13 am
I'm not a fan of CASCADE. It takes away a lot of control and can lead to unintended consequences. I'd be careful about using it.
As far as the design goes,...
"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
January 25, 2011 at 11:08 am
Viewing 15 posts - 13,486 through 13,500 (of 22,219 total)