I have described how to uninstall SQL Server 2017 running on Redhat Linux server in my last article. Here, i will explain how to remove or uninstall SQL tools (sqlcmd and bcp utilities) from red hat linux machine. Both utilities...
We all know how to install SQL Server 2017 on RedHat Linux. Here I will explain step by step process to uninstall SQL Server 2017 on RedHat Linux 7.3 server. Read More on SQL Server Installation on Linux Servers Installing...
Today, I got Microsoft SQL Server error 4064 while I was trying to connect to my SQL Server Instance using my login id techyaz. Read this article to fix this SQL Server error 4064. The error text of this error...
This article is part of SQL Server interview questions & answers series. Today, i am covering SQL Server Interview Questions & Answers on Indexes. You can have a look at the last few series of interview questions and answers on different...
If you want to combine output from multiple tables or queries into one result set, you can do this using an operator known as UNION. A UNION is used to extract rows based on some conditions specified whereas UNION ALL...
Disk I/O problems are some of the most difficult problems to diagnose and to debug. Here I am going to discuss about perfmon disk counters that will help us in diagnosing the disk related issues. I will segregate the values...
Last week, we found some slowness in one of our database server. When we analyzed the database server, we found poor disk performance where I/O requests taking longer than 15 seconds to complete. Below messages were logged multiple times in error...
Today, I got below Microsoft SQL Server error 3023 when I was trying to manually shrink a log file. The error details are given below: Shrink failed for LogFile ‘Logfile_Name”. Backup, file manipulation operations (such as ALTER DATABASE ADD FILE)...
This is very interesting topic. How to Avoid Page Split in SQL Server? Let’s start with basics. Page split is a resource intensive operation and causes fragmentation that leads to poor performance in terms of increased I/O operations. We should...
Fragmentation exists when indexes have pages in which the logical ordering, based on the key value, does not match the physical ordering inside the data file. Heavily fragmented indexes can degrade query performance and cause your application to respond slowly....
Lot of SQL Server resources ask what is the best value for fill factor in SQL Server and should we change its value from default to some other value? On high level, generally we should not change fill factor value...
SQL Server Indexes are similar to book indexes that we use to search any content in that book. They are very useful in faster data retrieval or data access. We create index on columns of tables or views. An index is...
I am working on a project where we are migrating Oracle databases to SQL Server for SAP applications. We are using SAP migration tools to migrate these databases and we are not using SSMA for Oracle in this migration. These...
I have described step by step process to install SQL Server 2017 on Ubuntu server in my last articles. Here I will explain how to install sqlcmd and bcp utilities that comes under SQL tools on Ubuntu server that is...
In last tip, I have explained about new features introduced in SQL Server 2017. SQL Server support on Linux based operating systems is one of the new feature introduced in SQL Server 2017. Here, I will describe all those missing...
