Viewing 15 posts - 4,366 through 4,380 (of 22,227 total)
djj (9/30/2016)
Greg Edwards-268690 (9/29/2016)
Setting them up in several stages, where you can avoid...
"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
September 30, 2016 at 5:23 am
Sounds like you're doing a good job. Keep it up. Focus on the metrics to drive your decisions. Take a look at Gail Shaw's blog post on "catch-all" queries. 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
September 29, 2016 at 12:12 pm
Mike Scalise (9/29/2016)
Grant Fritchey (9/29/2016)
I did set up a Powershell script once that spawned threads to run multiple backups simultaneously. I'll never do...
"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
September 29, 2016 at 12:06 pm
PiMané (9/29/2016)
It's best to take the reads vs writes in consideration rather than the missing index then, right?
Yes & no. It really comes down to pain points. Not every query...
"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
September 29, 2016 at 7:02 am
Without all the details, what I'm about to say should be taken with a large grain of salt...
I'd be inclined to do any updates directly against the table in question,...
"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
September 29, 2016 at 6:37 am
Of course using Redgate tools is the ultimate answer. SQL Monitor would be the one to use in this situation. You can link to a server without installing anything to...
"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
September 29, 2016 at 6:25 am
I'd just do them one after another.
I did set up a Powershell script once that spawned threads to run multiple backups simultaneously. I'll never do that to a production...
"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
September 29, 2016 at 6:14 am
I'm not sure it's 2014. I know 2016 is free. Here's the link.
"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
September 29, 2016 at 6:12 am
On the PK:
Don't confuse the primary key and the clustered index. While the default is for the PK to be clustered, you don't have to make the clustered index 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
September 29, 2016 at 5:47 am
BLOB_EATER (9/29/2016)
"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
September 29, 2016 at 5:31 am
drew.allen (9/28/2016)
mcfarlandparkway (9/28/2016)
This is what...
"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
September 28, 2016 at 3:42 pm
ScottPletcher (9/28/2016)
Eric M Russell (9/28/2016)
ScottPletcher (9/28/2016)
"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
September 28, 2016 at 3:40 pm
mw112009 (9/28/2016)
--This gives you the list of all the SSRS reports in your Reporting Server. Agree ?
-- I am looking forqward to...
"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
September 28, 2016 at 12:53 pm
For production, first thing, everyone has a second login from their standard one. One that's for your machine, email, development, whatever. Another that's only for production. A lot fewer errors...
"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
September 28, 2016 at 11:57 am
Anyone who has the capacity to overwrite the database in a restore from a security stand point is going to be able to undo your changes. DDL triggers don't have...
"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
September 28, 2016 at 11:48 am
Viewing 15 posts - 4,366 through 4,380 (of 22,227 total)