Posts Tagged ‘microsoft-sql-server’

A reference to the master.dbschema (or similar, see below!) is necessary for database projects in Visual Studio that reference system objects. Here’s how to add those objects without slowing everything down.

In the March edition of MSDN we provided an overview of Server Projects and how to reference the master.dbschema file to resolve references to system objects. If you have a project that references the master.dbschema file, you may have noticed it takes a while to establish this reference. You may have also noticed the project may not load or deploy as quickly as it did before referencing the master.dbschema file. This is because when referencing the master.dbschema file you are adding all the system objects found in a typical SQL Server instance to your database model in Visual Studio. The number of system objects defined in the master.dbschema file greatly outnumbers the user created objects for many database projects. If you have multiple projects referencing the master.dbschema file this can be compounded as each projects reference to the master.dbschema has its own copy of the database model in memory.

via VSTS: DB Best Practices : Right sizing the master.dbschema file for better design time performance.


Read Full Post »

This article describes how to identify your current Microsoft SQL Server version number and the corresponding product or service pack level. It also describes how to identify the specific edition if you are using Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.

via How to identify your SQL Server version and edition.

Read Full Post »