Applying a patch is something which is part of everyone’s life in the software industry. One of my clients reported below error related to Patch Installation Error.
Identify Used Space in Log File- Interview Question of the Week #090
Question: How to identify Used Space in Log File?
Answer: Use following command to display used log file size and total used space in the log file.
PowerShell – Reading Tables Data Using Script
Earlier in this blog, I have written a number of posts by using PowerShell. The more you play around with this scripting language more are the hidden gems that come out. Personally for me, everyday is like a new learning that needs to be discovered working with SQL Server and PowerShell.
SQL SERVER – How to Join a Table Valued Function with a Database Table
Just another day I received following question and I find it very interesting. I decided to try it out on SQL Server 2016’s new WideWorldImporters database. The question was – “How to Join a Table Valued Function with a Database Table?” This is indeed very interesting as this particular feature was introduced in SQL Server 2008, so what you will see in this blog post applies to every version of SQL Server after SQL Server 2008.
SQL SERVER – Set AUTO_CLOSE Database Option to OFF for Better Performance
As many of you know, I am an indecent SQL Server Consultant, who purely focus on SQL Server Performance. Every single day, I keep two slots each hour long available for users who need my help urgently. I never ever pre-book them because, I believe it is critical to help people who needs help NOW. Well let us learn in this blog post about how I recently helped a customer to improve performance by turning off AUTO_CLOSE Database Option.
SQL SERVER – How to Hide Number of Rows Affected Message? – SET NOCOUNT
In this blog post, we are going to talk about how to hide the number of rows affected messages with the help of SET NOCOUNT.
SQL SERVER – Puzzle – Change in Date Format with Function
Last week we had amazing time with an interesting puzzle about Datetime. You can see the puzzle over here. The puzzle was extremely well received and lots of people asked me to bring another puzzle which can help us learn something new. Looking at the request of everyone, here is another very simple puzzle with Date Format.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.