If we're at a point where we have one person saying it's a recommendation and one saying it's not then I'd like to see your sources for the info. Post some links to support your position and let folks make their own decision from the info. That way everyone wins and learns.
If we're at a point where we have one person saying it's a recommendation and one saying it's not then I'd like to see your sources for the info. Post some links to support your position and let folks make their own decision from the info. That way everyone wins and learns.
Mike "oh, that monkey is going to pay"
That's all I was trying to say. In my mind I wasn't being critical of tkizer (I didn't originally even respond to her post whare she acknowledged that her information was hear-say). In Tkizer's original response she should have said that the information was hear-say; so it could be evaluated on its own merit. I don't think she was lying; I think she gave information that she thought to be true and correct. I've read good advice from her in the past; but sometimes it's necessary to have context. Regarding Tara being female... we use screen names; 'he' is a perfectly acceptable pronoun in this case. Consider me corrected on this point.
EDIT: i take it back. apparently the 100TB is non-image:
"Pan-STARRS will store the astronomical objects across a 20-node federated Microsoft SQL Server 2008 data management software configuration managing 100 terabytes of nonimage data representing the largest astronomical catalog."
100000 rows sent to SQL Server. Total sent: 4354200000 100000 rows sent to SQL Server. Total sent: 4354300000 100000 rows sent to SQL Server. Total sent: 4354400000 ...
The file I am importing now has 9242575861 rows so I'm about halfway. How big is the file? I'm glad you asked. It's 448gb. :)
100000 rows sent to SQL Server. Total sent: 5397200000 100000 rows sent to SQL Server. Total sent: 5397300000 100000 rows sent to SQL Server. Total sent: 5397400000
5397498324 rows copied. Network packet size (bytes): 4096 Clock Time (ms.) Total : 52549219 Average : (102713.20 rows per sec.)
I would have preferred that Roberts (someone with credentials ) 1st post was to help someone, not try and discredit someone who has put a great deal of time and effort into helping others here.
I am somewhat defensive of Tara as others are. (not that she can’t take care of herself) As she spent a great deal of time and patience helping me while I was trying to get back into programming after being out for 10 years.
I go on vacation for a week and look what I come back to. I have corrected my post to indicate this was bad advice as it was pertinent to my system only. So sorry this caused so much turbulence here.
I have way too many posts on SQLTeam to go back and correct things that I thought were true and later learned something different. I sometimes post things that aren't true, but it is what I believed to be true at that time. I don't recall everything that I have posted, but please point out mistakes if you see any. I ask that you do this politely though.
Can .mdf files be split??
Posted - 04/05/2012 : 18:10:59
