Viewing 15 posts - 5,521 through 5,535 (of 22,227 total)
I'm with Anthony, why not just use log shipping. It's built into the product and will do what you want.
However, a couple of suggestions. First, check the msdb database. There...
"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 23, 2015 at 6:57 am
CREATE PROCEDURE, and nothing else, should not be placing locks on tables. Further, CREATE PROCEDURE, and nothing else, should complete on most systems in an extremely fast fashion.
Are you certain...
"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 23, 2015 at 6:50 am
That totally varies by company.
My last employer had four levels: Junior, DBA, Senior, Principal
We were part of the overall IT organization, under a VP responsible for Server Administration, SAN Administration...
"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 22, 2015 at 4:05 pm
If it's only a small chunk of the overall database, you might look into building an Integrations Services (SSIS) package to do the move. Otherwise, for a subset, it's probably...
"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 22, 2015 at 4:02 pm
jasona.work (9/22/2015)
I keep going back to the "Jet" topic, it's like watching a train wreck and I can't stop...
Absolutely NO intention of posting and feeding...
"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 22, 2015 at 12:41 pm
Alina.Sotnikova (9/22/2015)
Please, help me with this question.
Give an example of a business use case where the knowledge you need to store would be best stored in an SQL database....
"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 22, 2015 at 7:55 am
BL0B_EATER (9/22/2015)
Interesting, thanks for sharing your experiences. Deciphering the licensing document(s) is tough.
Yep. Pretty sure that's intentional.
"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 22, 2015 at 7:47 am
BL0B_EATER (9/22/2015)
Grant with your SA can you leave your production server up and running during a DR test (and bring up your SQL Server over at your DR site too)?
We...
"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 22, 2015 at 7:00 am
We just had Software Assurance. Made things easier when dealing with a large(ish) enterprise, especially DR, etc.
"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 22, 2015 at 6:45 am
Wayne's explanation is excellent.
Just remember, similar is not same. Just because a query has similar structures doesn't mean it has the same structures. Those differences really do matter.
"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 22, 2015 at 6:43 am
Sounds like it might be hitting a timeout on the DataStage side of things. I don't know how to adjust that in DataStage. But the description is how a client-side...
"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 22, 2015 at 4:28 am
I'd use Kristen's approach for showing data without NULL values. Just don't use the same thing in the WHERE, HAVING or ON clauses because you'll cause table scans since 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
September 22, 2015 at 4:24 am
Shelley Allen (9/21/2015)
But if it's set to 'secondary'. How do I just exit? I don't want the job to run if the DB is marked 'secondary'
(Sorry. ...
"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 21, 2015 at 3:44 pm
Assuming it's a trigger, because that makes the most sense. It has to exist somewhere on the system. It's attempting to make calls to the missing database.
"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 21, 2015 at 3:42 pm
I'm with NJ-DBA. What is AHCAuditAllObjects?
That procedure seems to be giving you issues. I can't find it in a search, so it looks like it's something you've created locally.
"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 21, 2015 at 11:28 am
Viewing 15 posts - 5,521 through 5,535 (of 22,227 total)