This is inverted from the model I'm used to for a scenario like this. Usually either the worker, or a local monitoring software on the worker, will 'call in'...

Sadly, yes, I've seen similar items. I've had it explained to me twice by people who get it and I still end up with a glazed look by the...

Since you're doing a full database replication instead of selective, I'd actually recommend using mirror/snapshot. It's basically easy-mode transactional replication. Check it out; it's definately future proof as...

david.ostrander (8/16/2012)

---

I currently have an SSIS package being built where I want to upload rows from an excel document into a Recordset Destination in SSIS. What I'm having trouble understanding...

smallmoney (8/14/2012)

---

you're right. i couldn't test this because i'm on a iphone right now but if he added WHERE filetype = 'log' in his subquery on the join then it...

I personally usually just do them in a single build, like so:

SELECT

s.[databaseid]

,s.[databasename]

,s.[filename]

,s.[filetype]

FROM

#stuff AS s

JOIN

(SELECT DatabaseID FROM #stuff GROUP BY DatabaseID HAVING COUNT(*) > 1) AS drv

ONs.DatabaseID = drv.DatabaseID

That said, it'll...

Right now Lynn I'm just very glad I didn't say a...

patrickmcginnis59 (8/14/2012)

---

The post I was replying to asked if there was anything to back up my theory that RBAR was slow because of the T-SQL overhead. I...

I was going to hit you with a lmgtfy but it actually would have taken longer. You have the keywords, google is your friend.

http://www.datamartist.com/sql-inner-join-left-outer-join-full-outer-join-examples-with-syntax-for-sql-server

I believe there is possible confusion on definitions here. Patrick, what do you define as 'set-based programming'? For reference, the...

There should be more errors when this runs. This is not a primary indication error but a result of the error occurrance. Somewhere above (or perhaps below, but...

Jan Van der Eecken (8/14/2012)

---

You are only now converting to ICD10? Those have been mandatory in South Africa (where I...

Jeff Moden (8/13/2012)

---

I respectfully submit...

Not that I don't admire Jeff's abilities, but he doesn't speak the language sometimes... or better stated, he speaks the language of database.

From the perpsective of every coder, here's the...

SQLRNNR (8/9/2012)

---

Evil Kraig F (8/9/2012)

---

Sean Lange (8/9/2012)

---

Woohoo!!! Vacation starts in about 7 minutes. Meeting my wife's parents, her brother and another close family friend for a long weekend in Chicago....