One of my blog readers asked me “Is there a way to extract only the number after the decimal point?”. For example, in decimal number 45.90, 45 is the precision and 90 is the scale value. There are several methods to get this done Let us create this dataset CREATE…
Read MoreSQL SERVER – Are Power Options Slowing You Down? – Notes from the Field #095
[Note from Pinal]: This is a 95th episode of Notes from the Fields series. When it is about tuning SQL Server, we always look at the configuration of the SQL Server. However, there are few settings of the operating system can also impact the performance of the SQL Server. I recently…
Read MoreSQL SERVER – Script: Finding queries without JOIN Predicates
I have been in developer’s shoes for close to 5+ years before reinventing myself to do things that made me even better in coding. It is a tough challenge these days being a developer. The life around you and the technology is changing so rapidly that we seldom get time…
Read MoreInterview Question of the Week #033 – How to Invalidate Procedure Cache of SQL Server?
Question: How to Invalidate Procedure Cache in SQL Server?
SQL Authority News – 100 Million Views and Onwards
I will always remember August 20, 2015 as a landmark milestone for SQLAuthority.com. On August 20th, this blog crossed 100 Million Views. When I started this journey on November 1, 2006, I had no idea that there will be over 100 Million Views on this blog. I am indeed very proud…
Read MoreSQL SERVER – Rewriting Database History – Notes from the Field #094
[Note from Pinal]: This is a 94th episode of Notes from the Field series. When I read the title of this article – I was extremely intrigued with it – Rewriting Database History! When I was a kid, history was my favorite subject and till today when I have to deal…
Read More


