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

4,426 reads

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 depth. While looking for a DBA hat, getting...

2018-11-22

5 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,462 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-04

9 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,704 reads

Identifying records with special characters (Unicode)

• by ermrlehkara

• SQLdose

Identifying records with special characters

2018-08-07

20 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

533 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 SQL. Now let us start with basic of...

2016-04-10

19 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)

6,747 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 QUOTED_IDENTIFIER on Why do we...

2015-12-17

11 reads