SQL Tips and Tricks Archives - Page 427 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Restore Master Database – An Easy Solution

February 14, 2009

SQL Backup and Restore, SQL Scripts, SQL Server Security, SQL Utility

Today we will go over two step easy method to restore ‘master’ database. It is really unusal to have need of restoring the master database. In very rare situation this need should arises. It is important to have full backup of master database, without full backup file of master database…

SQL SERVER – Simple Example of Reading XML File Using T-SQL

February 13, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL XML

In one of the previous article we have seen how we can create XML file using SELECT statement SQL SERVER – Simple Example of Creating XML File Using T-SQL. Today we will see how we can read the XML file using the SELECT statement. Following is the XML which we…

SQL SERVER – Simple Example of Creating XML File Using T-SQL

February 12, 2009

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL XML

I always want to learn SQL Server and XML file. Let us go over a very simple example, today about how to create XML using SQL Server.

SQL SERVER – Technical Articles – Performance Optimizations for the XML Data Type in SQL Server 2005

February 11, 2009

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, MVP, SQL Index, SQL XML

I always wanted to learn XML and its usage. My friend and fellow MVP Jacob Sebastian is expert in XML, so if you are interested in XML please visit his blog here. If you are interested in performance optimization for XML Data type in SQL Server following article is must…

SQL SERVER – Start SQL Server Instance in Single User Mode

February 10, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio, SQL Server Security, SQL Utility

There are certain situation when user wants to start SQL Server Engine in “single user” mode from the start up. To start SQL Server in single user mode is very simple procedure as displayed below. Go to SQL Server Configuration Manager and click on SQL Server 2005 Services. Click on…

SQL SERVER – 2008 – Download Microsoft SQL Server 2008 Express with Tools Free

February 9, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQL Download, SQL Server Express, SQL Utility

Note: Download Microsoft SQL Server 2008 Express with Tools Free by Microsoft SQL Server 2008 Express Edition was much awaited version of SQL Server 2008. It is FREE and available to download from web. Microsoft SQL Server 2008 Express with Tools (SQL Server 2008 Express) is a free, easy-to-use version…

SQL SERVER – Introduction to Force Index Query Hints – Index Hint – Part2

February 8, 2009

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Index, SQL Scripts

In my previous article SQL SERVER – Introduction to Force Index Query Hints – Index Hint I have discussed regarding how we can use Index Hints with any query. I just received email from one of my regular reader that are there any another methods for the same as it…