Last week I blogged about use of Views in SQL Server. We also saw different types of view and best practices for designing new view and limitations that may prevent us creating a view too. As a part of best practice while designing we should always include keyword, WITH SCHEMABINDING which prevents any accidental changes
Tag: SQL Server
SQL Server Views … to make sure others “view” what you want them to view !!!
In essence, SQL Server view can be considered as a “Virtual Table”. When we create a view, user “feel” no difference between it and a table. And we can query it exactly same way as we query any other table. View can be really handy when we are using some super complex query to get
SQL Server Installation Rules and “System Reboot Required” Error
When we do installation or removing SQL Server, it always executes installation rules. And what really weird is, installer even checks for these rules when we want to Un-install the SQL Server (kind of reminds me, my experience with Office ‘97 which had quite similar craving for installation media while uninstalling). Today, when we were
Database Normalization … taming the wild horse
For any application to use database and hence data effectively it is very important that data is organized properly. The most common problem for database is redundancy in data. If table has highly redundant data, that means for every operation (like insert, update or delete) it takes more effort to find correct record. And it
Introduction to Indexing …. and SQL Server
Indexing in simple term can be explained as a pointer to some specific information. It works nearly same as indexes at end of book, just fine the keyword you are looking for at index and get the page number where it is located (when I was studying, mostly sometimes I thought that best way to
SQL Server and The Models …
Atomicity Consistency Isolation and Durability these are key features of any Database Management System weather its SQL Server, Oracle, MySQL or any … and so it is essential for any DBMS to be able to recover / restore data to its original state or a state in any given period of time defined by it’s
Creating Database in SQL Server 2008
Database can be explained as a just single file, which is used to store data properly and which gives us facility to retrieve data properly. And a system that manages that database is called Database Management System a.k.a. DBMS, Oracle, SQL Server, DB2, MySQL are few to name. Each DBMS presents data differently, may have