Viewing 15 posts - 1,396 through 1,410 (of 4,272 total)
The premise of this article is right on track as far as I'm concerned. I don't have the certifications, I just have over 2 decades of experience in IT...
June 7, 2011 at 2:00 pm
Ok, I could see that. I would say that for most people the 300 number is at minimum a good starting point. I don't have and haven't had...
June 7, 2011 at 1:15 pm
Gila,
I agree, were you just clarifying what it meant?
CEWII
June 7, 2011 at 12:58 pm
Without knowing your data its going to be hard, but the error is pretty clear, when you are using a sub-query it needs to return a single value. Until...
June 7, 2011 at 12:55 pm
Agreed, I love SSIS and it can do a lot. Unfortunately I see a lot of misunderstandings about what it can and can't do. If you understand its...
June 7, 2011 at 12:51 pm
I'm sure there is one but I don't have a link at the moment..
With that said, the installation of a second instance is the same as the first, you have...
June 7, 2011 at 12:47 pm
In the next EXEC SQL task you simply use the placeholder ? and then use the parameter mapping to say that that variable IS the ?
CEWII
June 7, 2011 at 12:41 pm
A consistently low Page Life Expectency is typical of memory pressure. I beleive the metric is consistently less than 300 seconds. Keep in mind some operations like DBCC...
June 7, 2011 at 12:24 pm
opc.three (6/6/2011)
You'll need to pull the SQL Server data into an SSIS recordset, iterate over it and issue an update in Sybase for each...
June 7, 2011 at 10:48 am
Would you consider this a restartable process, meaning that if you send in the same data-file it will not corrupt the existing data. It may redo some work but...
June 7, 2011 at 10:05 am
GilaMonster is absolutely right, and I wanted to point out something else which I hope was just for demonstration. Your update statement has no WHERE clause, so it will...
June 3, 2011 at 2:32 pm
Not aware of any defects in that version. Hm, mapping without a drive letter should work just fine.. Not sure why you got that particular error.
The important thing...
June 3, 2011 at 2:07 pm
So what is the question? I'm sorry but I don't see what you are asking for. Can you clarify?
CEWII
June 3, 2011 at 2:01 pm
s_osborne2 (6/3/2011)
I would look into mirroring if I were you it sounds like it meets your requirements better. Also, if you're using a .NET application to connect to the DB...
June 3, 2011 at 1:57 pm
Sorry, I'm with G on this, NOLOCK should be used sparingly and carefully. Yes it does reduce contention, but it doesn't do it for free. The cost is...
June 3, 2011 at 12:38 pm
Viewing 15 posts - 1,396 through 1,410 (of 4,272 total)