Viewing 15 posts - 8,416 through 8,430 (of 22,232 total)
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
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
Viewing 15 posts - 8,416 through 8,430 (of 22,232 total)