Wowwww ...... Everything is table Scan.

the thickest line is showing the following stats

Estimated Data Size : 5595 GB

Estimated Number of Rows : 4228010000

Estimated Row Size : 1421...

Good Knowledge base question. Thanks for sharing 🙂

Nice question. Thanks for sharing

Take your time. if you need any query do lets us know.

Its strange really because whether its runs on SSMS or SSIS, its will operate on the SQL SERVER level. so time should not be the different. if the query you...

Correction its Cath 🙂

Happens!!! 😎

Good knowledge base question for the understanding of transaction scope. Thanks for sharing

Nice question Hugo Thanks for sharing

Sample data and Desire Output will be very helpful to understand the problem and its solution.

Nice question, Thanks for sharing!!

I have two problems with this (correct me if I am wrong) :

1. The comments field is a NTEXT datatype, so I have to cast it before performing...

ChrisM@Work (8/7/2014)

---

Should be easy enough - but as Lutz pointed out, which column will you use for the sequence? Without one, there's no concept of "earlier" or "later". Did you...

you did, you did ...

you did saw a scalable and OleDB command in a same paragraph 😀

i was actually referring to Derived column thou 🙂

Honestly, if any data transformation is required, it should be in Derived Columns, trust me on this, people have spends a lot of hours to diagnose the issue, if these...

lode.vervaeck 33792 (8/5/2014)

---

Some additional info on this post:

This works ( a single SQL statement )

Update DeliveryConditions

set isdefault=1

where id=?

This does not...