Viewing 15 posts - 526 through 540 (of 4,272 total)
I have a better idea.. Why don't you tell us what it is supposed to do and we'll talk about solutions..
CEWII
February 29, 2012 at 1:45 pm
I disagree:
Microsoft (R) SQL Server Execute Package Utility
Version 10.0.2531.0 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
That is 10.0.2531 which is SQL 2008 SP1 it would be 9.0.xxxx for...
February 29, 2012 at 9:29 am
PErsonally I really hate using the registry for this, along with environmental variables. They are harder to set and just as easy to miss. If you have a...
February 29, 2012 at 9:26 am
For the case specified, basically a long string of related numbers I would probably handle them as a CSV string and use a breaker to pivot them into rows. ...
February 27, 2012 at 8:22 am
Ahh.. This is why I like to allocate a shared file drive that is placed in the same resource group as my SQL Server. I can then know...
February 27, 2012 at 8:16 am
Where are the packages stored? you mentioned in the file system.. Is it in a shared location? Is it on a drive that is part of the...
February 26, 2012 at 8:28 pm
I'm generally with Jeff on this topic. I think you have a fundamental design problem if you have to pass HUNDREDS of parameters. I have never had a...
February 26, 2012 at 8:24 pm
Login as 'sa' not just a SysAdmin but actually 'sa'.. Ran across this before.. Not sure exactly why..
CEWII
February 24, 2012 at 3:14 pm
jarid.lawson (2/24/2012)
Elliott Whitlow (2/24/2012)
SQLRNNR (2/24/2012)
Jeff Moden (2/24/2012)
Attacking SSIS at last...
I finally started doing the same thing and had to stop. They really took serious offense to me hitting the...
February 24, 2012 at 3:00 pm
SQLRNNR (2/24/2012)
Jeff Moden (2/24/2012)
Attacking SSIS at last...
I finally started doing the same thing and had to stop. They really took serious offense to me hitting the server with a...
February 24, 2012 at 2:51 pm
Well what is the .Net app doing with those 72 rows?
CEWII
February 24, 2012 at 2:30 pm
Our hosts here Red-Gate have SQL Monitor.. Which I use and like.
CEWII
February 24, 2012 at 2:29 pm
My guess is lots of rows that the app is handling one-by-one or as Jeff Moden calls RBAR.. In SSMS it just takes the rows and displays them, no...
February 24, 2012 at 2:28 pm
No idea, why don't you try it and tell us. My guess is permanently..
CEWII
February 24, 2012 at 12:42 pm
So this is a brand new table that wasn't there before? Also, keep in mind that some kinds of data won't really compress much or at all, mp3, jpg,...
February 24, 2012 at 12:41 pm
Viewing 15 posts - 526 through 540 (of 4,272 total)