Viewing 15 posts - 13,846 through 13,860 (of 22,232 total)
Size could be an issue in the decision, but I'd look to complexity. If the import is extremely simple, just a column mapping, I'd use TSQL to do it. If...
"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
December 6, 2010 at 6:50 am
I don't completely understand what you're trying to do here. SQL Server backups should be run from within SQL Server using the backup syntax:
BACKUP DATABASE X TO DISK = 'some/location'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
December 6, 2010 at 6:48 am
Luke L (12/6/2010)
Grant Fritchey (12/6/2010)
GilaMonster (12/5/2010)
I've only got 7 plugins in...
"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
December 6, 2010 at 6:39 am
GilaMonster (12/5/2010)
Don't go for tonnes of plugins. Get ones you really need (like syntax highlighting), add more as the requirements arrive.I've only got 7 plugins in total.
I'm running with 4...
"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
December 6, 2010 at 5:32 am
Jeff Moden (12/5/2010)
Heh... I found a way around all of the "problems" with WordPress... I write articles on SQL Server instead of blogging. 😛
You may be on the right 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
December 6, 2010 at 5:30 am
robertlewis2001 (12/4/2010)
I'm quite confused about how to implement a many-to-many relationship and my domain model. Let's say I'm creating a recipe box web application and I have three tables called...
"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
December 5, 2010 at 5:23 am
Luke L (12/3/2010)
Grant Fritchey (12/3/2010)
Steve Jones - SSC Editor (12/3/2010)
Alvin Ramard (12/3/2010)
While setting up WordPress yesterday, I had to create a MySQL database.
I hope y'all...
"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
December 3, 2010 at 10:46 am
Steve Jones - SSC Editor (12/3/2010)
Alvin Ramard (12/3/2010)
While setting up WordPress yesterday, I had to create a MySQL database.
I hope y'all will forgive me. ...
"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
December 3, 2010 at 9:18 am
Steve Jones - SSC Editor (12/3/2010)
Be good to have one in Powershell, and while we're at it, anyone want SQLAzure?
Right, I'll do one in PowerShell, but no promises on deliver...
"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
December 3, 2010 at 9:13 am
Alvin Ramard (12/3/2010)
While setting up WordPress yesterday, I had to create a MySQL database.
I hope y'all will forgive me. 😛
Hope everyone is having 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
December 3, 2010 at 9:03 am
ALZDBA (12/3/2010)
Jack Corbett (12/3/2010)
jason.spangler (12/3/2010)
"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
December 3, 2010 at 7:47 am
CirquedeSQLeil (12/2/2010)
Great Stuff Grant.
Thanks Jason.
"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
December 3, 2010 at 5:52 am
Jeff Moden (12/2/2010)
Good stuff as always, Grant! Thanks for taking the time to write articles like this. This one should be in every DBA's quick reference guide. 🙂
Thanks...
"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
December 3, 2010 at 5:51 am
Jeff Moden (12/2/2010)
Grant Fritchey (12/2/2010)
For the non-SSIS version, what language are you using? Because if it's not PowerShell, I might want to do one using PowerShell.
Steve asked for "using bcp,...
"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
December 3, 2010 at 5:43 am
Jack Corbett (12/2/2010)
ALZDBA (12/2/2010)
Tested in SQL2000 / SQL2005 / SQL2008R2 CU4 .... ehm .... yes...
"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
December 2, 2010 at 6:31 pm
Viewing 15 posts - 13,846 through 13,860 (of 22,232 total)