TSQL Function to encode HTML Text

Use this TSQL function to encode HTML text

Posted Under: How-To, TSQL, Tips, Utility Functions
This post was written by namwar on January 20, 2009 Comments (0)

How to use more than 4GB RAM on SQL Server?

This article describes the procedure to make sure your SQL Server is able to use more than 4GB of RAM, if installed

Posted Under: How-To, Information, SQL Server 2005, SQL Server 2008, Tuning
This post was written by namwar on January 15, 2009 Comments (1)

TSQL Function to convert decimal to Hex, Octal or any other base

This TSQL function provides you the ability to convert a given integer into any target base. I have just updated the function with more meaningful names and added some comments to clear the logic.

Posted Under: How-To, SQL Server 2005, SQL Server 2008, TSQL, Utility Functions
This post was written by namwar on January 12, 2009 Comments (0)

Search all columns of all tables for a particular value

Here is the solution to search all columns of all tables for a given value

Posted Under: Blogroll
This post was written by namwar on January 8, 2009 Comments (1)

How to find relationship between tables

here is the script which lists the name of the parent table, child table, Referred table, foreing key table and name of the foreign key constraint.

Posted Under: How-To, Object Search, Query, SQL Server 2005, SQL Server 2008
This post was written by namwar on January 3, 2009 Comments (2)

Two quickest ways to find file information of a given database

Here are the two quickest ways to find file information about the given database

Posted Under: How-To, Query, SQL Server 2005, SQL Server 2008, System stored procedures, TSQL
This post was written by namwar on January 2, 2009 Comments (1)

Review of SQL Server 2005 Service Pack 3

Here is the brief overview of what is available in Service Pack 3 of SQL Server 2005

Posted Under: Information, SQL Server 2005
This post was written by namwar on January 1, 2009 Comments (0)