If your goal is to retrieve the rows that are in the top quartile of the data, may I sugges...
The templates are pre-mapped for the fields noted in Method 2, so will save you some time from having to manually map the fields. To use a SQL Trace template, follow these steps: 1. Determine what version of SQL Server you have and double-click the ...
COALESCE is one of the tools you have in SQL Server to work with NULL values. It may not be the first one you think of, but it can be a very good choice. In this tip I will provide examples of how you can use COALESCE to peacefully coexist with NULL values. Before we dig in to...
Some applications, however, can benefit from having changes divided into batches. Consider the following scenario for a synchronization application: A large number of clients that use SqlCeSyncProvider synchronize periodically with a server that uses SqlSyncProvider. Each client has a limited amount ...
MySQL installed and secured on the server, as outlined inHow To Install MySQL on Ubuntu 20.04. This guide was verified with a newly-created user, as described inStep 3. Note: Please note that many RDBMSs use their own unique implementations of SQL. Although the commands outlined in this tut...
To find the error in the MSI file, search for “value 3” and usually the errors can be found close to the string. ConfigurationFile.ini Overview The configuration file contains the input settings that are provided during installation. It can be used to restart the installation without havin...
Let’s see how this works in practice. 1 2 3 4 5 SELECTorder_id,order_date,customer_name,city,order_amount, DENSE_RANK()OVER(ORDERBYorder_amountDESC)[Rank] FROM[dbo].[Orders] As you can clearly see above, the same rank is given to two identical records (each having the same order...
It is not unheard of people having problems with installing SSMS, although I'm not sure that I recognise this exact description. When it comes to SQL Express, in C:\Program Files\Microsoft SQL Server\nnn\Setup Bootstrap\Log there is a folder for each installation attempt.nnnhere...
MySQL installed and secured on the server, as outlined inHow To Install MySQL on Ubuntu 20.04. This guide was verified with a newly-created user, as described inStep 3. Note: Please note that many RDBMSs use their own unique implementations of SQL. Although the commands outlined in this tut...
As you can see this is a much easier way to read the error logs and to also look for a specific error message without having to use the Log File Viewer. Add this to your monitoring routine where this is run daily to search for errors or issues. ...