March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

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
All Articles 44-600x400

SQL SERVER – Restore Database Backup using SQL Script (T-SQL)

Pinal Dave
SQL Video
SQL Error Messages, SQL Restore, SQL Scripts, SQL Server, SQL Utility

In this blog post we are going to learn how to restore database backup using T-SQL script. We have already database which we will use to take a backup first and right after that we will use it to restore to the server. Taking backup is an easy thing, but I have seen many times when a user tries to restore the database, it throws an error.

Read More

SQL SERVER – SQL Server 2005 Samples and Sample Databases (February 2007)

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Coding Standards, SQL Download, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server Security
The samples download provides over 100 samples for SQL Server 2005, demonstrating the following components: Database Engine, including administration, data access, Full-Text Search, Common Language Runtime (CLR) integration, Server Management Objects (SMO), Service Broker, and XML Analysis Services Integration Services Notification Services Reporting Services Replication The samples databases downloads include…
Read More