In this blog post, we will learn about how to fix the performance issue with the malicious Wait Type. Comprehensive Database Performance Health Check
SQL SERVER – Email from Blog Reader – Not a Potential Bug in SQL – Puzzle
Few days ago, I received wonderful email from blog reader and it was like good puzzle. I enjoyed solving this puzzle. I did not write the name of the blog reader because I am not sure if he wants his name here or not. Please read this article and run…
Read MoreSQL SERVER – Correlated and Noncorrelated – SubQuery Introduction, Explanation and Example
A correlated subquery is an inner subquery which is referenced by the main outer query such that the inner query is considered as being executed repeatedly. Example: ----Example of Correlated Subqueries USE AdventureWorks; GO SELECT e.EmployeeID FROM HumanResources.Employee e WHERE e.ContactID IN ( SELECT c.ContactID FROM Person.Contact c WHERE MONTH(c.ModifiedDate)…
Read MoreSQL SERVER – Fix: Error 130: Cannot perform an aggregate function on an expression containing an aggregate or a subquery
Fix: Error 130: Cannot perform an aggregate function on an expression containing an aggregate or a subquery Following statement will give the following error: “Cannot perform an aggregate function on an expression containing an aggregate or a subquery.” MS SQL Server doesn’t support it. USE PUBS GO SELECT AVG(COUNT(royalty)) RoyaltyAvg…
Read More
SQL Server Interview Questions and Answers – Part 3
Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.