Viewing 15 posts - 4,366 through 4,380 (of 22,224 total)
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
I don't completely understand what you're asking? Can you expand on what it is that you expect to return? What's the data structure you're pulling information 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
September 28, 2016 at 11:43 am
There's no way logically that can work because you would be joining all three columns on all three columns. The syntax doesn't support it and the language doesn't either.
Can 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
September 28, 2016 at 11:42 am
You would have to poll all the tables in the database, one-by-one, to determine if there are changes. That's a poor approach. You could read the log using DBCC LOG...
"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:39 am
Viewing 15 posts - 4,366 through 4,380 (of 22,224 total)