February « 2009 « SQL Server Journey with SQL Authority

Archive for February, 2009

SQL SERVER – Restore Master Database – An Easy Solution

Posted in Pinal Dave, SQL, SQL Add-On, SQL Authority, SQL Backup and Restore, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology on February 14, 2009 | 28 Comments »

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 it can not be restored. [...]

Read Full Post »

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL XML, T SQL, Technology on February 13, 2009 | 70 Comments »

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 will read using T-SQL: Following [...]

Read Full Post »

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL XML, T SQL, Technology on February 12, 2009 | 70 Comments »

I always want to learn SQL Server and XML. Let us go over very simple example today about how to create XML using SQL Server. Please also read related article here SQL SERVER – Simple Example of Reading XML File Using T-SQL. Following is the XML which we want to create: T-SQL Script to generate [...]

Read Full Post »

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

Posted in Best Practices, MVP, SQL, SQL Authority, SQL Documentation, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL XML, T SQL, Technology on February 11, 2009 | 1 Comment »

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 read for you. Performance Optimizations [...]

Read Full Post »

SQL SERVER – Start SQL Server Instance in Single User Mode

Posted in Pinal Dave, SQL, SQL Add-On, SQL Authority, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, SQL Utility, T SQL, Technology on February 10, 2009 | 31 Comments »

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 desired SQL Server instance and [...]

Read Full Post »

« Newer Posts - Older Posts »