Sorry to necro an old thread - but just to answer your earlier question on the networked file copies - any method that uses an unbuffered copy will be fastest...

Paul White (12/14/2009)

---

...Because of the complex linguistic rules applied when comparing strings using Windows collations (which are always used for unicode data), comparisons typically use 20-40 times as much CPU...

Here's a nice summary of the perf-related features of Enterprise edition:

http://blogs.msdn.com/boduff/archive/2008/01/24/why-should-i-use-sql-enterprise-edition.aspx

And a detailed posting on the Large Page Extensions feature:

http://blogs.msdn.com/psssql/archive/2009/06/05/sql-server-and-large-pages-explained.aspx

BTW - The "Lock Pages In Memory" feature is no...

Just want to throw a suggestion in here - may be worth a slight refactor of your import process to us the MS LogParser application (here) for the initial load....

I like that Peter spans four spindles. Even if one of his arms or legs is unavailable he'll still be at work 😛

@jc-2: There should be no problems moving those 2 DBs to whichever disks you want. Most of our production servers have these co-located with the rest of...

Google is your friend: http://highscalability.com/youtube-architecture

Regards,

Jacob

@alex:

Might be a bit late for any relevance but does your data really have to be stored as UTF-8 specifically? For most applications I can think of as...

@blaforge:

Sorry for the late response - if you still need assistance with this:

Your issue is a "quirk" in SSIS when dealing with LOB character fields > 4000 chars...

@adam-2 - how do you know which rows have a [Time] value that was entered in BST vs which ones were entered in GMT? Is there some other...

Thanks for the info Paul. So since they have local disk-based storage with auto-destage capability they are really just a traditional SAN silo with enough cache to hold the entire...

Paul White (4/20/2009)

---

...

Just to add to the whole solid-state reliability thing: we serve two thirds of all the web pages viewed in New Zealand daily and use four Ram-San 400s...

There is a review of one of the Fusion-IO products here. No SQL Server-specific benchmarks I'm afraid - would be very curious to see any of those if anyone...

Peter - as always you bust out the most efficient solution with a minimum of fuss. Nice work...

Regards,

Jacob

:w00t:

I'll take your word for it. It's been close to 10 years since I last used that version - happy...