Hey Threadizens, I have a question that will be very simple for all of you but pretty hard for me since I am very weak with T-SQL. Please do share...

Thx Aravinda...

I wonder how much time Word press takes to take down these kind of Copy infringement. It is still up.

Just to test, create the stored proc with (WITH RECOMPILE) option and see if that changes it. The behavior that you stated could be because of parameter sniffing or overlapping...

It could be because it is taking a different plan when running from your VS.

Do you manually create the tables on the subscriber or do you let the snapshot agent create it for you? For Transactional replication, the tables need to have PK. So...

Are you planning to initialize the 1TB DB using Snapshot? That would just give timeouts and/or take way too much time. Since it is a 1 TB DB, the preferred...

Feeling much better, Thanks. It is difficult to keep with the THREAD if you dont read the THREAD for just couple of hrs. 😀

I was sick for the past week, today I check the THREAD, I have no clue where it is heading. I do not think I will be able to catch...

ALZDBA (2/18/2011)

---

Roy Ernest (2/18/2011)

---

Next time, at SQLPass, remind me of this trip , so we can have a little chat in Dutch...

Yep, You got that correct. 🙂

here it goes...

When a team goes into bat, two of them go in togehter, One will be the striker and the other non striker. They rotate the strike by taking...

That was a good one... 🙂

I remember both of them. Bob Willis was one the best for England at that time. Michel Holding was one of the best bowler for...

george sibbald (2/18/2011)

---

Roy Ernest (2/18/2011)

---

george sibbald (2/18/2011)

---

Roy Ernest (2/18/2011)

---

Now a days, you do not see that many Draws in test. I am glad. Even though it takes 5 days, I...

george sibbald (2/18/2011)

---

Roy Ernest (2/18/2011)

---

Now a days, you do not see that many Draws in test. I am glad. Even though it takes 5 days, I prefer test over the...