ganeshnarim (2/21/2012)

---

Ok, That's cool,

i don't know when i walk through on BOL it mess me some times, seems like looking for another sources that time again i'm getting mess what...

Sometimes when replication is acting "flakey," I will open up replication monitor and find the subscription and simply stop it, then start it. It actually helps in strange cases like...

ganeshnarim (2/21/2012)

---

That's great explanation..thank you dear

Now i'm fine with my doubt it's was gone..!:-)

can i start like this SSIS

...

The syntax will be very similar with a few changes. Try looking at a MySQL forum for examples of case statements.

Yes, there is no path to downgrade (which is essentially what you are doing) to developer edition.

LINKING90 (2/21/2012)

---

Thank you ,

select abc = count(u.user_id CASE

WHEN

u.topic_id = '95'

and uel.event_id='1'

and u.intent_id = '2'

THEN 1 ELSE 0 END),

def = count(u.user_id CASE

WHEN

u.topic_id = '95'

and uel.event_id='1'

and u.intent_id = '2'

THEN 1 ELSE 0...

Have you tried deleting and rebuilding the subscription(s)?(obviously a problem if there are too many) Publication(s)? Something just seems kooky here... Have you tried stopping the distribution agents and restarting...

Why don't you look at the other posts. Your query is a mess and will cause lots of problems.

Glad to help!

roryp 96873 (2/21/2012)

---

ColdCoffee (2/20/2012)

---

This (actually, the solution posted by Rory)

DECLARE @Table TABLE

( UserID INT , Interested INT

, Interesting INT , Purchased INT )

INSERT INTO @Table (UserID...

gary.morey (2/21/2012)

---

There actually is a clustered index on the TIME_STAMP column, and as you saw in the insert statement in my post I am using an ORDER_BY. So what...

ganeshnarim (2/21/2012)

---

Thanks to all,

i already installed 'sqlserver2008' and i have adventureworks sample database in my pc, i started what the book is saying exactly but i'm not satisfy when comparing...

Ronnie Jones (2/21/2012)

---

Hi Jared,

Thanks for the response.

Basically, my group supports a tool called SCCM and from time to time, we will develop a process to improve on a specific...

Yes, but this is a 2008 forum and we should still use the tools given to us for the time being. I don't...

Let's see... How many rows are in the table and how many get changed/inserted/updated over a 5 minute period, 2 minute, 30 sec, 10 sec? You could essentially run the...