If I remember correctly Lotus Approach relies on the old DBF format.

You could use a DTS package to export the data you want into suitable DBF files to use for...

A primary key is a special sort of unique index.

The difference between an primary key and a unique index is

• A primary key cannot contain a NULL value
• A primary key is...

I'm wondering if it has something to do with caching.

QA will be running this query from scratch. Perhaps the SQLSERVERAGENT has an execution plan cached in some way.

If you...

If I understand you correctly you have a primary key with two columns in it.

A search using the two columns within the primary key should use an index seek, or...

Are you talking about SQL 7.5/2000?

I used to do something similar using a Data Transformation Services (DTS) package within SQL Server.

Transfering the queries is a little more involved.

SELECT, INSERT and...

I am guessing that dope24_sa was an attempt to create a sysadmin role that wasn't the SA login.

Prior to SQL2005 NOT having objects owned by the dbo was always ended...

If you are using SQL2000 there are stored procedures that let you use ActiveX controls.

sp_oaCreate etc.

You can instantiate a copy of word then call methods from the Word object model.

I...

It is to do with the way in which EM makes its connections. You should try the new Management Studio if you have a timeout fetish. ...

Best practice would be to

• Be explicit in your field names
• qualify your object with its owner

If you truly need dynamic SQL look at sp_executesql rather than exec. sp_executesql will...

Hope the article on Symetric Keys and Certificates comes soon!

SELECT C1,C2

FROM dbo.YourTable AS YT

WHERE C1 IN (
    SELECT C1 
    FROM dbo.YourTable 
    GROUP BY C1 
   ...

Try the new SQL2005 table partitioning as a starting point but read up on backing up of the database first.

If your system is web based and .NET based then you...

At one place I worked the difference between the testing and production hardware was that the testing hardware was slightly more beefy than the production environment. The idea was...

You can only use INNER JOIN for an indexed view.

I take it that a MedicRecs record might not have a record in

• Rating?
• Providers?
• Locale?
• MedicProviders?

Where possible I design my databases so that LEFT/RIGHT...

SELECT CONVERT(SMALLDATETIME,(CAST YourBIGINTColumn AS CHAR(8)),112)

FROM dbo.YourTable

This assumes that your BIGINT is always in full YYYYMMDD format that is February 9th this year was 20060209