Viewing 15 posts - 8,416 through 8,430 (of 22,219 total)
Create a foreign key between the columns that map between the two tables. Here's the documentation on 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
April 10, 2014 at 6:06 am
I'd suggest looking into using Michelle Ufford's scripts for maintaining your indexes. That way you don't have to write something yourself.
"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 10, 2014 at 6:05 am
j.b.shteyn (4/9/2014)
"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 10, 2014 at 3:32 am
Cody K (4/10/2014)
- One has experience, and 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
April 10, 2014 at 3:23 am
As someone who used to hire people....
Nope. I don't care.
I know the test says it's advanced and special and shows off a great deal of knowledge, but that's just 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
April 9, 2014 at 3:42 pm
Awesome. Glad you figured it out.
"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 9, 2014 at 11:17 am
You're experiencing page splits or rearrangement due to changes in the data and you're using, I suspect, a client-side cursor to retrieve the information. This is actually normal behavior. You've...
"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 9, 2014 at 8:46 am
Rebuilding an index online means it will absolutely be accessible. An index rebuild without the online option will block access while the rebuild occurs. It's a bit of a dance...
"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 9, 2014 at 8:40 am
In general, not always, but usually, the error message is telling you what's wrong and what you need to do to resolve it. You had an incomplete restore, specifically on...
"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 9, 2014 at 6:19 am
Yeah, but even if they're "on the server" they're using SSMS, right? You could check the default connection settings for each. ANSI differences could be occurring. Not sure why 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
April 9, 2014 at 6:17 am
If you're looking at the Data Explorer and the event you're looking at is database_xml_deadlock_report, it's going to just have an XML output. You can open that as you've seen...
"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 9, 2014 at 6:13 am
Prediction? No. But following coding best practices to write queries such that they access objects in the same order, that they don't have major performance issues, that they use indexes...
"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 9, 2014 at 5:59 am
Please don't cross post questions to multiple forums. It just confuses the discussion.
Gail, I said the same thing on the other one.
"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 9, 2014 at 5:57 am
Sounds like you need to do what it suggests, start the process over again. Be sure that the FULL BACKUP you're restoring is linked to the DIFFERENTIAL you're restoring.
"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 9, 2014 at 5:54 am
First, follow the suggestion and increase your max worker threads. That will both alleviate the issue and make it worse at the same time. It sounds like your system has...
"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 9, 2014 at 5:53 am
Viewing 15 posts - 8,416 through 8,430 (of 22,219 total)