Outsourcing – Outsourcing is subcontracting a process, such as product design or manufacturing, to a third-party company. Outsourcing involves the transfer of the management and/or day-to-day execution of an entire business function to an external service provider.
SQL SERVER – INNER JOIN using LEFT JOIN statement – Performance Analysis
Just a day ago, while I was working with JOINs I find one interesting observation, which has prompted me to create following example. Before we continue further let me make very clear that INNER JOIN should be used where it can not be used and simulating INNER JOIN using any…
Read MoreSQLAuthority News – TOP Downloads – Bookmark
Recently I have gotten many, many requests for SQL Server Interview Questions and Answers as well as related articles. It seems many people are looking for Job or appearing for an interview at this time of the year. I have included lists of the my top downloads in the sidebar of the blog, still I receive many curious questions as side bar does not show up in the RSS feed.
Author Visit – MVP Open Day 2008 – Goa – November 15-17
I will be attending MVP Open Day 2008 in Goa from November 15 to November 17. I am eagerly waiting to attend the Open Day. If you are in Goa during that time we can meet sometime in evening after sessions are over. Following is the comics related to MVP Open Day 2008.
SQLAuthority News – Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations
Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering TCO and maintaining or improving Quality of Service. Through a series of test scenarios that are representative of SQL Server application fundamentals, this document provides best practice recommendations…
Read MoreSQL SERVER – Fix : Error : Incorrect syntax near. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel
I have seen developers confused many times when they receive the following error message. Incorrect syntax near. Let us learn.
SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept
This article is inspired from two sources. Let us learn today about how to swap variables by updating everything at once concepts.
1) My year old article – SQL SERVER – Effect of TRANSACTION on Local Variable – After ROLLBACK and After COMMIT
2) Discussion with SQL Server MVP – Jacob Sebastian – SQLAuthority News – Author Visit – SQL Hour at Patni Computer Systems
I usually summarize my article at the end, but this time let me summarize first and we will understand the article next.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.