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
Category: SQL Server
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
Accessing file in filestream using ASP.NET
Like I posted last time, we can use cool feature of SQL Server called “File Stream” which practically allows user to store any kind of file. But as just like any other SQL syntax, it lacks UI to interact and also it really doesn’t have any use just sitting there in SQL Server. So,
Storing Files in SQL Server using Filestream
As you might have already know that we can use DBMSes to store any sort of data weather its simple texts, special texts, documents, photos, movies … anything … and as I said earlier, its good to store data in DBMS as it complies with ACID property. Today’s post is about a feature that was