TSQL Basics Part 4: RIGHT OUTER JOIN – Video Instruction Thu, 27 May 2021 This is part 4 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common use Read more… Checking job history log …
So you have upgraded to SQL Server 2019, and figuring that you got the new version, you may as well install all the features, including R, Python and Java, but then when you try and do that service pack update you have problems updating and the service pack just hangs installing the SPO.cab. After several retries and searching around you …
Uninstalling R, Python and Java on SQL Server 2019 Read more »
This is part 4 “right outer JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common uses for joins, such as replacing a not in clause with join to get the same results with …
TSQL Basics Part 4: RIGHT OUTER JOIN – Video Explanation Read more »
One of the important settings on SQL Server is the job history log size and the maximum rows per job. Without these set accurately you may not be able to track down job failure issues. These are easy to locate through the SSMS dialogs, but if you are managing many servers you may not want to dig through all the …
This is part 3 on left outer JOIN of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common uses for joins, such as replacing a not in clause with join to get the same results …
TSQL Basics Part 3: LEFT OUTER JOIN – Video Instruction Read more »
I have been doing more and more replication work lately, and when recently testing some replication work I needed to create and drop some test databases and re-test the replication work. After configuring a database for replication, then deleting the publisher and the subscriber I attempted to drop the database and get the following error: Msg 3724, Level 16, State …
Cannot drop the database because it is being used for replication Read more »
This is part 2 “inner JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common uses for joins, such as replacing a not in clause with join to get the same results with better …
TSQL Basics Part 2: Inner Join – Video Explanation Read more »
This is part 1 “basic JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common uses for joins, such as replacing a not in clause with join to get the same results with better …
TSQL Basics Part 1: Basic JOIN – Video Explanation Read more »
One of the common task that I have come across is the need to convert a list of results into a comma separated list. There are many ways to use this, one if which is in reports. Download the AsCSV.sql sample here. Often times I have told developers, here is how you do it, and if you Google on it …
Converting part of a result set to a comma separated list Read more »
Here listed is the current percentages of SQL server versions running our Daily Check-up with Database Health Monitor. Compare this month’s percentages against Last Month’s Percentages