Building The SQLSaturday Orlando Marketing Plan-Part 32

I just paused our first LinkedIn campaign, the one that was based on a functional area of IT in the...

Clustered Columnstore Indexes – part 38 (“Memory Structures”)

Continuation from the previous 37 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
In the past I have been writing quite a lot on the...

Guest Editorial Live on SSC

My guest editorial is live on SQLServerCentral.com. My argument is a simple one: we don’t care about data and IT...

SQL Server 2005 || Database backup failed because Full Text catalog files are OFFLINE

Error : Database backup is getting fail with below reason.
The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is...

Do We Care?

Today’s editorial at SQLServerCental is entitled: We Don’t Care about Data and IT Security. It’s by Brian Kelley (author, blog,...

Like() function in SQL Server

Like:- This operator is used in a WHERE clause to search for a specific pattern in the values of the...

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...