Based on popular demand from my colleagues and you, the kind reader, I am currently writing a series of posts on the SQL Server Profiler. You can read the first part on What is a SQL Trace? Permissions, space requirements and launching the Profiler ....

I have publised my posts related to database backup history, restore history and also cleanup for the same. For the database backup we are performing using the maintenance plans or wizard. We cal also performing this database activity by scripts automatically...

We confused sometimes during write the code logic for SQL queries when we required some of top records from tables to implement in logic. This is very basic thing for the development and here i am going to demonstrate some of the options to get top records...

In the Query Analyser, set the Result mode to Text (Press CTRL+T) and run the following code set nocount on select space(17-len(replicate(char(37),no)))+ replicate(char(37),no*2-1) from ( select top 10 row_number() over (order by name) as no from sysobjects...

As we know, we can write case expression in SQL in two ways. As per BOL , defination of these two diffrent formats of CASE expression: - The simple CASE expression compares an expression to a set of simple expressions to determine the result. - The searched...

We are about to start the logic testing of TSQL Challenge 33 . We have created a sandbox for the tricky testing and you can find it here . Please take a look at the tricky data and expected results and let us know if you find anything incorrect. We will...

For the majority of us, maps represent a useful tool which we often use in daily life when we are looking for a specific landmark, shopping centre or street name in an unfamiliar town or city. For business, map is a good marketing tool to attract the...

This challenge involves generating a graph in TSQL. Your job is to write a query that generates the required graph representation of the data provided in an input table. ...