Our standard configuration is:

C - OS and Program Files

D - TempDB data files

E - Log Files

F - Data Files

G - Backup files

Perhaps I could have both the data and log...

Do you keep them on the same disk as the operating system and program files, or do you keep them somewhere else?

Steve Jones - Editor (10/30/2008)

---

I'd agree with George. Data/log...

I agree with you on the point that there is not a lot of activity on the system databases. However, I still separate them because I want to keep...

I think everyone needs to keep asking this question every time we attend a Microsoft function. Scream it if we have to. I know I've dealt with this...

I have to ask, why does Microsoft spend so much time emphasizing best practices like moving data and log files to different disks, only to stab us in the back...

I had two issues installing this update. The first issue was because I separate my data files from my log files. This separation has been deployed for both...

As far as memory capping, how much should I reserve on a machine with 15.4 GB of memory?

I don't really have a choice about that, at this time. But I'll certainly keep that in mind as we move forward.

I'm big on using scripts myself, and you better believe I'll make some more scripts once I get this working! 

I'll take a look and see if there are any compatibility issues with UNION.  I noticed this one blurb in the "CREATE VIEW" article in Books Online:

"Columns that are formed...

I removed the WHERE clauses and tried the load again.  The load fails with this message:

UNION ALL view 'CLGWarehouseSTAG.clg.Labs' is not updatable because a partitioning column was not found.

All right, I'll give that a try.  I re-read the Books Online article and I see now that they are not using WHERE clauses either.  I'll rebuild the view without...

Sure, here it is:

CREATE TABLE [clg].[Labs2007](

 [LabID] [int] NOT NULL,

 [NativeLabID] [varchar](24) NOT NULL,

 [AcctNumID] [int] NULL,

 [NativeAcctNumID] [varchar](12) NULL,

 [AcctTypeID] [int] NULL,

 [NativeAcctTypeID] [varchar](12) NULL,

 [PatientID] [int] NOT NULL,

 [MRN] [varchar](10) NOT NULL,

 [CollectionDateTime] [datetime] NOT NULL,

 [LabtestID] [int]...

Excellent point Doug.  It's the same concept as taking a candidate out to lunch and ordering a drink to see if the candidate starts pounding them down.  People should remember that...

Well at least I don't have the Sybase DBA issue.  My boss IS the Sybase DBA and he asked me to do this.

For now, I'll try the Simple provider.  Of...