Can you do a substring on your xml and pull characters 5050-5100? Need to figure out what it's cranky about,...

ProKelly (3/17/2011)

---

Fundamental point of this post : Shold I construct my DW with SQL and SQL Agent, or with Integration Services?

detail : i've built a comprehensive 30 ish table structure...

george sibbald (3/17/2011)

---

Is this on a SAN? Are you looking for performance improvements in reads or writes? speak to your Storage people. Depending on the exact configuration you can see...

Have you looked into COALESCE()? It should do what you need.

Nooooo....

Read the article. You need to generate CREATE TABLE statements, INSERT...

Krasavita (3/17/2011)

---

Hello, I need to delete records from table2 that are not in table1

I have a table1 and table2

table1

DB, CODE, RATE, MAX(CONV_DATE) AS MaxConv_Date

FROM ...

bob mazzo (3/17/2011)

---

Hi Craig,

First I would say YES - a very short term block every few minutes is acceptable. I can't imagine it would be blocked more than even 2...

amittheming (3/17/2011)

---

Can anyone please let me know how to use sql command in oledb destination in ssis 2005.

I need to write insert statement in sql command for the data coming...

Click on the link, read the article, it...

Craig Farrell (3/17/2011)

---

...and I'd need to doublecheck the read committed locking mechanism between NC index and clustered key lookup to see if that would actually be a permanent cure to...

So, every 5 minutes on a timer (or whatever this is scheduled at), something goes in and obliterates...

Dean Cochrane (3/17/2011)

---

The problem is that you ARE getting a dirty read, and that's what is causing the error. You are correct, READ COMMITTED is the default isolation level, and...

JJ,

The data is not in a testable or consumable format for us. You need to read that first link in my signature, it'll explain to you what we're looking...

*claps* Congratulations Chad.

Rem70Rem (3/17/2011)

---

Thanks.

If I add a data file on my primary group, is there a was to move objects form the current one to the new one? If I want...