Let SQL Server Write Code for You

Introduction
Many times I happen to find myself in a situation where, as a DBA, I need to write some long...

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

New website

As you can see the webpage has changed!
New features are:

– Syntax highlighting on code snippets (and easy copy/paste)

– Better readability

–...

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

Speaking In Kansas City At #SQLSatKC

On Saturday, September 13th, I’ll be presenting my 10 Ways To Abuse T-SQL session in Kansas City. If you haven’t...

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

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 not online. Check errorlog file for the...

The Murder train chugs into Raleigh

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...

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

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