And that is why you should always qualify your column names with a table name/alias in the select list!!

It makes no sense from a technology standpoint.

Why force a change where the entire dev team has years of experience with squeezing every ounce of performance out of SQL Server...

I did, but the answer was one of the 'we can't tell you the real reason' answers...

We are running 2008 SP1.

j.a.c.

I am in that boat right now. Bad design decisions are made just to make the end of the sprint. Miss too many sprint deadlines and *poof*... there goes your...

In my current work environment more process does mean more restrictions. And as a side effect we lost 2 of the best developers our group has ever had due to...

My preference would be for IBMs but those Dell machines were just so much cheaper. That being said we still have some IBM e335s in our lab. Not a complaint...

I don't know about the r715 or r710 but our lab and prod datacenters are full of 2950s... good workhorses.

Ah, those Dell R900s.

We bought a couple of nice shiny new R900s when they were first released.

Within a month the motherboards from both of them had to be replaced.

Bring back the old config files (sqc) that Query Analyzer used!! These were great for setting the background color, font, whatever you wanted on a per connection basis.

It would...

Hi all,

Currently in Calgary, Alberta, Canada

Formerly from Halifax, Nova Scotia, Canada

Thanks Barry,

I don't think I ever stated that cursors could be used to receive data from the queue. I stated that they could be used in the activation proc which...

Check out the link that I provided.

It shows quite clearly that cursors are much faster in this instance than only processing one row per receive statement.

I am using...

It seems that you could change your activation proc to use a cursor or since you are not sending any messages back (nor ending the conversation) you could even process...

gastroenteritis... :sick: