One issue I never see mentioned are leagl requirements for auditability. There are many types of database-centric applications that are legally required to keep data on premises; for example,...

This one is quick and dirty, but it works for the given requirements:

[font="Courier New"]CREATE TABLE MyTable (

[COD] INT,

[Name] VARCHAR(10),

...

I have been lately on several ad-hoc firefighting teams. No that I would not have the technical skills, but what got me onto them was my age (cf. the avatar)....

Eric Russell 13013 (12/28/2010)

---

Not everyone has a MSDN subscription, and I think that a license for at least SQL Server Standard edition is required for QA environments, and not just...

When you...

SQLkiwi (12/22/2010)

---

Most environments I have worked in have separate Dev/Test servers, rather than Dev edition running locally though!

. . .

The more general point is that SQL Server is much happier...

We develop for 16-to-32 GB 64 bit...

It is wider than that....

I have not seen an SQLS pro running 32 bit on his (or her) dev station in at least a year.

Interesting article,althoug I read it only after it was reposted.

In these 'upserts', we usually rely on the MERGE statement. As it is written in hand-tuned Assembler, its speed is...

pef (12/17/2010)

---

I just scanned through the replies and did not see any mention of TRY/CATCH, thinking back to the error handling inconsistencies before SS205 and the thousands of lines of...

For me, the most underappreciated feature is the integration with Visual Studio. I cannot imagine doing complex cubes or SSIS packages without it.

I have to get into meetings for the rest of the day, so I will take a stab based on what I think I know.

I suggest that you add a...

This seems incomplete: is it the report that is doing the aggregations and pivoting?

I am afraid I am not getting it.

Could you post the code you are describing? (Both the DDL and DML that you have.)

Thanks.