Viewing 15 posts - 13,171 through 13,185 (of 26,486 total)
Welsh Corgi (4/4/2012)
Bulk-Logged Recovery Model is always an option, right?
Still need to run t-log backups or you could run out of disk space as the log file keeps growing.
April 4, 2012 at 3:18 pm
Welsh Corgi (4/4/2012)
Regardless of the recovery model I want the Staging and Data Warehouse to be in separate Databases. I want smaller backups and faster recovery times.
Not arguing with...
April 4, 2012 at 3:09 pm
Previous employer, and I had nothing to do with the administration of the SQL Server database (or the server it was on), the DW was set to Full Recovery Model....
April 4, 2012 at 3:03 pm
One question, if the data warehouse is using the full recovery model how often is data loaded?
April 4, 2012 at 2:49 pm
jitendra.padhiyar (4/4/2012)
So it is not possible to add primary key on any populated table? or i need to another coulumn which will not allow null vaules ?
Not what is being...
April 4, 2012 at 2:21 pm
Looks like a conversion from Unicode to non-unicode. I would guess that the data column in Oracle is defined nchar or nvarchar and in SQL Server as char or...
April 4, 2012 at 2:11 pm
SQLKnowItAll (4/4/2012)
allen.mceuin (4/4/2012)
SQLKnowItAll (4/4/2012)
SQLKnowItAll (4/4/2012)
April 4, 2012 at 2:02 pm
Pleasse read the error message again: Can not define primary key constraint on nullable column in table 'emploee'.
The column itself allows null values. This is what is keeping you...
April 4, 2012 at 1:59 pm
SQLKnowItAll (4/4/2012)
SQLKnowItAll (4/4/2012)
April 4, 2012 at 1:44 pm
allen.mceuin (4/4/2012)
Lynn Pettis (4/4/2012)
allen.mceuin (4/4/2012)
Personally, nothing really. If your sister sites are going Oracle (shudder) does that mean your site will be going that direction as well?
Unfortunately yes. Were...
April 4, 2012 at 1:31 pm
When setting up a previous employers secondary rack mounted servers (using DASD) I had the data drives configured raid 1+0. These servers hosted the mirror databases for our PeopleSoft...
April 4, 2012 at 1:26 pm
SQL Server clustering is not RAC. Only one node of a cluster can access the database. If you want to be sure that the failover works, you have...
April 4, 2012 at 1:20 pm
allen.mceuin (4/4/2012)
lol, we should start a thead about the HORROR's of GP!!! 😛
it is an absolute joke the way Microsoft makes use of its own technology.
i have a GL3000...
April 4, 2012 at 1:12 pm
Also, years ago they did push RAID 5 for the data files, however, over the last 7 years or so that has changed to Raid 1 + 0 for the...
April 4, 2012 at 1:08 pm
And I may be wrong, but I thought that Microsoft purchased Great Plains, Navision, and Axapta.
April 4, 2012 at 1:03 pm
Viewing 15 posts - 13,171 through 13,185 (of 26,486 total)