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 – Start SQL Server Instance in Single User Mode
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…
Read MoreSQL SERVER – Introduction to Force Index Query Hints – Index Hint – Part2
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…
Read MoreSQL SERVER – Introduction to Force Index Query Hints – Index Hint
This article, I will start with disclaimer instead of having it at the end of article. “SQL Server query optimizer selects the best execution plan for a query, it is recommended to use query hints by experienced developers and database administrators in case of special circumstances.” When any query is…
Read MoreSQL SERVER – Quickest Way to – Kill All Threads – Kill All User Session – Kill All Processes
More than a year ago, I wrote how to kill all the processes running in SQL Server. Just a day ago, I found the quickest way to kill the processes of SQL Server. While searching online I found very similar methods to my previous method everywhere. Today in this article,…
Read More
SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index
Today I came across very interesting observation while I was working on query optimization. Let us run the example first. Make sure to to enable Execution Plan (Using CTRL + M) before running comparison queries. USE [AdventureWorks] GO /* */ CREATE TABLE [dbo].[MyTable]( [ID] [int] NOT NULL, [First] [nchar](10) NULL,…
Read MoreSQL SERVER – T-SQL Script for FizzBuzz Logic
Following is quite common Interview Question asked in many interview questions. FizzBuzz is popular but very simple puzzle and have been very popular to solve. FizzBuzz problem can be attempted in any programming language. Let us attempt it in T-SQL. Definition of FizzBuzz Puzzle : Write a program that prints…
Read More