Monthly Archives: July 2017

Decimal datatype rounding

By | July 17, 2017

Recently I was asked this question about how decimal is rounding off values when doing a simple calculation. The question was I am not able to find why output is getting round off in case of DECIMAL(38,0) but not in case of DECIMAL(37,0). As per BOL, decimal 37 and and 38 both should be having… Read More »

Identity value skips after restart

By | July 13, 2017

Recently a client of mine had complained to me about an issue they were facing when restarts happen on a system. After a restart the system skips the identity value by a 10 – 1000 depending on the data type of the identity column. This was a known issue in SQL 2012 and was touted… Read More »

BootMgr missing – 3 days of Hell

By | July 5, 2017

Just came out of a real deep mess after my laptop crashed 3 days back. The issue was a fairly common one but none of the solutions found on the internet were working and I had to fix things with extreme prejudice. All my data for the last 5 years exits on the same laptop.… Read More »