Here Aamir Hasan has demonstrate how to change TCP/IP port for SQL Server 2008 and SQL Server 2012 More

The following script demonstrates how to declare variables and initialized values in one statement in SQL Server 2008. More

SQL Server 2008 R2 Service Pack 1 has released, SQL Server 2008 R2 issues has been fixed in this released. More

In this example, you will see how to find the size of table from a database. SQL server gives you build in system store procedure named SP_SPACEUSED. More

A unique identity in each row in a table is called Primary key... More

how you can use to view and monitor your Resource Governor configuration More

yesterday, some one asked me , how to get the file size of all databases in MS SQL 2008 using SQL query, So i have decided to write a query in this blog to help to all those developers who don't know. T-SQL Script SELECT DB_NAME(DATABASE_ID) AS [DATABASE NAME] , CAST(( CAST(SIZE * 8 AS FLOAT) ) / 1024 AS VARCHAR) + ' MB' AS [SIZE] FROM SYS.MASTER_FILES Output

In this example, i have told you how to get top 5 random records using T-SQL query. More

How to get All store procedure list from a database in MS SQL 2005/2008... More

Yesterday some one ask me, how can i count a vowels from a string in MS SQL 2008.Here is the following SQL function to return count of vowels from a given input string. User defined function CREATE FUNCTION COUNT_VOWEL ( @STRING NVARCHAR(MAX) ) RETURNS INT AS BEGIN DECLARE @I INT DECLARE @COUNT INT SET @COUNT = 0 SET @I = 1 DECLARE @ANS NVARCHAR(MAX) DECLARE @VOWEL NVARCHAR(6) SET @VOWEL = 'AEIOU' WHILE @I <= LEN(@STRING) BEGIN SET @ANS = SUBSTRING(@STRING, @I, 1) IF @ANS = 'A' OR @ANS = 'I' OR @ANS = 'O' OR @ANS = 'U' BEGIN SET @COUNT = @COUNT + 1 END SET @I = @I + 1 END RETURN @COUNT END     Queries SELECT DBO.COUNT_VOWEL('AAMIR HASAN') AS [VOWELS(S)] SELECT DBO.COUNT_VOWEL('MAHWISH HASAN') AS [VOWELS(S)] SELECT DBO.COUNT_VOWEL('SABA KHAN') AS [VOWELS(S)] SELECT DBO.COUNT_VOWEL('BILL GATE') AS [VOWELS(S)] SELECT DBO.COUNT_VOWEL('CYNDY KRYSTYN') AS [VOWELS(S)] Output Download You can download source code from Here.