Power Of Consistency

IF YOU WANT TO BE TAKEN SERIOUSLY BE CONSISTENT

No one is born genius,some might have high IQ.

But rest go to the top just by sheer practice.

Daily Practice

1 Ted Talk/Blog [related to data-science,machine learning deep learning]

1 Hour Python Practice

1/2 hour of new sql concept

1/2 hour of math a day

Atleast 1 Fruit a day

20 Pushups A day

1 Cycle Ride A day

1 Blog A day

10 Mins of calmness a day

10 mins of goal remembrance a day

Lets Learn English

Epiphany - A Sudden intuitive perception or insight into something

Quotes That I Love

Doing the same thing again and again,but expecting different results every time -Height of insanity

Every Day above the Earth is the Good Day.

MDX Funtions

MDX(Multi Dimensional Expression)

1. MDX basics

Reason for Gap in Identiy Columns

There are many reasons for the gaps in identity columns,it may be due to the deletion of record,hard reset of identity column or due to the roll back of the transaction or else due to shutdown of the sql server. Below links explain them in detail.

1. Identity column Gap

Defragmentation

Query to find the fragmentation percent

SELECT OBJECT_NAME(A.OBJECT_ID),avg_fragmentation_in_percent,* 
FROM SYS.DM_DB_INDEX_PHYSICAL_STATS(DB_ID(),NULL,NULL,NULL,NULL) A
INNER JOIN SYS.INDEXES B on a.index_id = b.index_id
AND A.OBJECT_ID= B.OBJECT_ID 
AND database_id = DB_ID()
AND (index_type_desc ='CLUSTERED INDEX' or index_type_desc ='NONCLUSTERED INDEX')
ORDER BY 2

To Reorganize the Index can use the below code
ALTER INDEX INDEXNAME
ON TABLENAME REORGANIZE

Useful Links

1. Fragmentation and Defragmentation steps video