-1
votes
0answers
16 views

sql Express 2008 db size

I have an SQl Express server 2008 database file whose size is 94kb, when i run the script to install the database on SQL express server 2008 r2 its size it shows 3.49 GB (3,750,756,352 bytes), log ...
1
vote
1answer
231 views

Is there a negative impact to using SQL Server with a lower compatibility level

We have SQL Server 2008 R2 which we are using for a database with a compatibility level set as 2005 (90). We will by upgrading it to 2008 at some point, but in the meantime I would like to know if ...
2
votes
1answer
52 views

Consolidating SQL Server

We have a number of SQL Server 2008 R2 standard servers, each for a single application that we'd like to consolidate into one physical server. Running perfmon on these servers they're not using a ...
0
votes
1answer
66 views

SQL 2008 Performance Reports

Does anybody know of DMV's or reports that will show the historical performance of the stored procedures on the server? Also if that data is stored in a table or tables, what is the retention period ...
0
votes
1answer
631 views

SQL Server MDF Files Split guidelines

Are there any specific guidelines to split up a single MDF file into multiple files for a single database. An example of a scheme that I can think of is splitting it so that one NDF file contains just ...
0
votes
2answers
330 views

Which database (DBMS) can best utilize multiple cores and more memory?

The databases that I am interested in are: SQL Server 2008, MySQL, and PostgreSQL 9.0. In general, I am wondering which of those would "scale-up" the best. I have read that PostgreSQL used to ...
1
vote
0answers
450 views

SQL 2008 Database tuning advisor won’t start

For some reason I can't get DTA to connect to my development machine. It connects to a remote DB just fine but when I point it to my dev machine I get an error saying: Failed to initialize MSDB ...
1
vote
2answers
72 views

Do I need to index a column that is an FK to a PK in a different table in sql server 2008?

I have a table that has fairly heavy queries. The column I am joining on is an FK to a PK in another table. This column seems to take up of the query time with a table scan which leads me to believe ...
1
vote
2answers
1k views

How does a SQL database handle simultaneous requests?

This may be a bit of a noob question, but I'm curious: How can a database handle multiple simultaneous requests, most notably reads? Is every request placed in a queue, so it really occurs one at a ...
10
votes
5answers
6k views

SQL Server Express for Production Databases?

We are about to roll out a dual web/internal transactional application where each client has their own database. Each database is very small - under 50MB each, so we were wondering if it would make ...