Showing posts with label Database design. Show all posts
Showing posts with label Database design. Show all posts
Wednesday, August 2, 2017

How to reset IDENTITY in Memory-Optimized Tables

›
Even though SEQUENCE object is available with much more flexibility, we still use IDENTITY property for adding sequence values to tables, ...
Wednesday, June 7, 2017

Naming columns in the View

›
How do you name columns returned from your created view? Generally, you do not need to explicitly name them as the names of view-columns  ...
Tuesday, June 6, 2017

Creating Horizontal Views and Vertical Views

›
Everyone has either used or created  views for getting or creating a dynamic result using one or multiple tables. And everyone knows the u...
Sunday, February 12, 2017

Converting Attributes to Columns - SQL Server Brain Basher of the Week #065

›
Let's talk about something common for all database management systems without talking something specific to SQL Server. This is the in...
Monday, December 5, 2016

Maintaining Sinhala (Unicode) characters with SQL Server Database

›
This is one of the questions I received last week on Unicode characters. I was asked the way of maintaining Sinhala characters in one of t...
Tuesday, June 17, 2014

What are the advantages of a SQL Server database with multiple files located on one physical drive ?

›
This is a common question I always get from my classes/workshops. Do we really get some benefits out of a database with multiple data files ...