Julia Lerman Blog

INETA Poster Child blabbing about community and code

.About Me

.Chick Blogs (yes I am highlighting them!)

.Coming Soon

.NET User Groups

A small slice of blogs I read

Articles & Talks

Conferences

Developer Book Reviews

Elsewhere...

Showing Off

some random U.G. Leader Blogs

Tablet

Perf study on storing files in SQL Server vs. Hard drive

From October 2001 but still quite relevant, is a document on MSDN which is part of the Cold Rooster application where they worked out their decision to use SQL Server instead of the hard drive for file storage.

"Summary: Summarizes the study that was used to measure the performance difference between a database and a file system. It also explores the data modeling used to design the objects that support the ColdStorage sample Web Service hierarchical storage and infrastructure. (11 printed pages)"

It is a VERY useful "best practices" doc which I often point people to.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncold/html/storagedbdsgn.asp

Comments

TrackBack said:

HumanCompiler
# July 8, 2003 11:31 AM

Saeed tabrizi said:

HI
This Is saeed
can you help me on SQL SERVER 2000

my .ldf file is too big near than 850MB
but my .Mdf file is smaller than my .ldf file near than 190 MB.

can you help me ?
with thanks...
Saeed
sa_tabrizi@yahoo.com



# October 11, 2003 10:16 AM

julie said:

Saeed-
I'm a terrible SQL Server administrator.
I recommend that you go to www.sqlservercentral.com. There are many many articles as well as forums.
Good luck.
Julie
# October 13, 2003 9:24 AM
Leave a Comment

(required) 

(required) 

(optional)

(required)