Koen Verbeeck (8/22/2013)

---

Jan Van der Eecken (8/22/2013)

---

Koen Verbeeck (8/22/2013)

---

It's been...

Koen Verbeeck (8/22/2013)

---

It's been a while since I actually laughed...

Hi and welcome to SSC. It is unfortunate that you store multiple pieces of information in a single column. This violates first normal form. At any rate we can certainly...

Koen Verbeeck (8/22/2013)

---

Sean Lange (8/22/2013)

---

Koen Verbeeck (8/22/2013)

---

Jack Corbett (8/22/2013)

---

Man, I better get back to answering questions, I'm #11 all-time in points now and Koen is bearing down on...

pdanes (8/22/2013)

---

Sean Lange (8/22/2013)

---

Are you always this snarky to people who are honestly trying to help? I tried to explain how TOP works. Maybe TOP is not the most efficient...

Koen Verbeeck (8/22/2013)

---

Aw fudge. I was...

This page explains the default trace. If this is something you want or need in the future you probably should look into extended events.

http://technet.microsoft.com/en-us/library/ms175513.aspx

If not too much time has elapsed you might still find it in the default trace.

In SSMS right...

pdanes (8/22/2013)

---

Sean Lange (8/22/2013)

---

No that is how it works. If you use the TOP predicate you generally should also use an order by clause. Without the order by there is...

No that is how it works. If you use the TOP predicate you generally should also use an order by clause. Without the order by there is no way of...

daniel.carreira (8/22/2013)

---

Hi all,

I am doing a left join betwen two tables, the issue is that the result of this join is bringing more rows that he left table has, from...

SQL Search is free and it is from our sponsors RedGate. 😛

It is an invaluable tool that belongs in everyones tool box.

PRR.DB (8/22/2013)

---

Thanks for your reply .

As per above code(as per functional wise) not possible to insert at single time . It is looping 1.2 millions time and joining...

Not my intention at all. Using sql to help you build sql is good idea and something that...

The reason you have such horrible performance is because you are using a cursor for inserts. This should be done in a single statement instead of 35 million individual inserts....