i
Saksoft
Filter interviews by
Clear (1)
I applied via Referral and was interviewed before Dec 2023. There was 1 interview round.
Performance tuning in SQL store procedures involves optimizing the code to improve execution speed and efficiency.
Identify and eliminate unnecessary code
Use appropriate indexing to speed up data retrieval
Avoid using cursors and loops whenever possible
Optimize query execution plan
Consider using stored procedures for frequently executed queries
Index optimization in SQL Server involves creating, maintaining, and optimizing indexes to improve query performance.
Identify and create indexes on columns frequently used in WHERE clauses
Regularly update statistics to ensure the query optimizer has accurate information
Consider using included columns to cover queries that require additional columns not in the index key columns
Avoid over-indexing as it can lead to decre...
SQL Profiler is a tool used to monitor and capture SQL Server events and performance data.
SQL Profiler helps in identifying and troubleshooting performance issues in SQL Server.
It captures events like queries, stored procedures, errors, and more.
Allows users to analyze the captured data to optimize database performance.
Can be used to trace and monitor specific activities in real-time.
Helps in identifying slow queries a...
Temp tables are temporary tables used to store intermediate results, while CTEs are temporary result sets defined within a query.
Temp tables are physical tables that are created in the tempdb database and can be used multiple times within a session.
CTEs (Common Table Expressions) are temporary result sets that are defined within a query and can only be referenced within that query.
Temp tables persist until they are exp...
I applied via Recruitment Consulltant and was interviewed before Jun 2023. There was 1 interview round.
Top trending discussions
I applied via Naukri.com and was interviewed in Dec 2020. There were 3 interview rounds.
I applied via Recruitment Consultant and was interviewed before Aug 2020. There were 3 interview rounds.
I applied via Company Website and was interviewed in Nov 2020. There were 3 interview rounds.
Answers to questions related to Docker, AWS firewall types, and ELK Stack
To create a Docker file, start with a base image and add necessary dependencies and configurations
AWS has two types of firewalls: Network ACLs and Security Groups
ELK Stack is a combination of Elasticsearch, Logstash, and Kibana used for log management and analysis
I applied via Campus Placement and was interviewed before Jun 2021. There were 3 interview rounds.
Profit and losses, time
C language
I applied via Naukri.com and was interviewed before Nov 2020. There were 3 interview rounds.
based on 5 interviews
Interview experience
based on 46 reviews
Rating in categories
Senior Consultant
374
salaries
| ₹0 L/yr - ₹0 L/yr |
Consultant
289
salaries
| ₹0 L/yr - ₹0 L/yr |
Lead Consultant
163
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Consultant
97
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
52
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech