Best practices for Database Programming

1. All the tables in the database have properly defined relationship using primary keys and foreign keys . 

2. Indexes should...

Between function in SQL Server

This function is used to select the values within a specified range. These values can be of Int type or...

LEFT() function in SQL Server

Left():- This function returns the specified number of characters from the left part of the given character string.

Syntax:-

Select LEFT ( character_expression...

RIGHT() function in SQL Server

Right():- This function returns the specified number of characters from the Right part of the given character string.

Syntax:-

 Select RIGHT ( character_expression...

Intersection command in SQL Server

This function is used to returns distinct values that are returned by both the query on the left and right...

Exception handling in SQL Server

                    
SQL server gives the exception/error handling mechanism which is similar to c#, Try..Catch block. In SQL Server, we can write...

The Real Reason You Should Be a Proactive DBA

If you’re reading this, you probably think, like me, that SQL Server is an awesome product. One of the great...

SQLSaturday Baton Rouge Business Intelligence and Recap - 1 of 2

(This is the first part of a two-part post on a SQLSaturday Baton Rouge 2014 recap.)
Been quiet on this blog...

SQLSaturday Baton Rouge Business Intelligence and Recap - 2 of 2

(This is the second part of a two-part post on a SQLSaturday Baton Rouge 2014 recap.)
Out of a total of...

Clustered Columnstore Indexes – part 37 (“Deleted Bitmap & Delta-Store Sizes”)

Continuation from the previous 36 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Since the very first CTP beta, I have been asking for some...