Viewing 15 posts - 6,181 through 6,195 (of 22,226 total)
Unless you're operating in a development environment, I wouldn't suggest even using STATISTICS IO. I've actually noticed it negatively impacting queries. Instead I capture events using extended events (you can...
"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 9:55 am
When all inserts, updates and deletes return an error and the data being transmitted gets lost, most people consider that pretty dire.
"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 9:53 am
Ummmmm....
No.
NoSQL used to mean, no gol darned Ess Que Ell because we hate the DBAs and we hate the language and we just want to go FAST FAST FAST and...
"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:29 am
You absolutely can. Create a backup device and then backup to it. It can be a tape. But, understand, going directly to tape is much slower which could have all...
"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:06 am
You should set up domain accounts. That's the preferred mechanism of managing SQL Server anyway.
"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:03 am
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
Viewing 15 posts - 6,181 through 6,195 (of 22,226 total)