Viewing 15 posts - 3,076 through 3,090 (of 7,187 total)
Yes, certainly if you need to connect to multiple sources and destinations every time your package runs. My advice was based on my assumption that you only needed to...
September 2, 2015 at 5:23 am
Please will you post the contents of the SQLAGENT.OUT file, if there is one? If there isn't one, that's probably your problem - the SQL Server Agent account doesn't...
September 2, 2015 at 5:14 am
Alex
Yes, it's very easy to tie yourself in knots trying to escape your quotes with backslashes. I don't know whether it's an option for you, but I use 8.3...
September 2, 2015 at 5:11 am
I think the important thing is that backups are made to a specified location, and then backed up to tape as soon as possible. Your network admins would then...
September 2, 2015 at 4:49 am
Damian
For moving through from dev to test to live, use Package Configurations. I find it works best with a configuration file that you specify in your job. There's...
September 2, 2015 at 4:43 am
Another option, if you know in advance which files you need to process, is to get them all into an ADO result set and loop through them with a For...
August 28, 2015 at 4:14 am
If you will definitely only have one file or all files to process, have two separate tasks: one a loop, and the other a simple processing of the single file....
August 28, 2015 at 2:11 am
Use your favourite scripting language to find the path to the file. For example, in a simple command prompt, you can do it like this:
dir x:\MyTopLevelFolder\MyFile.ext /s
John
August 28, 2015 at 1:30 am
Your requirement isn't very clear, but if I understand correctly, you want something like this:
SELECT
PropertyID
,SUM(RentableSqFtTotal) RentableSqFtTotal
,COUNT(FloorNameID) NoofFloors
,SUM(GrossFloorSqFt) GrossFloorSqFt
,SUM(RentableSqFtTotal) - SUM(GrossFloorSqFt)
...
GROUP BY PropertyID
John
August 28, 2015 at 1:25 am
As part of the installation wizard, you will be given a list of processes that are running that will make a reboot necessary. You can stop those processes and...
August 28, 2015 at 1:15 am
Welsh Corgi (8/25/2015)
The Publisher Server is 2012 and the Subscriber is 2014. That might have something to do with the performance.
Yes, the Cardinality Estimator was significantly "improved" in 2014. ...
August 26, 2015 at 2:06 am
Here are the first two things I would look at:
(1) Is your query being blocked by another process?
(2) Have you compared the execution plans from the two databases?
Are the databases...
August 25, 2015 at 8:48 am
The UI is simpler, yes, but it's helpful to know the command if, for example, you're doing the same change on a lot of servers, or you're scripting a change...
August 20, 2015 at 3:19 am
Try running a trace, just capturing login events from your user accounts. That'll give you a bit more information, such as the application that's making the connection (provided the...
August 18, 2015 at 2:02 am
Is there a service or an application running under your account? The entry in the errorlog tells you the IP address from which the connection was made - this...
August 17, 2015 at 9:41 am
Viewing 15 posts - 3,076 through 3,090 (of 7,187 total)