Viewing 15 posts - 9,496 through 9,510 (of 22,219 total)
Lynn Pettis (9/29/2013)
I am officially a grandfather, again. Kassondra gave birth to her second son, Branson James on 9/28 @ 6:19 PM MDT!
Congrats Granddad.
"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 30, 2013 at 5:51 am
hisakimatama (9/27/2013)
"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 30, 2013 at 5:50 am
As to permissions, it's pretty easy to script them out and reapply them as part of a restore.
But, if you have differences in structure, there is no way to run...
"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 27, 2013 at 9:07 am
Yeah, I think the best mechanism is through security. You can't even set up a trigger on something like this.
"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 27, 2013 at 8:28 am
Just through restricting access to it. You have a lot more granular security settings in SQL Server than Access. You'll want to read up on it.
Oh, and my name is...
"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 27, 2013 at 6:47 am
EddieN1 (9/27/2013)
Also, the "remote"...
"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 27, 2013 at 6:11 am
spectra (9/27/2013)
does it overwrite data in destination DB ?I want to refresh destination DB in fact.
That's up to you, how you configure it.
If you just want to overwrite 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 27, 2013 at 3:49 am
Yep. 100%. I've run it from Apple, Linux and, of course, Windows. Except for the small sections of it that still require Silverlight, it works fine on any OS 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
September 27, 2013 at 3:48 am
It's possible, yes. It's just not terribly practical. You could have the data files there, not the tables, and you could attach and detach the database. But, it's going 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 27, 2013 at 3:46 am
GilaMonster (9/26/2013)
Rem70Rem (9/26/2013)
I think this it the creation of the indexes that takes more time.
Think? First thing you need to do is time the steps and see for absolute 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 27, 2013 at 3:43 am
I currently work for Red Gate, but, prior to my employment here, I worked with the Red Gate tool belt for 10 years as a DBA. My love for 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 27, 2013 at 3:40 am
The options are, query the dynamic management objects (DMO) such as sys.dm_exec_requests while the query is running in order to see which locks are taking a long time during execution....
"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 27, 2013 at 3:36 am
You might want to take a look at SQL Server Integration Services, SSIS. That's the standard Extract, Transform, Load (ETL) tool for 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 27, 2013 at 3:28 am
hisakimatama (9/26/2013)
SQLRNNR (9/26/2013)
hisakimatama (9/26/2013)
Working with the company's vendor software, and one of the reports is coming across super-slow, about 10 minutes 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 27, 2013 at 3:15 am
This is really down to opinion, but my feelings on it are, you should add comments for clarity.
If you're doing something really complex in T-SQL, tell us what it is....
"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 26, 2013 at 4:41 am
Viewing 15 posts - 9,496 through 9,510 (of 22,219 total)