(Manoj Debnath) Macros are used for efficiency in C. The C++ language inherited them as a legacy. There are issues with the use of preprocessor macros, especially when used in C++.
Other News
Oops! – That SQL Query was not intended… Flashback
(Shinguz) It is Saturday night at 23:19. Time to go to bed after a hard migration day. Just a last clean-up query before finishing: Tap tap tap. Enter! – Oops!
How to install Oracle Linux on a Raspberry Pi – the easy way
(Gerald) In one of my past posts I showed how one can install Oracle Linux on a Raspberry Pi from a Mac via the command line.
Why you cannot use #Oracle’s SQL Developer to connect to #Exasol
(Uwe Hesse) Many of our customers are using Oracle together with SQL Developer, so this question comes up regularly: Can we use SQL Developer also for Exasol?
Importance of setting Fetched Rows size for Database Query using Golang
(Brendan Tierney) When issuing queries to the database one of the challenges every developer faces is how to get the results quickly. If your queries are only returning a small number of records, eg. < 5, then you don’t really have to worry about execution time. [membership level="0"] Register to Read [/membership]
SQL SERVER – Upgrade Error: The Server Principal is Not Able to Access the Database ‘msdb’ Under the Current Security Context
(Pinal Dave) As soon as SQL 2008 and SQL 2008 R2 went out of support, few of my clients contacted me to help them in fixing an error occurred during the upgrade.
Working on navigation when refactoring a legacy project with React Native
(Dmitry Kotlyarenko) This article is dedicated to navigation refactoring in mobile development. It provides examples of common problems, as well as ways to get out of difficult situations related to the work of navigation in mobile development with React Native.
Troubleshooting problems with joins in SQL Server 2017
Troubleshooting problems with joins in SQL Server 2017 If you have problems with joins in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. You may receive an incorrect result when you run a query that uses a parallel execution plan with Merge Semi join. This is SQL Server 2017 bug. To work around this problem, you...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Current database vs database locks
(Kenneth Fisher) I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is typically when they want to alter a database and need to get everyone out.
#0416 – SQL Server – Msg 8101 – Use column lists when working with IDENTITY columns
(Nakul Vachhrajani) I have often written about IDENTITY columns on my blog. Identity columns, most commonly used to implement auto-increment keys, have been around for more than a decade now.