Forum Replies Created

Viewing 15 posts - 1 through 15 (of 35 total)

  • RE: Failed SP2 install causing SQL service to fail...

    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...

  • RE: Failed SP2 install causing SQL service to fail...

    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...

  • RE: Failed SP2 install causing SQL service to fail...

    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...

  • RE: Failed SP2 install causing SQL service to fail...

    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...

  • RE: Failed SP2 install causing SQL service to fail...

    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...

  • RE: CU KB948109 wouldn't install

    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...

  • RE: Using the -g Startup Parameter

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

  • RE: Using the -g Startup Parameter

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

  • RE: Inserting to a Partitioned View

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

  • RE: Inserting to a Partitioned View

    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...

  • RE: Inserting to a Partitioned View

    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.

  • RE: Inserting to a Partitioned View

    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...

  • RE: Inserting to a Partitioned View

    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]...

  • RE: How To Mess Up An Interview

    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...

  • RE: Configuring a Sybase Linked Server

    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...

Viewing 15 posts - 1 through 15 (of 35 total)