Viewing 15 posts - 8,401 through 8,415 (of 22,219 total)
They turned them off to speed up a data load but never turned them back on?
I don't know. Pretty much blazing away at their feet though.
"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 11, 2014 at 8:07 am
Ah, that makes sense. I was following this question because I was curious if it worked differently than my understanding too. Good to know we both have a handle 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 11, 2014 at 6:32 am
I'm not sure. It's not something I would try to do. What's the purpose of this approach?
"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 11, 2014 at 4:58 am
You want to do this live against your database? In short, you're building an additional locking and blocking mechanism on top of SQL Server (assuming I understand what you're suggestion)....
"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 11, 2014 at 4:55 am
Looks pretty good. I like the approach of defining the problem space and then talking about how you'll present solutions to that problem space. I'd say it needs one more...
"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 11, 2014 at 4:50 am
There's been tons of discussion around this. Coding Horror has an article[/url] about one of the best articles on ORMs, that and all the links are worth a read.
I've worked...
"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 11, 2014 at 4:46 am
Just looking at pictures of execution plans and not able to see the properties, this is a bit of a guess, but I'd say it's probably bad parameter sniffing.
When 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
April 11, 2014 at 4:33 am
I'm not an expert on sp_prepare, but I'm pretty sure you're not supposed to set the value to a particular number, you're supposed to capture that value in the output...
"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 11, 2014 at 4:28 am
Why try to open it through a SQL query? Why not just use a command line utility like PowerShell or sqlcmd.exe? Either of those can read the file and execute...
"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 11, 2014 at 4:26 am
Most of the migration projects I've been on take 6-9 months to move stuff over. With that in mind, I usually always suggest going to the latest release because we're...
"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 11, 2014 at 4:23 am
Cody K (4/10/2014)
Grant Fritchey (4/9/2014)
Prediction? No. But following coding best practices to write queries such that they access objects in the same order
How does this come about in real life?...
"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 11, 2014 at 3:52 am
free_mascot (4/11/2014)
If you think that your backup is corrupt you can use RESTORE VERIFYONLY to check if the backup is good?
Which will check just the header unless your backup is...
"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 11, 2014 at 3:48 am
Although, there are degrees of "simultaneous." Is everything going to the same disk? Then you'll be seeing alternating writes, not simultaneous, depending on the number of disks, controllers, all 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 10:14 am
If you want to test the whole system, disk, memory, etc., you really do have to retrieve the data. If you're on a 2012 system, I'd suggest looking at distributed...
"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 10:13 am
"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:59 am
Viewing 15 posts - 8,401 through 8,415 (of 22,219 total)