1. No you can't install a 64-bit application on a 32-bit OS.

2. Yes, you can install 32-bit applications including SQL Server on 64-bit OS. Drawback would be...

I'm not sure that this link exactly addresses your issue, but you might find it helpful.

Florian,

Yes, the lookup can be a performance killer if you can't cache the lookup rows because it may have to query the lookup source for each row. Lookups perform...

There's not much to expand on. You define a query, select the column(s) to match on and the column(s) to pass through. You just need to be aware...

In your case the default trace is NOT id 1. The default trace is id 2. The default trace will NEVER have more than 5 files, it is...

You can restore, detach/attach from 32 to 64 bit no problem as the file formats are identical.

You need to be careful. It sounds like C2 or Common Criteria Auditing is enabled. Run this to see:

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'common criteria compliance enabled';

GO

sp_configure 'c2...

You want to do a a LEFT OUTER JOIN. With tbl_Prod_Machines as the left (first) table. Then your case would be when [column from right table] is null...

Is Service Broker enabled in msdb?

SELECT is_broker_enabled FROM sys.databases AS D WHERE name = 'msdb'

Should return 1.

I don't know if you'll have timeout issues. Mainly because I've never done it. I just know it can be done. I'd think you'd be all right...

I'm not sure what to suggest here since you are getting a clustered index seek in the execution plan. I was thinking that the LIKE operator with leading wild...

Matt Miller (#4) (1/29/2010)

---

keep in mind that getting the same results stops being true when those inner joins turn into outer joins.

Jack - what's non-ANSI compliant in Query 1? ...

Interesting. Must have something to do with your distribution of data. I have tried this on my PC using AdventureWorks (2005) and can't duplicate your results.

It would be...