Useful tips for everyday
What is the database schema for pricing products? Database Schema for Pricing Products (packages, promotions, qty based, limited time offer…) I’m working on a new…
Should you use GUID as primary key? GUIDs may seem to be a natural choice for your primary key – and if you really must,…
How MongoDB choose winning plan? MongoDB runs the query optimizer to choose the winning plan and executes the winning plan to completion. In “allPlansExecution” mode,…
What should I do if I have multiple applications using the same database? Learn how to partition data. If you have multiple applications hitting the…
Can you have multiple SQL Server instances? You can install multiple instances of SQL Server, or install SQL Server on a computer where earlier SQL…
Can select queries cause deadlock? SELECT queries take shared locks on the rows they analyze. Shared locks may conflict exclusive locks from update/delete/insert statements. Two…
What is difference between in and any in SQL? Select Ename, Sal, Deptno from Emp Where Sal IN (Select Min(Sal) From Emp Group By Deptno);…
Can we return value from stored procedure? A stored procedure does not have a return value but can optionally take input, output, or input-output parameters.…
How to convert date to different or specific format? Convert date to different format with formulas If you want to use formula to convert date…
Why is Azure SQL Server Authentication so slow? Ones with instance LOGIN’s and ones that have only access to a single database (“contained” database users).…