Home Whiteboard Graphing Calculator Online Compilers Articles Tools
Tutorials Courses Jobs
ayanangshu das

ayanangshu das

About

I am a project management, optimization, and simulation expert with over a decade of experience in the field. With an MBA in Operations Research from IIM Mumbai (NITIE), I have a deep understanding of mathematical modeling and optimization techniques. Driven by my passion for teaching, I have mentored numerous students and professionals, equipping them with the skills to tackle complex problems using Pyomo. As an instructor, I am committed to helping learners unlock their potential and achieve success in the fascinating world of optimization

1 Articles Published

Articles by ayanangshu das

1 articles

How to identify slow running queries in SQL Server?

SQL
ayanangshu das
ayanangshu das
Updated on 17-Mar-2025 412 Views

In a SQL Server database, slow-running queries can severely impact performance, leading to delays, timeouts, and increased server load. Identifying and optimizing these queries is crucial to ensuring a smooth and efficient database operation. Common reasons for slow queries include missing indexes, inefficient joins, high I/O operations, outdated statistics, and parameter sniffing issues. Prerequisites Before identifying slow queries, ensure you have the necessary access and tools: Database Administrator (DBA) Privileges − You need appropriate permissions to run diagnostic queries. SQL Server Management Studio (SSMS) − This tool provides execution plans ...

Read More
Showing 1–1 of 1 articles
« Prev 1 Next »
Advertisements