Koen Verbeeck (9/14/2011)

---

sqlfriends (9/14/2011)

---

so do you agree what wildh says in his post:

Running in design time will result in using the connections from the connection manager rather than you file.

Running...

Congratz Jeff, Float's needed for microscopic percentages and the like (money in particular is problematic), I personally prefer decimal/numeric to avoid rounding issues as I usually deal with financial data...

Kevin Dahl (9/14/2011)

---

Is it possible that in the ntext -> nvarchar conversion something got truncated? nvarchar has a max of 4000 characters, which is not an awful lot of space...

SJanki (9/14/2011)

---

Can the currently stored data in the nText field in 2k5 be used in Acrobat? If not, the data will not suddenly 'work' if you move it to...

SJanki (9/13/2011)

---

Hi,

I did not understand what do you mean...

SQLkiwi (9/13/2011)

---

I've seen this done both ways successfully.

My personal favourite, in many circumstances (and assuming Enterprise Edition) is same database with sensible partitioning/file group/SAN arrangements. Proper configuration can make...

SJanki (9/13/2011)

---

Hi,

the older version, SQL Server 2005, was just storing the documents in nText type column, they do not have to display the file.

In my application I have to display...

As Wildcat mentioned, you want a ForEach Loop object in the Control Flow. It accepts wildcards, so you'll be searching for files in the path with ABCD*.txt. That...

I appreciate the honesty. There's a few things you'll want to look into to understand optimizing Dynamic SQL in particular.

First, you want to explore the plan cache. Then,...

The same thing we do every night, Pinky.

We try to take over the WORLD!

Honestly, I'm here on SSC when it's slow, or I'm off trying to research something, or still...

Self service restores can be a little dicey, but I've been in places where QA had that level of control. As far as the job is concerned, the job...

If you moved your app to the same cloud, I might be able to see it. At least then you're not doing double bandwidth, even for OLTP systems. ...

SJanki (9/13/2011)

---

I am using SSIS to push the data from SQL 2005 to 2008.

Any idea how can I convert nText data to varbinary(max)

I first did a cast from ntext to...

Matt Miller (#4) (9/12/2011)

---

He's doing a statistical analysis based on a normal distribution. he's looking for the point in a normal distibution with an average and standard deviation commensurate...

I'm not sure of how your calculation would work. Can you help explain what the '95th' percentile is? I can't seem to easily grok the math that came...