Monday, March 26, 2012

Newbie Question

I hope this is the correct group for this question.I am a
newbie to using SQL Server and need some help. I have a
Access database that I am testing with SQL Sever 7. When
I imported my tables into the SQL Server I just imported
them into the Master Database that is already there. The
performance was very good scrolling through the records
within the database was very fast.
I then created a new database and imported the tables
into the new database and now, when I scroll through the
records within the database it is very slow.
I have noticed that there are a lot of different system
tables in the database, are these file making the
performance faster? I linked the database to SQL Server
using ODBC.. Is there anything that I can do to improve
the performance in the new database?
Thanks in AdvanceUser database objects should never be in Master database. This is for inter
nal SQL Server system only. When you place an object in Master that is also
in one of your other databases, then query the table from the non master da
tabase, the table from mast
er is used over the table from the non master database. This may be causing
some of the slowdown.

No comments:

Post a Comment