As a DBA you must maintain a proper Inventory of your Database Servers and it should be updated frequently with every changes in the databases. Maintaining SQL Server Database inventory will help every DBA to know the present state of different database servers, their health, resource utilization, plan for migration/upgrade and growth. 1,719 more words
Tags » SQLSERVER
Download complete project : LazyLoadingEagerLoading.zip
The Entity Framework offers several different ways to load the entities that are related to your target entity. For example, when you query for Employee, there are different ways that the related Employee Addresses will be loaded into the Object State Manager.939 more words
616 more words
I suggested that one way to speed up your application was to reduce the trips you make to your database, specifically by avoiding calling a stored procedure multiple times.
Aplikasi database manager sangat membantu para pengembang aplikasi dalam membangun sistem khususnya di level database. Dengan aplikasi ini para pengembang dapat dengan mudah melakukan operasi-operasi atau perintah-perintah yang bekerja di level database berbasis GUI (Graphical User Interface). 271 more words