I have mentioned the history of NorthWind, Pubs and AdventureWorks in my previous post SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases. I have been receiving very frequent request for NorthWind Database for SQL Server 2005 and installation method.
SQL SERVER – Easy Sequence of SELECT FROM JOIN WHERE GROUP BY HAVING ORDER BY
I was called many times by Jr. Programmers in team to debug their SQL. I keep log of most of the problems and review them afterwards. This helps me to evaluate my team and identify most important next thing which I can do to improve the performance and productivity of…
Read MoreSQL SERVER – Explanation SQL SERVER Hash Join
Hash Join works with large data set. I have seen this join used many times in data warehouses applications as well as data mining algorithms. While its characteristics are similar to merge join it does not required ordered result set to join. Hash join requiresequijoin predicate to join tables. Equijoin…
Read MoreSQL SERVER – Fix : Error 8629 The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time.
Error : 8629 The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time.
SQL SERVER – Download 2005 Books Online (May 2007)
Microsoft has merged SQL Server 2005 Expressed to SQL Server 2005 Books Online. New Version of SQL Server 2005 Books Online is released on June 12, 2007. Download SQL Server Books Online (BOL) Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – Recovery Models and Selection
SQL Server offers three recovery models: full recovery, simple recovery and bulk-logged recovery. The recovery models determine how much data loss is acceptable and determines whether and how transaction logs can be backed up. Select Simple Recovery Model if: * Your data is not critical. * Losing all transactions since…
Read MoreSQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes
While searching WIKI I came across this oracle WIKI. I found this very funny. I have taken few quotes from this site. There are lot more stuff there. The degree of normality in a database is inversely proportional to that of its DBA. Program complexity grows until it exceeds the…
Read More
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.