Yeah I was contemplating using a couple of hundred feet of black hose strung across my roof with a small pump to get the circulation going then letting gravity do...

I can't find it now, but I remember Steve mentioning a company working on technology a year or 2 ago that was developing Wind Turbines that spun horizontally instead of...

Unfortunately I'm in somewhat of the same boat, living in central Pennsylvania, we don't get much wind and the days get too short in the winter for solar (although

I'm...

Is the Canshrink property set to False by chance?

Scratch that... I just realized you were using Express... According tot he below you can't use database mail with SQL express...

http://msdn.microsoft.com/en-us/library/ms165636.aspx

Have a look at the following and see if they point you in the right direction...

http://www.mssqltips.com/tip.asp?tip=1100

http://www.databasejournal.com/features/mssql/article.php/3626056

-Luke.

Yeah I've used a similar technique often, allowing my users to choose between a summary or detail view of certain reports that didn't lend themselves to drilling all that well....

For us to be better able to help you, you'll need to give us some DDL, some sample data and the like. Otherwise we'd just be taking wild stabs...

No chance you've got a bad memory module that the OS is having to compensate for is there?

no chance you can do it like so....

--Setting up test data

CREATE TABLE #tmp (

empID INT,

Salary INT,

ModDate DATETIME,

Currentsalaray BIT)

INSERT INTO #tmp

SELECT 1,100,'4/08/2007',''

UNION

SELECT 1,100,'4/08/2008',1

UNION

SELECT 2,200,'4/08/2006',''

UNION

SELECT 2,200,'4/08/2005',1

UNION

SELECT 2,200,'4/08/2004',''

--Doing the update

UPDATE t1

SET [Salary] =...

What do you mean you took a backup from the VM machine tot he other one? did you do a bare metal restore from the VM or did you...

The optimizer will process things differently on different hardware. Additionally it may select a different execution plan for the same query on the same hardware depending on the amount...

I'd second this as I think it would not only help with bits of code to...

I am a DIYer for the most part. I understand my limitations, and will call a Pro when needed, but more than likely I'll call a friend (a lot...

As some have stated above, I believe certifications are a way to separate yourself from others. They're no the only way, perhaps you separate yourself from others by having...