Useful tips for everyday
What is SQL Service Broker used for? SQL Service Broker (SSB) is a powerful asynchronous queuing and messaging infrastructure available in all editions of SQL…
Can you do a count distinct in Excel? You can use the combination of the SUM and COUNTIF functions to count unique values in Excel.…
What happens if full text search is not installed? ELSE ‘Full-Text is NOT installed.’ If it appears that Full-Text is not installed, you should consider…
How do I find non-ASCII characters? Notepad++ tip – Find out the non-ascii characters Ctrl-F ( View -> Find ) put [^-]+ in search box.…
How do you sum total in SQL? SELECT SUM(salary) AS “Total Salary” FROM employees WHERE salary > 25000; In this SQL SUM Function example, we’ve…
How do I add 10% to a price in SQL? The standard way of expressing this is: update products set price = price * 1.1…
What is the difference between append and overwrite? If Append is set to true , records are appended to the file. If Append is set…
What is count and distinct count? Count is the total number of values. Count Distinct in the number of unique values. Count Distinct will always…
How to import multiple CSV files to a Postgres table? I’m looking to import a folder of over 100+ csv files into one table on…
How does a semaphore wait work? A simple way to understand wait (P) and signal (V) operations is: wait: Decrements the value of semaphore variable…