SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Can .mdf files be split??
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 04/05/2012 :  18:10:59  Show Profile  Visit robvolk's Homepage  Reply with Quote
Brett-

ENOUGH

You are out of line, and this is your last warning.
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 04/06/2012 :  03:11:29  Show Profile  Visit jezemine's Homepage  Reply with Quote
hey look over here! bringing the thread back on topic!

I am glad to hear it's not recommended to have such a low limit on mdf/ndf size. I've got two dbs I work with that are 3TB and 4TB respectively.

imagine how many files i'd have if i restricted to 64gb. hard to get out of bed for 64gb!


elsasoft.org
Go to Top of Page

mfemenel
Professor Frink

USA
1421 Posts

Posted - 04/06/2012 :  13:47:48  Show Profile  Visit mfemenel's Homepage  Reply with Quote
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"
Go to Top of Page

enrightmcc
Starting Member

USA
3 Posts

Posted - 04/06/2012 :  21:30:32  Show Profile  Reply with Quote
quote:
Originally posted by mfemenel

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.


Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 04/07/2012 :  03:18:41  Show Profile  Visit jezemine's Homepage  Reply with Quote
http://www.microsoft.com/servers/missioncritical/customerstory.aspx?id=111111119

It's a safe bet this is not using 64gb data files. db is 100TB.

admit it's not that hard to get that size when you have have a 1.4 gigapixel camera taking zillions of pics every night...

http://pan-starrs.ifa.hawaii.edu/public/

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."



elsasoft.org

Edited by - jezemine on 04/07/2012 03:20:55
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 04/07/2012 :  11:19:39  Show Profile  Visit jezemine's Homepage  Reply with Quote
here's another way to do it:

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. :)


elsasoft.org
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 04/07/2012 :  14:56:26  Show Profile  Visit SwePeso's Homepage  Reply with Quote
I thought BCP had a bug with the internal row counter, as it is a unsigned integer; it will error out at 4G rows.



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 04/07/2012 :  15:30:28  Show Profile  Visit jezemine's Homepage  Reply with Quote
they fixed it for 2008. the bug was in 2005.


elsasoft.org
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 04/07/2012 :  15:36:46  Show Profile  Visit jezemine's Homepage  Reply with Quote
oops I lied. that file only had 5e9 rows.

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.)


elsasoft.org
Go to Top of Page

JimL
SQL Slinging Yak Ranger

USA
1535 Posts

Posted - 04/09/2012 :  11:15:43  Show Profile  Visit JimL's Homepage  Reply with Quote
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.

However if my script was out of line I apologize.


Jim
Users <> Logic
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 04/09/2012 :  16:36:04  Show Profile  Visit tkizer's Homepage  Reply with Quote
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.


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Edited by - tkizer on 04/09/2012 17:17:41
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000