I...

yes, I would like to log all the components in the data flow task. Is it possible to log them?

twin.devil (4/24/2014)

---

Confusing Queries (4/24/2014)

---

Eirikur Eiriksson (4/23/2014)

---

It should be numeric or alpha numeric with maximum of 16 characters....

Eirikur Eiriksson (4/23/2014)

---

It should be numeric or alpha numeric with maximum of 16 characters. Thanks for the...

It is a system generated number.

I know that it runs once but, once it runs it should dump file into the folder...

To implement Kaprekar Series...

No, I am not looking for this.

I want the numbers with a columns shifted according to the...

so, under what circumstances...

GilaMonster (3/26/2012)

---

Robert Davis (3/26/2012)

---

If you...

weston_086 (3/22/2012)

---

I want to convert column_A varchar(20) to column_c Nvarchar(20) and Column_B Nvarchar(16) to column_c nvarchar(20).

is this right?

for source column_A having datatype varchar(20)

cast(ColumnA as Nvarchar(20))

for source column_B having datatype...

The problem is, I am working on a query which is getting CXPACKET wait type for long time when it uses hash join and when I created an index in...

Hope the wonderful blog by Gail shaw, is what you are looking for.

it is in 2 parts.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

ColdCoffee (3/13/2012)

---

i just moved the datediff to a cross apply so that it is not calculated twice (i assume it is, i may be worng)

UPDATE

SHP_MANIFEST

SET

DELIVERED = D.DELIVERED_PST,

DELIVERED_DATE_DWKEY = CrsApp.DtDiffDlvrdPST

FROM

SHP_DELIVERED_PACKAGES...

MyDoggieJessie (3/13/2012)

---

Wow that's a large update! Off hand I see an index scan in your execution plan that may save a little time if you modified your existing index...