Database

Many times when we normalize our database, we end up storing multi-values attributes as separate rows in table. For eg. Consider we are storing Photos and a set …

In one of my earlier post Creating a Delimited list from a column of a table, we had seen how to generate CSV (demilited string) from column values in a table …

To support multi-value params, many times we use XML data type as input param. There are multiple ways to parse XML data in SQL Server. Lets have a look at them …

In this script post, we will look at different ways to get the list of user defined tables in a particular database, along with their rowcount and size …

In this script we will look at various ways we can design a string split function in SQL Server to split a delimited string in to individual rows. We will use …

The Cloud-based content storage ecosystem Cloud-based content storages have quickly spread out as an obvious benefit for applications to make data available …

No matter which hard disk brand you have, it is simply a matter of your time before you’ll need data recuperation. Whether it is a result of mechanical failure …

There are three levels of data modeling. They are conceptual, logical, and physical. This section will explain the difference between the three, the order with …

Tables are the basic structure where data is stored in the database. Given that in most cases, there is no way for the database vendor to know ahead of time …

Views can be considered as virtual tables. Generally speaking, a table has a set of definition that sets the structure of the table, and physically stores the …

Indexes help us retrieve data from tables quicker. Let’s use an example to illustrate this point: Say we are interested in reading about how to grow peppers in …

Once a table is created in the database, there are many occasions where one may wish to change the structure of the table. Typical cases include the following: …