Category Archives: SQL SERVER 2008

TSQL Challenge

On the series on SQL challenges, below is the next puzzle/challenge and the requirement is to find out the person name who has both mango and apple Table 1: @Person contains Person NameTable 2: @PersonFruits contains the available fruits per … Continue reading

Posted in SQL SERVER 2008, T-SQL | Tagged , , , , , | Leave a comment

TSQL : Update columns with different values randomly

Continuing the series on SQL challenges. I came across a requirement from an online Tech forum where the request was to perform an update on a table column with a sequence of values randomly I have tried to write a … Continue reading

Posted in SQL SERVER 2008, T-SQL | Tagged , , , | 1 Comment

Query Multiple Servers – SQL Server 2008

In this thread I would like to share my experience with multi server queries, a few days ago I received a requirement to query both the development and production servers at a single instance in SQL Server 2008. In brief, … Continue reading

Posted in SQL SERVER 2008 | Tagged , , , , , , , , , | 1 Comment

Using database mail in sql server 2008

Previously, in one my threads I have explained how to configure database mail for various service providers [Google, Yahoo, Live, etc]. Now let’s see where this database mail can be used in a highly effective manner. Following are the areas … Continue reading

Posted in SQL SERVER 2008 | Tagged , , , , , , , , | Leave a comment

Database Mail – SQL SERVER 2008

DATABASE MAIL In this Article, I would like to show a feature from SQL SERVER 2008 which is used to send mail from the database, its DATABASE MAIL Let’s see how database mail works, and how to configure it for … Continue reading

Posted in SQL SERVER 2008 | Tagged , , , , , , , | 5 Comments