aspx Tutorial

NET Articles,jQuery demo, asp.net with jQuery, online tutorial,Jquery, SilverLight, Javascript, asp.net,JSON, MVC,.NET Articles,demo, Web Services,
Advertise Here

Toolbar

Get our toolbar!

Advertize



{#advanced_dlg.about_title}
by Aamir Hasan   on Tuesday, November 6, 2012
Here Aamir Hasan has demonstrate how to change TCP/IP port for SQL Server 2008 and SQL Server 2012 More
{#advanced_dlg.about_title}
by Aamir Hasan   on Friday, September 23, 2011
The following script demonstrates how to declare variables and initialized values in one statement in SQL Server 2008. More
{#advanced_dlg.about_title}
by Aamir Hasan   on Tuesday, August 23, 2011
This example demonstrates how to rename the store procedure using Transact-SQL... More
{#advanced_dlg.about_title}
by Aamir Hasan   on Saturday, August 20, 2011
This example demonstrates how to delete a store procedure from your database.... More
{#advanced_dlg.about_title}
by Aamir Hasan   on Monday, July 18, 2011
SQL Server 2008 R2 Service Pack 1 has released, SQL Server 2008 R2 issues has been fixed in this released. More
{#advanced_dlg.about_title}
by Aamir Hasan   on Sunday, March 27, 2011
n this example, you will see how to get month name from input data. I have used build in function named DATETIME. More
{#advanced_dlg.about_title}
by Aamir Hasan   on Thursday, March 10, 2011
Most of developers don't know that where to use SET NOCOUNT { on | off }. More
{#advanced_dlg.about_title}
by Aamir Hasan   on Thursday, January 13, 2011
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
{#advanced_dlg.about_title}
by Aamir Hasan   on Thursday, December 30, 2010
A unique identity in each row in a table is called Primary key... More
{#advanced_dlg.about_title}
by Aamir Hasan   on Friday, November 5, 2010
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
Advertizement 1
Advertizement 2
Advertizement 3
Advertizement 4
Advertizement 5