Thanks . I swear i searched with key word "sql server denali" and this...

Thanks everyone. One thing i have noticed is in "select into" cases i have seen occasional tempdb blockage. After doing some research on web it looks like when doing a...

ricer (6/10/2011)

---

If you are sure it won't truncate any data then I would create a new table with the nvarchar column. Copy all the data from old table to...

rmechaber (6/26/2011)

---

I don't know if this applies to your situation, but for me, I will nearly always choose SELECT....INTO when writing ad hoc queries, b/c I'm selecting from tables in...

Eric M Russell (6/23/2011)

---

sqldba_icon (6/21/2011)

---

Can any one suggest based on there experience which one of these are preferred.

i) select * into #temp from tableA

ii) create table #temp (col 1)

...

I really appreciate and thank all of you for taking some time to reply to my post. I think i will try creating a temp table first, then an...

GSquared (6/21/2011)

---

I prefer Select Into, because in performance tests I've done it's slightly faster, and because it will preserve DDL changes in the source Select between iterations.

E.g.: If you have...

I am sure MSFT has captured exec plans.But if you look at my sql statement it is pretty straight select and insert...one thing what i am not sure is i...

I have some more details now. The sproc is stuck again at the same batch and mentioned below are few details:

i) this sql (http://www.sqlservercentral.com/Forums/Topic1119857-146-1.aspx) is stuck inside the sproc, however...

Update stats worked, i have changed the schedule to update the stats before the load also. Before the stats we about 12 hours old now it will be less than...

Ninja's_RGR'us (6/15/2011)

---

Then if it's the case I'd make sure to check for fragmentation, make damn sure those stats are updated daily, maybe even more than once.

And finally I'd use option...

Ninja's_RGR'us (6/15/2011)

---

sqldba_icon (6/15/2011)

---

GilaMonster (6/15/2011)

---

As Grant said, the plan is generated and cached before execution starts. It's the plan for the batch, SQL doesn't compile statement by statement.

Run the statements individually,...

GilaMonster (6/15/2011)

---

As Grant said, the plan is generated and cached before execution starts. It's the plan for the batch, SQL doesn't compile statement by statement.

Run the statements individually, you'll soon...

No one has used this feature before?;-)

GilaMonster (6/15/2011)

---

The entire batch's query text and plan are found in the DMV. You see one statement and the entire plan because you've got a function in the query to...