rajendra guptaJan 7, 20221 minSQL Server Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’ In SQL Server Always On Availability Group environment endpoint connection issue is a common problem and it needs to be resolved by...
rajendra guptaJan 7, 20221 minWhat is SET NOEXEC ON in the T-SQL statement?Do you want to compile the query without executing it? If yes, you can use SET NOEXEC ON at the beginning of the T-SQL statement.
rajendra guptaJan 7, 20221 minT-SQL Script to find out Nth highest salary It is a standard SQL interview question where the interviewer asks to write a query that finds Nth highest salary from the employee table. H
rajendra guptaJan 6, 20221 minSteps to modify default SQL Server Management Studio - Select Top 1000 Rows and Edit Top 200 RowsDo you want to modify the default Select Top 1000 Rows and Edit Top 200 Rows configuration in SQL Server Management Studio? Read more
rajendra guptaJan 5, 20221 minGet a list of installed SQL Server Components with SQL Server Discovery ToolGet a list of installed SQL Server Components with SQL Server Discovery Tool