I always recall my fun days after talking to my friends and blog readers. Recently killed/rollback discussion came back when my close DBA friend called me for help. Our discussion was worth blogging.
Interview Question of the Week #034 – What is the Difference Between Distinct and Group By
Question: What is the difference between DISTINCT and GROUP BY? Answer: A DISTINCT and GROUP BY usually generate the same query plan, so performance should be the same across both query constructs. GROUP BY should be used to apply aggregate operators to each group. If all you need is to remove…
Read MoreSQL SERVER – Remove All Characters From a String Using T-SQL
In this post, How to Remove All Characters From a String Using T-SQL? we have seen How to Remove All Characters From a String Using T-SQL. But it only removes characters from the string. What if the string has some other special characters? Here is the method that handles this SET NOCOUNT ON…
Read MoreSQL SERVER – Different Methods to Extract Scale Part From Decimal Number
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 MoreSQL SERVER – Fix @@ServerName Property Value When Incorrect
Our software systems are funny and sometimes give us strange values. I don’t quite venture out trying to fiddle around with system level properties on my servers, but having said that, this query had come from one of my colleagues who was working on his SQL Server instance and he…
Read More