Viewing 15 posts - 5,551 through 5,565 (of 22,219 total)
Sean Lange (9/9/2015)
Grant Fritchey (9/9/2015)
Fair warning though, a shocking number of vendors are really horrible at SQL Server.
Gosh Grant the way you say that makes me think you have 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
September 9, 2015 at 11:06 am
It actually sounds like the process takes out locks in the database while the files move. I would classify that as a bug in the application code.
However, I agree. 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 9, 2015 at 10:17 am
You really need to take the log backups more frequently. Once an hour at least. That puts you in a situation where you could lose up to an hour of...
"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 9, 2015 at 6:05 am
I especially don't understand the "move big folders from the application" part of the problem. That sounds like file manipulation which is not usually something done within the SQL Server...
"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 8, 2015 at 4:19 pm
Alvin Ramard (9/8/2015)
Steve Jones - SSC Editor (9/8/2015)
Jeff Moden (9/3/2015)
Alvin Ramard (9/3/2015)
Grant Fritchey (9/3/2015)
"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 8, 2015 at 10:26 am
Well, I'm wrong today. Microsoft says that they fixed in the newer version of the documentation. Of course, if you look at the old documentation...
"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 8, 2015 at 10:24 am
If you're saying that the application is attempting to pass 3 parameters but the stored procedure only accepts 2, then the fix is with the app. There's nothing you can...
"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 8, 2015 at 8:58 am
Thanks. Passed the word on. Gail, if you feel like piling on, please do 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
September 8, 2015 at 8:56 am
Jeff Moden (9/4/2015)
Grant Fritchey (9/2/2015)
"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 8, 2015 at 8:53 am
BL0B_EATER (9/7/2015)
I was reading the following from BOL ( which is news to me and was wondering it was really true) ... as I find it a slightly odd?...
"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 8, 2015 at 6:57 am
sqlfriends (9/7/2015)
"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 8, 2015 at 6:48 am
Minnu (9/8/2015)
Is there any third party tools or SQL Server tools to compare the DB's and generate automatic scripts to sync.
Is SQL Database manager will help 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 8, 2015 at 4:46 am
That's a huge topic. Yes, Visual Studio is your start point. Since you don't know what you're doing yet, an easy way to get going is using Lightswitch. I've used...
"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 7, 2015 at 4:38 am
Create the scripts for the tables first. Then modify those scripts prior to running them. Search and replace should work fine as was already mentioned.
A second suggestion, use this as...
"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 7, 2015 at 4:36 am
You already have it. OPENQUERY is the other option to query across the line. Otherwise, you can look to SSIS to migrate the data.
"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 6, 2015 at 10:13 am
Viewing 15 posts - 5,551 through 5,565 (of 22,219 total)