Richard M Karpel (5/20/2011)

---

If the data is store outside the database this is true but according to the white paper found at http://msdn.microsoft.com/en-us/library/cc949109%28v=sql.100%29.asp Then the limitation does exist as...

Yes and no. You can disable 8.3 name creation in NTFS (http://support.microsoft.com/kb/121007), and that is required for FILESTREAM. Or at...

mohammed moinudheen (5/20/2011)

---

Steve, thanks for the question again.

There is one thing I noticed in your questions-mostly the answer to your question is usually the first choice in the option list...

jmadsen 98862 (5/20/2011)

---

Bottom line - don't work for the highest $$. My highest paying jobs have been the worst. I don't think that's coincidental, I think they know the job...

What I have done is store full backups with the log files. you don't want them with the data files because they're the same thing and if you lose that...

OK, not sure I completely understand SQLRNNR's solution, but Jason, that is cool. Tested a few combinations and it seems to work very well.

Thanks.

Sorry, I saw your code and my wife came home from 3 days in Boston. Got distracted 😛

Not sure, we'll see...

I think you avoid most of it, but AFAIK, there still needs to be some extra space in the db because the index structure has to exist in the database....

I think it's time for happy hour. That's crazy

Thanks, felt like I was timewarped back to writing record stores in the filesystem with C. Hard to explain to someone that has such a different view of how a...

Any chance someone can go a better job than me in explaining this is a bad idea: http://www.sqlservercentral.com/Forums/Topic1111536-392-1.aspx?Update=1

Loading a TB really depends on your I/O and network. The best way to load it would depend on whether it's one time or 1TB regularly. However you loading it...

How much data are you moving?

Loading data into temp tables is one thing, but combining them in a view isn't the way to go. A copy of the data inside...

2. If you mean multiple threads, yes. It's the same as multiple people inserting at one time. If it's a large load, however, the parallelism may not help you. You...