Thanks Colin

Slowdown happens on both x32 and x64 versions of SQL Server 2008. Memory is either total physical memory on the machine (remove chips), limiting the available memory using...

If you're only looking for the last record for a specific consumer id, then try

SELECT Consumer_ID, Provider_ID, Effective_Date AS LastVisit

FROM dbo.MHC_Admissions_Provider

WHERE Consumer_ID = 0x0000000000000158

AND Effective_Date = (SELECT MAX(Effective_Date) FROM...

If you're only looking for the last record for a specific consumer id, then try

SELECT Consumer_ID, Provider_ID, Effective_Date AS LastVisit

FROM dbo.MHC_Admissions_Provider

WHERE Consumer_ID = 0x0000000000000158

AND Effective_Date = (SELECT MAX(Effective_Date) FROM...

Very simple way to get the SQL Servers on the network is to type

isql -L;

from a command line. You'll have to pipe it to a file, then read...

update db2.dbo.mytext

set spanish = db1.dbo.mytext.spanish

from db1.dbo.mytext inner join db2.dbo.mytext

on db1.dbo.mytext.id = db2.dbo.mytext.id

I use indexed views in Enterprise, Standard, Developer, and Desktop editions of SQL Server. To ensure that the compiler takes advantage of the indexed view, use the (NOEXPAND) view...

How about using a derived table to obtain the weekends, then an outer join to return the rows that you want?

SELECT calendar.weekend, RepiD

FROM

(SELECT Weekend

FROM dbo.calendar

WHERE weekend BETWEEN '2003-01-10' AND...

By prepared statements I mean that the SQL is embedded in the application and SQLPrepare is used to prepare the statement. Then SQLExecute is used with the statement handle...