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

This example demonstrates how to rename the store procedure using Transact-SQL... More

This example demonstrates how to delete a store procedure from your database.... More

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

n this example, you will see how to get month name from input data. I have used build in function named DATETIME. More

Most of developers don't know that where to use SET NOCOUNT { on | off }. 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

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