Viewing 15 posts - 4,291 through 4,305 (of 22,224 total)
sqlfriends (10/21/2016)
Grant Fritchey (10/21/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
October 21, 2016 at 10:32 am
Steve Thompson-454462 (10/21/2016)
Hope you pardon the shameless plug, but we're using the Red-gate tools to facilitate this; they've been great!
I don't pardon the shameless plug. I actively encourage it! Ha!
Good...
"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
October 21, 2016 at 9:11 am
No idea why someone would use two databases in this fashion unless the filestream was added as an afterthought and they just didn't want to modify the existing database.
In general,...
"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
October 21, 2016 at 6:08 am
lindsayscott23 (10/21/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
October 21, 2016 at 5:51 am
Brandie Tarvin (10/20/2016)
I think you misunderstand what Grant meant by cross-database querying.
If you separate out the data into individual databases, how many queries will have to touch these multiple databases...
"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
October 20, 2016 at 9:41 am
Eric M Russell (10/20/2016)
Has RedGate written any books on Continuous Integration and Lifecycle Management from the perspective of database development, or can you recommend a good book on the topic?...
"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
October 20, 2016 at 8:28 am
Sorry, I don't see anything. What are you attempting to do? Describe your backup plan and how it meets your Recovery Point Objective and Recovery Time Objective worked out with...
"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
October 20, 2016 at 7:24 am
mark 4643 (10/20/2016)
In interim we are moving to local dev DB's and in red-gate source control, we will change...
"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
October 20, 2016 at 7:16 am
lindsayscott23 (10/20/2016)
Data Sources load into a single Staging...
"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
October 20, 2016 at 7:12 am
The best way to do this is to give each developer their own local instance and their own local copy of the database. For this to work well, you 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
October 19, 2016 at 6:17 am
Jeff Moden (10/19/2016)
Deny Christian (10/18/2016)
Jeff Moden (10/18/2016)
Deny Christian (10/18/2016)
I still confuse about Restoring:Specify the source and location of backup sets to restore:
from database
from device
what's the different ?
FROM DATABASE is typically...
"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
October 19, 2016 at 2:45 am
I've got an article I wrote on backup testing. You can see all the options available[/url]. As everyone says though, the one way to be sure is to do 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
October 18, 2016 at 10:10 am
Chad Crawford (10/18/2016)
Grant Fritchey (10/18/2016)
BLOB_EATER (10/18/2016)
Grant Fritchey (10/18/2016)
Evidently stating the obvious when others are stating the opposite...
"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
October 18, 2016 at 9:04 am
BLOB_EATER (10/18/2016)
Grant Fritchey (10/18/2016)
Evidently stating the obvious when others are stating the opposite is not allowed amongst those...
"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
October 18, 2016 at 6:27 am
Wow, just read the comments on Reddit about a recent blog post... ouch.
Evidently stating the obvious when others are stating the opposite is not allowed amongst those who know 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
October 18, 2016 at 6:16 am
Viewing 15 posts - 4,291 through 4,305 (of 22,224 total)