Viewing 15 posts - 4,726 through 4,740 (of 22,219 total)
There are four different buttons for downloading on that site. It's unclear which one is for actually downloading and which one(s) are going to launch some sort of virus. So...
"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 24, 2016 at 6:30 am
A big part of this will be down to the structure of your table and the indexes in place. A delete based on thirty separate columns is going to be...
"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 24, 2016 at 6:21 am
Does more than one account in your system have restricted user access? That would likely be what's occurring. Something else is there, preventing you from changing the database setting.
"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 24, 2016 at 6:18 am
My immediate thought is to look to the cloud. Instead of writing to tape and physically transporting the tape, write to cloud storage (AWS or Amazon) and then download 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 24, 2016 at 6:17 am
Sean Lange (5/23/2016)
Jack Corbett (5/23/2016)
Sean Lange (5/20/2016)
GilaMonster (5/20/2016)
Ed Wagner (5/20/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
May 24, 2016 at 6:07 am
This:
ek.carriermemid <> ' '
In the WHERE clause is going to turn that LEFT JOIN into an INNER JOIN. Move it into the ON clause in order to retain...
"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 14, 2016 at 9:55 am
Several things. First up, @Backupdrive2 is a parameter in the stored procedure, not a column. A parameter is a place holder that you use to pass in values to a...
"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 14, 2016 at 9:50 am
It's at the domain level. To give permissions between domains, they have to talk to each other. I'm not a security expert so I don't have the precise walkthrough. That's...
"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 14, 2016 at 4:27 am
You have to set up permissions between the domains. No other way to do it since the security is through your local domain. Another option would be to post the...
"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 13, 2016 at 10:27 am
Smendle (5/12/2016)
TheSQLGuru (5/12/2016)
Smendle (5/12/2016)
All of your answers you seek are available from Microsoft...The OP wasn't confused or asking about WSFC. He was asking about a SQL Server Failover Cluster Instance.
My...
"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 12, 2016 at 3:26 pm
ganapathy.arvindan (5/12/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
May 12, 2016 at 6:12 am
Try capturing the segmentation elimination with this extended event. It might prove more informative than the execution plan in this situation.
"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 12, 2016 at 3:19 am
If you have the time to completely shut down transactions prior to the backup, yes, that sounds like an adequate process and you won't have to worry about the transaction...
"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 12, 2016 at 3:14 am
The shortest possible answer to your question is, yes, Availability Groups can substitute for Failover Clusters. However, as Kevin says, we really don't know enough about your situation to make...
"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 12, 2016 at 3:08 am
BLOB_EATER (5/12/2016)
Don't...
"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 12, 2016 at 3:02 am
Viewing 15 posts - 4,726 through 4,740 (of 22,219 total)