What brand of server are you using? Did you install SP3 about the time the lockups started?

If you are running an HP server you are likely running into a conflict...

srilu_bannu (9/27/2010)

---

The SSIS package is converting the dates like ex: 12-nov-11 to 2011-11-12 which is correct according to oracle database..

but it is converting the dates like ex:30-DEC-99 to...

I'm not sure you can. If you have the Enterprise version of SQL Server you could use the resource governor to set the MAXDOP for the users connection, but that...

Thanks Steve, I think that will come in very helpful for me in the future too...

Drikus Roux (9/26/2010)

---

If you are thorough in your test cycles, which requires a full end-to-end integration test cycle (with load) in a mission critical environment, you should catch most of...

No, not if your purpose is just to get a sequential set...

Yes, as far as I know the SQL Server 2008 R2 media contains both the 32-bit and 64-bit versions.

What...

Jeff Moden (9/26/2010)

---

I knew the problem of asinine articles, bad blogs, cruddy code, dumb demonstrations, extreme egos, and flippant flawed followers was pretty bad before I started the research but...

I take it from the lack of responses that nobody has run this error message before... figure, just my luck.

Phil,

Thanks for the editorial and bringing this back to peoples attention.

I like how a number of the connect items have comments from Microsoft in 2007 saying that they couldn't get...

You can do almost anything, and there are usually multiple ways to solve a given problem.

Here is some code that I think will do what you want:

SELECT

Dupes.amount,

...

It can be done, but it can get complicated depending on how many duplicates it needs to support. Would there ever be more than 5 duplicates for a set of...

Does this give you the results you were looking for? (You weren't really specific about the results you wanted to get.)

SELECT

Dupes.amount,

Dupes.number,

Dupes.duplicates,

DupePeople.name

FROM (SELECT...

I'm having the same problem, I can subscribe to some SSC RSS feeds in Google Reader without a problem, but others just show up as 'Permission Denied."

The only difference I...