If performance is a concern, you should not set values cell by cell. Create an array and assign it to a range.

You may wish to check http://support.microsoft.com/kb/302084.

Yes, you can.

Good luck.

Here you go.

http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-editions.aspx

Generally, it will. However, if you have 8 cores with 48 GB of memory and databases are on several spindles, you will not see much degradation.

Just squeeze them in a vise. It si clean and gets the job done.

Most people do not realize that there are hard drives in copiers, and that your average...

What is that? Is it a typo?

Nice first 15 seconds of my workday. 🙂

Thanks!

Tight end

I don't know how these things work in the UK, but here in NA the favorite tack is to volunteer time to a non-profit org. That gets the first...

GSquared (11/21/2011)

Revenant (11/21/2011)

DECLARE @temp TABLE ( name VARCHAR(20), total INT );

INSERT INTO @temp

SELECT Name, SUM(Consumption)

FROM tablename

GROUP BY Name;

DECLARE @maxValue INT = ( SELECT MAX(total) FROM @temp...

DECLARE @temp TABLE ( name VARCHAR(20), total INT );

INSERT INTO @temp

SELECT Name, SUM(Consumption)

FROM tablename

GROUP BY Name;

DECLARE @maxValue INT = ( SELECT MAX(total) FROM @temp );

SELECT name,...

Back...

Ninja's_RGR'us (11/21/2011)

bomborde (11/21/2011)

ScottPletcher (11/21/2011)

To paraphrase Clinton, it depends on the definition of "work". If two people have...

This does...

A good way to start the short week! Thanks!