In versions prior to 2012, you need to use the CONVERT function with different styles to convert the date values into a different format. Let us learn about the FORMAT function in this blog post.
How to Add Column at Specific Location in Table? – Interview Question of the Week #126
Question: How to Add Column at Specific Location in Table?
Answer: Order of the column in the table should not matter.
SQL SERVER – Not Able to Kill SPID with KILL WITH STATUSONLY
Question: Why I am not able to KILL a SPID with command KILL (spid) WITH STATUSONLY?
SQL SERVER – Installation Error – Status Code: 183 Description: Cannot Create a File When that File Already Exists
One of my client was unable to install SQL Server 2014 on a Windows 2012 Cluster. They were using mount points with below the structure. Let us learn about installation error.
SQL SERVER – Quickest Way to Add LoopBack Linked Server for OpenQuery
Here is the question which I received the other day from a user who was trying to add a linked server pointing its own server as he wanted to use OpenQuery. Let us read his question in details.
SQL SERVER – How to Measure Page Splits Counter Value via T-SQL?
Question: How to Measure Page Splits Counter Value via T-SQL?
SQL SERVER – How to Update Two Tables in One Statement?
Question: How to Update Two Tables in One Statement?
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.