Apr 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Union vs. Union All – Which is better for performance?

Pinal Dave
SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Download, SQL Scripts
This article is completely re-written with better example SQL SERVER – Difference Between Union vs. Union All – Optimal Performance Comparison. I suggest all of my readers to go here for update article. UNION The UNION command is used to select related information from two tables, much like the JOIN…
Read More

SQL SERVER – Script to Determine Which Version of SQL Server 2000-2005 is Running

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts
To determine which version of SQL Server 2000/2005 is running, connect to SQL Server 2000/2005 by using Query Analyzer, and then run the following code: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') The results are: The product version (for example, 8.00.534). The product level (for example, “RTM” or “SP2”). The edition…
Read More

SQL SERVER – What is New in SQL Server Agent for Microsoft SQL Server 2005

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Download, SQL Error Messages, SQL Server Agent, SQL Utility
I came across this interesting and detailed article ‘What’s New in SQL Server Agent for Microsoft SQL Server 2005‘ on Microsoft TechNet. This article describes Security Improvements, New Roles in the msdb Database, Multiple Proxy Accounts, Performance Improvements, Performance Counters, New SQL Server Agent Subsystems, Shared Schedules, WMI Event Alerts,…
Read More