Category Archives: Developer

The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information Error 8623 / 8632

The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer [...]

250+ SQL Queries Interview Question Answers

SQL Interview Queries Question / Questions Answers This is a never ending topic and there is no limit to questions that all depends on profile and interviewer. I am trying my level best to divide questionnaire based on Experience in Query Writing skills 5+ Years of Experience (Expert) 2-5 Years of Experience (Intermediate) 1-2 Years [...]

50 Database Optimization TIPS

Database Optimization TIPS helps any system to perform work efficiently and quickly. SQL Server Performance tuning is very wide subject and there are a lot of different pieces to troubleshoot a poor performing application. Connectivity / Network Server Hardware Operating System SQL Server Database Query The basic principle of Optimization / Tuning is Profile First [...]

DELETE | UPDATE with JOIN SQL Table

Summary : We can write all your UPDATE, DELETE query same way as we write SELECT Query [*Most of the time],  this means we can use also UPDATE / DELETE using JOIN as well. I am writing this because, Today I was working with my development team to fix some data. A task was being [...]

SQL Server Management Studio (SSMS) is slow

My SQL Server Management Studio (SSMS) takes approx. 2-3 minutes to open, is there any way to speed that up? YES, we can speed up the opening time for SQL Server Management studio by taking some preventive actions. When ever we open a SQL Server Management Studio, if performs the following actions Initiate a windows [...]

How to use SSIS Log Analyzer tool ? (Video)

While Optimizing SSIS packages, analyzing package log is really a pain as these log files are flat files and long so I lost focuses while reviewing. I was looking for a smart tool to analyze the my SSIS logs and figured out this utility (SSIS Log Analyzer) , which is freely available at Microsoft. This [...]

SQL Script for Service Broker to get Service Queue Details

SQL Script to get Service Queue details, The following script will give us the following details related to aall services Service Name Queue Name Max Readers Activation Procedure Contract Name Sent by Initiator Sent by target Message Name Validation Description Xml Schema Column Name SQL Script to get Service Details /*——————————————————————————————————————————-Description : This stored procedure [...]