SQLdose

Using RANKX in Computed Column and MEASURE

• by ermrlehkara

• SQLdose

This is my first blog for PBI –  DAX. I lately started working on DAX and trying to understand it in...

2018-11-22

1,000 reads

Interview Query – 1

• by ermrlehkara

• SQLdose

Somewhere on internet i found this question. Thought to share it with you all.
We have two tables,  school_students and Class_student.
 
 ...

2018-09-17 (first published: 2018-09-04)

2,450 reads

Identifying records with special characters (Unicode)

• by ermrlehkara

• SQLdose

Occasionally Data analyst may fall in a situation, where they need to identify records holding special characters or only the...

2018-08-24 (first published: 2018-08-07)

2,613 reads

Starting with MS SQL Server

• by ermrlehkara

• SQLdose

In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is...

2016-04-10

523 reads

SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.

• by ermrlehkara

• SQLdose

Hi Guys,
When you generate a script to create a Stored Procedure, below three statements are generate by default.
SET ANSI_NULLS on
SET NOCOUNT on
SET...

2015-12-30 (first published: 2015-12-17)

5,152 reads

Consequences of Timeout/Error on a Delete statement

• by ermrlehkara

• SQLdose

Hello Guys,
Lately, one of my friend asked me a Question, “If Delete is in progress and query get erred out or...

2015-11-02 (first published: 2015-10-21)

2,990 reads

Consequences of Timeout/Error on a Delete statement

• by ermrlehkara

• SQLdose

Hello Guys,
Lately, one of my friend asked me a Question, “If Delete is in progress and query get erred out or...

2015-10-21

435 reads

A Basic Introduction of Database, Tables and SQL.

• by ermrlehkara

• SQLdose

It seems to be the most basic thing but this post is specifically to those who have just started or...

2015-10-29 (first published: 2015-10-20)

2,714 reads

A Basic Introduction of Database, Tables and SQL.

• by ermrlehkara

• SQLdose

It seems to be the most basic thing but this post is specifically to those who have just started or...

2015-10-20

319 reads

Non-Clustered Index

• by ermrlehkara

• SQLdose

In my previous blog I explained about clustered index (https://sqldose.wordpress.com/2015/09/20/clustered-index-and-related-interview-questions/ ).
Considering that we are versed with the concept of heap,...

2015-10-04

377 reads