Will You Be Joining Us at the Virtual Conference?
Time is getting short to register.
Design Questions – What Has Been Your Experience?
After our workshop last week, I had a reader/attendee write in and ask some great questions that I know others have asked about as well. I thought I would toss these out there for you all to consider, then see what types of suggestions and feedback we get back. I’ll also pass along my own experiences – see how they match yours.
"I’m working to design a tool, which will be accessing data from one or more databases. The tool will be used by about 6000 to 8000 users across the company including users at our global sites, and we plan to host all the data on a single server hosting SQL Server 2005.
I have two options when designing the tool, one is to have multiple databases and separate the data across the databases. Another option is to use a "Single" database for all users of the tool. I’m trying to evaluate the pros and cons of both approaches, and would really appreciate your input. Specifically, these are my concerns when going with a single massive database rather than multiple medium/large size databases:
1. Query performance for end users. Does it matter if different users are querying a single databases versus multiple databases.
2. Resource utilization on the server side. Does it matter for the server resources if there are 100 connections to a single database vs 10 connections to 10 different databases.
3. Database size concerns. A single database will obviously be huge and will grow with time. Does that make performance or maintainability a concern for this solution, versus if we had separate databases."
Without swaying things on what you’ve seen (please email me here), my biggest point of discussion is by far the last item. What do you think? What have you seen when having the luxury of managing the design process?
DBASchool – 3 Days of In-Person Training
Stephen Wynkoop (SSWUG.ORG Founder/Editor!) will be presenting an exclusive three-day course on what you need to know about SQL Server for your every day support of your systems. The class has very limited seats available and will focus on real-world instruction, discussion about how it applies specifically to your systems and focus on a plan you can take back and apply immediately. From security to performance to best practices and much more – check out the course site and make sure you reserve one of the last remaining seats ASAP.
[Get More Information] or [Register Here]
Featured Script
Last Day of a Month
Retrieve the last day of the month in a script…. (read more)