One of the interesting features of PostgreSQL database is the ability to handle Unicode characters. In SQL Server, to store non-English characters, we need to use NVARCHAR or NCAHR data type. In PostgreSQL, the varchar data type itself will store both English and non-English characters.
SQL SERVER – Update Table Statistics in Parallel with FULLSCAN
SQL Server Performance Tuning is a much simpler job if you know exactly where to look for and how to tune the configurations. Here is the real world scenario which I encountered during the recent Comprehensive Database Performance Health Check. During the performance tuning exercise, we realized that for one of the table we needed to update the statistics with the full scan as the table was a very critical table for their business. However, every time whenever we were running the update statistics job, the query was running very slow and almost never finish.
Frequently Asked Questions for SQL Server Performance Tuning Practical Workshop for EVERYONE
Earlier this week I announced my very first online training class open for (US, EU, Asia, and Everywhere) over here: SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019, and so far I have received an amazing response. We have sold quite a few seats in the very first few minutes of announcing the class.
SQL SERVER – New Parallel Operation Cannot be Started Due to Too Many Parallel Operations Executing at this Time
One of my clients contacted me via my On Demand (50 Minutes) offering and they were seeing below error message in ERRORLOG – New parallel operation cannot be started due to too many parallel operations executing at this time.
First Online Open for All Class: SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019
I have been delivering SQL Server Performance Tuning Practical Workshop for various organizations and it has been an extremely popular class so far. I get lots of requesting that I should deliver it for individuals. The only reason, I never scheduled it for individuals was the content of the class was customized carefully for a specific organization. However, I believe it is time now when I can announce this class to everyone.
SQL SERVER – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You do not Have Permission
As they say – There are more ways than one to skin a cat. In this blog we will find another method to fix an error which you might see during SQL upgrades – Cannot drop the assembly ‘ISSERVER’, because it does not exist or you do not have permission.
What is Consolidation of Index? – Interview Question of the Week #212
Question:Â What is Consolidation of Index?
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.