[Note from Pinal]: In this episode of the Notes from the Field series database expert Ryan Adams explains a very critical error user receive when binding network error. Ryan is one guy who spends more time with real world issues with SQL Server than anything else. He has mastered the art of resolving complex errors and document them so easily that one can’t find anywhere else. In this blog post Ryan addresses a very interesting error related to binding network error. Read the experience of Ryan in her own words.
SQL SERVER – Add failover cluster node fails with “number of cluster nodes supported for edition”
A lot of my blog readers contact me via comments and I try my best to reply to all of them. Sometimes issue is so interesting that I ask them to contact via email. This blog is result of such an interaction. Asif (name anonymized) was trying to Add third…
Read MoreSQL SERVER – Timeout expired. The timeout period elapsed prior to completion of the operation
Today we are going to learn about how to fix the error: Timeout expired. The timeout period elapsed prior to the completion of the operation.
SQL SERVER – Why is My Query Switching to Row Processing and Not Doing Batch Processing?
Some of the learnings can lead to another exploration when someone does stump you with something you didn’t know. To understand the basics of batch mode and row mode, read the blog SQL SERVER – ColumnStore Index – Batch Mode vs Row Mode where I have explained the concepts. This…
Read MoreInterview Question of the Week #055 – How to Convert ASCII to DECIMAL or DECIMAL to ASCII?
Question: How do you convert ASCII to DECIMAL or DECIMAL to ASCII? Answer: ASCII – Returns the ASCII code value of the leftmost character of a character expression. CHAR – Fixed-length non-Unicode character data with length of n bytes. Examples: --Decimal to ASCII SELECT CHAR(80)+CHAR(73)+CHAR(78)+CHAR(65)+CHAR(76) ASSQLAuthorityAuthor GO --ASCII to Decimal…
Read MoreSQL SERVER – Script: Change Service Account Using WMI / SMO
Last week I wrote a post where my friend faced problem because he changed the service account of SQL Server from services. mass rather than SQL Server Configuration Manager. Let us learn how to change service account using WMI/SMO.
SQL SERVER – 2016 – Creating Additional Indexes with Clustered ColumnStore Indexes
Every version of SQL Server brings new capabilities that enhance the features that were introduced in the previous versions. I am sure the team is working based on the feedbacks given by customers as they starting using the new capability. As I was scanning through some of the enhancements that…
Read More
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.