Viewing 15 posts - 9,496 through 9,510 (of 22,224 total)
If you have to run these in parallel, then I would suggest using PowerShell. You can spawn multiple threads to have them all firing at the same time. I 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
October 1, 2013 at 4:06 am
Another mechanism is to use PowerShell. You can pretty easily walk the structure and generate scripts. Allen White has an example where he does it for the entire database. It'd...
"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 1, 2013 at 4:01 am
You're pumping 20000 rows (estimated, actual could be more) into table variables, where there are no statistics. Then you're combining that with a multi-statement table valued function, which also doesn'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
October 1, 2013 at 3:56 am
Yes. The most I ever had was SQL Server 2000, 2005, 2008, 2008R2 and 2005 Express and 2008 Express. That was six instances of various versions on one desktop. No...
"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 8:34 am
To alter a database to a add a log file, you'd go through the processes outlined here.
"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 7:05 am
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
Viewing 15 posts - 9,496 through 9,510 (of 22,224 total)