June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle – Solution

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks
Best Practices, SQL Scripts
Yesterday we looked at Puzzle and I did got great response to this question. Very interestingly not many got it right. First go through the puzzle first and then come back here and read answer. Read Original Interview Question and Puzzle. Question: Select all the person from table PersonColor who…
Read More

SQLAuthority News – SQL SERVER 2008 Upgrade Technical Reference Guide Download

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, SQL Download
Note:   SQL SERVER 2008 Upgrade Technical Reference Guide Download by Microsoft This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended…
Read More

SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQL Download
Note:   Download Microsoft SQL Server Management Pack for Operations Manager 2007 by Microsoft The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The…
Read More