Luke-

Try joining to sys.dm_db_index_physical_stats to determine rowcount... that should work.

Colin, those are both good points that deserve mentioning! Thank you for pointing them out. It is definitely important to try changing up your high-cost queries to see...

Codename is Katmai:

http://en.wikipedia.org/wiki/Microsoft_SQL_Server

http://en.wikipedia.org/wiki/Katmai_%28Microsoft%29

I've heard anything on release dates from 2008 through 2010+...  it's hard to say.

cast(request as varchar(200)) as 'Some Alias'

We use VMWare ESX Server for creating test environments very quickly. We would never, never, never recommend nor consider it for production situations. In my experience the value...

Something like this should work...

UPDATEims

SETims.Payr = t2.Payor

FROMInpatientMedStat ims

JOIN(SELECT t2_1.PID, t2_1.Payor, t2_1.PayAmount

FROM table_two t2_1

JOIN (SELECT PID, MAX(PayAmount) AS max_PayAmount

FROM table_two

) t2_max

ONt2_1.PID = t2_max.PID

ANDt2_1.PayAmount = t2_max.PID

) t2

Onims.PID = t2.PID

I honestly don't recall. I remember I tried the DataDirect drivers as well as the 3.7 version of the Merant drivers with no success.

I went through this same, painful process.

Here's what I used:

Driver:

MERANT 3.60 32-BIT Progress SQL92 v9.1D

Connection String:

Driver={MERANT 3.60 32-BIT Progress SQL92 v9.1D};uid=username;password=password;databasename=dbname;portnumber=1234;hostname=123.456.789.101

In your data flow tasks, configure the connections to...

I'll second pretty much anything that Ken Henderson has done. Guru's Guide to T-SQL is key... nearly every good SQL DBA I've ever known has owned a copy.

I've...

http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx

I've used the SQLRecon tool there in the past with some good results. As I recall it lists version information.

You're probably thinking about xp_fixeddrives.

I'm not sure what you're asking here... PROGRESS supports array datatypes. So you could say you have a column called month and give it a field extent of...

Not in the same way other RDBMS' implement them (PROGRESS comes to mind... ouch). Usually people create normalized child tables to represent what you might otherwise use an array...

Doh, didn't read the top... 7,2000 forum. Use one of the examples above then.

If you're using SQL Server 2005 you should look into the ranking functions... something like this:

SELECT t1.*

FROM tbl1 t1

JOIN (SELECT id, RANK() OVER (PARTITION BY PersonCode ORDER BY DataValue DESC)...