Viewing 15 posts - 6,181 through 6,195 (of 22,221 total)
Deadlocks are always about performance. The faster an update occurs, the less likelihood of deadlocks. So, first things first, make sure that your updates are performing well. Are they doing...
"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
May 5, 2015 at 7:02 am
it could be due to index fragmentation from updates or inserts within the cluster. Moving the data all at once leads to less fragmentation, which would explain the differences in...
"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
May 5, 2015 at 6:43 am
It is possible to set up an Availability Group with 2008R2, but there are some hotfixes that you'll have to download. I don't have the documentation at hand, but 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
May 5, 2015 at 6:40 am
Thanks for the input guys. I guess I'll make this ogr2ogr work. It's kludgy in the extreme, but seems functional.
"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
May 4, 2015 at 4:05 pm
dan-572483 (5/4/2015)
"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
May 4, 2015 at 3:47 pm
And second. Right there with 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
May 4, 2015 at 9:45 am
Sean Lange (5/4/2015)
Lynn Pettis (5/4/2015)
Jack Corbett (5/4/2015)
Please help...
"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
May 4, 2015 at 9:31 am
Jack Corbett (5/4/2015)
Please help me fix this poorly...
"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
May 4, 2015 at 7:51 am
If you have MSDN access, the download page is here[/url].
"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
May 4, 2015 at 6:07 am
MotivateMan1394 (5/3/2015)
I have 2 Functions in my Query. (then 2 columns in my query's output)
Function 1 : calculate a value on check a state field. (get values from...
"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
May 3, 2015 at 7:23 am
Please don't post any more answers to this thread. A more complete conversation is taking place 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
May 3, 2015 at 5:43 am
Just so you know, posting in multiple forums leads to very disjointed conversations. You asked the same question over 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
May 3, 2015 at 5:42 am
You might be better off if you at least require the users to separate the words with commas. Then you can use a tally table to split the strings easily....
"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
May 3, 2015 at 5:40 am
And it really has to match 100% exactly in order for this to work successfully. It's somewhat fragile in that regard.
"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
May 3, 2015 at 5:35 am
Eirikur Eiriksson (5/1/2015)
Grant Fritchey (5/1/2015)
.... I'll shut up.Didn't know that was possible:-P
😎
😛
"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
May 1, 2015 at 11:34 am
Viewing 15 posts - 6,181 through 6,195 (of 22,221 total)