Viewing 15 posts - 1 through 15 (of 35 total)
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...
October 30, 2008 at 8:36 am
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)
October 30, 2008 at 8:14 am
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...
October 30, 2008 at 7:31 am
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...
October 28, 2008 at 8:34 am
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...
October 28, 2008 at 8:25 am
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...
July 14, 2008 at 10:22 am
As far as memory capping, how much should I reserve on a machine with 15.4 GB of memory?
October 31, 2007 at 6:07 am
I don't really have a choice about that, at this time. But I'll certainly keep that in mind as we move forward.
October 31, 2007 at 6:01 am
I'm big on using scripts myself, and you better believe I'll make some more scripts once I get this working!
February 13, 2007 at 7:31 am
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...
February 13, 2007 at 7:28 am
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.
February 12, 2007 at 6:56 am
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...
February 12, 2007 at 6:32 am
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]...
February 9, 2007 at 7:22 am
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...
October 17, 2005 at 11:16 am
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...
August 26, 2005 at 6:17 am
Viewing 15 posts - 1 through 15 (of 35 total)