Viewing 15 posts - 6,811 through 6,825 (of 13,877 total)
Brandie Tarvin (8/16/2016)
If so, what did you think about it? Was it helpful? Was it annoying? Any caveats I should be warned about?
We're apparently getting it...
August 16, 2016 at 6:03 am
cboneill181 (8/15/2016)
August 15, 2016 at 1:00 pm
bob 66271 (8/12/2016)
I just loaded SQL Express 2016 to try a few ideas. I tried a basic install and a custom install. The basic install had...
August 12, 2016 at 2:40 pm
seubaid (8/12/2016)
Executed as user: ALHMBWS012\SYSTEM. Microsoft (R) SQL Server Execute Package Utility
Version 10.50.4266.0 for 32-bit Copyright (C) Microsoft...
August 12, 2016 at 7:18 am
Jez-448386 (8/12/2016)
Why do you want a temp table?
Best practice is to create a persisted...
August 12, 2016 at 6:39 am
Sean Lange (8/11/2016)
Ed Wagner (8/11/2016)
Steve Jones - SSC Editor (8/11/2016)
August 11, 2016 at 2:32 pm
Brandie Tarvin (8/11/2016)
Phil Parkin (8/9/2016)
EXEC master.sys.xp_create_subdir @DatabaseDailyFolder;
If so, I think you might have to modify your code to capture the execution status of...
August 11, 2016 at 5:58 am
brad.pears (8/10/2016)
August 10, 2016 at 2:27 pm
ChrisM@Work (8/10/2016)
It's not always faster Phil, but this slight variant is:
Nice tweak, Chris. I often forget this nuance.
August 10, 2016 at 10:20 am
Luis Cazares (8/10/2016)
Phil Parkin (8/10/2016)
SQL!$@w$0ME (8/10/2016)
For bulk load from OLTP to Azure SQL datawarehouse, is this tool helpful or any other option?Thanks!
Not really helpful, because neither of these is a...
August 10, 2016 at 10:15 am
TheFault (8/10/2016)
August 10, 2016 at 9:55 am
You could use a splitter. I tend to use this[/url] one, because it's been highly tested and optimised.
DECLARE @TradeRoles VARCHAR(100);
SET @TradeRoles = '1,2,3,4,5';
IF (SELECT COUNT(1)
FROM...
August 10, 2016 at 9:37 am
SQL!$@w$0ME (8/10/2016)
For bulk load from OLTP to Azure SQL datawarehouse, is this tool helpful or any other option?Thanks!
Not really helpful, because neither of these is a data file.
August 10, 2016 at 9:14 am
SQL!$@w$0ME (8/10/2016)
Hi Folks,Why should we use BCP Utility. Any one can explain the scenarios where this tool is useful.
Thanks!
Not sure what sort of answer you are looking for here.
BCP...
August 10, 2016 at 8:09 am
SQLRNNR (8/10/2016)
GilaMonster (8/9/2016)
SQLRNNR (8/9/2016)
Restart dev edition in minimal configuration and add your personal account as a sysadmin that way.http://www.practicalsqldba.com/2012/08/sql-server-lost-all-administrator.html
Minimum config isn't necessary. SQL just has to be started in single...
August 10, 2016 at 7:48 am
Viewing 15 posts - 6,811 through 6,825 (of 13,877 total)