Viewing 15 posts - 16 through 30 (of 50 total)
making C1 as identity column helped.
Thanks.
Paresh
January 29, 2015 at 8:55 am
I think I hacked it...
CREATE DATABASE AdventureWorks2014_Restored ON
(FILENAME='z:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2014.mdf'),
(FILENAME='z:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2014.ldf'),
(FILENAME='Z:\TEMP\AdventureWorks2014_mod') -- this is actually a folder...
FOR ATTACH
January 22, 2015 at 2:09 pm
Thnx again Steve:
So you are right, I moved it all to M drive but the database as defined looks for the IMOLTP files in the original location and that...
January 22, 2015 at 1:36 pm
What is the real size of the "big" database?
January 22, 2015 at 10:03 am
Hi Steve
Thanks for the response. Here are the steps:
1. The software my company makes takes a snapshot of db, via Quiescing the db.
2. I then present this snapshot as a...
January 22, 2015 at 9:54 am
Hi Andrew
you have a valid point. But how do I mount it to the "original" folder on another server.
So the bottom line is, I have a Virtual Copy Data Management...
January 22, 2015 at 8:59 am
Thank you folks for the response.
I have done what Koen suggested.
But the values in the database are very different from the ones in the spreadsheet.
ugh.
Cheers
Paresh
October 10, 2014 at 8:59 am
let's just say there is GB. How would you then handle it?
As I alluded before, I have the same exact modules for MB, KB, TB and bytes.
Once I have answer...
August 27, 2014 at 6:49 am
I have similar modules.
Once I have response for this, I can substitute it in the other places.
Thanks for the quick response.
Paresh
August 26, 2014 at 12:15 pm
Hi SSCommitted,
I have been reading too much good stuff about CSI. hence I have been pushing our datawarehouse be upgraded to sql 2014.
Citing this as one of the advantages.
Paresh
August 20, 2014 at 12:39 pm
I am just running a bench marking test. With and without columnstore indexes....
August 20, 2014 at 11:18 am
it was one of them SSRS "Duh" moments.
The report shows up in the "detail view" not on tile view, go figure.
So I was able to save that report and upload...
May 2, 2014 at 8:03 am
thanks so I am pretty much stuck.
I followed advise on the link, it took me to the same screen I was before.
We got fresh media from MS. that has a...
April 17, 2014 at 11:07 am
Viewing 15 posts - 16 through 30 (of 50 total)