Viewing 15 posts - 1 through 15 (of 919 total)
The company wants to add large amounts of new data into their analytics base and also move infrastructure off their current hosted environment. TCO is always an issue, but...
January 3, 2017 at 2:19 pm
OK, never mind. Found the tables.
February 25, 2016 at 2:15 pm
I don't think it's legal to use the Developer Edition for anything other than develpment. You shouldn't be using it for production reporting, or production anything, for that matter.
December 14, 2015 at 12:17 pm
Are any of the objects compressed? Compression might buy you some breathing room...
November 2, 2015 at 12:51 pm
The firm I'm contracting for now was my employer back in 1985. The team I was on built a mainframe DB in a DBMS called Model 204 (wicked fast,...
October 5, 2015 at 2:49 pm
You keep talking about 'test runs' and logging that you 'could build'. Four people have asked you whether you had ever built the system you are describing and had...
September 24, 2015 at 12:11 pm
No you haven't. If you've relied on an Oracle back-end to deliver data to you, that has no equivalence to the system you are pitching. Build what you...
September 22, 2015 at 1:23 pm
If you haven't actually implemented this with dozens or hundreds of MDBs, why don't you give that a try and then come back and tell everyone how it went? ...
September 22, 2015 at 11:54 am
How do you do backup/restore/recovery? Does everyone have to be off? Have you actually had users coming in across a network to get to this beast or are...
September 11, 2015 at 1:45 pm
Well, 11.0.5058 appears to be SQL Server 2012 with SP2 applied. Are you sure 11.2.5058 isn't a typo?
August 7, 2015 at 3:29 pm
Is this running on a VM? Might someone have restored an entire image?
June 8, 2015 at 12:35 pm
If you actually use a list of columns and leave out the (max) columns, does it come back quickly? It could be that the volume of data you actually...
May 20, 2015 at 10:47 am
RESTORE DATABASE BCCrestore
FROM DISK = 'D:\BCC_DB_backup_201505020017.bak'
WITH MOVE 'BBC' TO 'D:\Databases\Data\BCCrestore.mdf',
MOVE 'BBC_log' TO 'D:\Databases\Data\BCCrestore_log.ldf',
REPLACE,
STATS = 10;
GO
Backup was on D:, I think, just a typo.
May 18, 2015 at 2:19 pm
Yep, Lynn has it correct. Sorry.
May 18, 2015 at 2:13 pm
OK, let's try this:
RESTORE DATABASE BCCrestore
FROM DISK = 'D:\BCC_DB_backup_201505020017.bak'
WITH MOVE 'BCC' TO 'D:\Databases\Data\BCCrestore.mdf',
MOVE 'BCC_log' TO 'D:\Databases\Data\BCCrestore_log.ldf'
WITH REPLACE;
GO
May 18, 2015 at 2:06 pm
Viewing 15 posts - 1 through 15 (of 919 total)