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 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 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
{#advanced_dlg.about_title}
by Aamir Hasan   on Tuesday, November 2, 2010
How to get All store procedure list from a database in MS SQL 2005/2008... More
{#advanced_dlg.about_title}
by Aamir Hasan   on Sunday, July 11, 2010
Word Warp is the automatic breaking of text across lines. Text in a line automaticlly moves to the next line when length exceeds the postion of the right indent marker. If you are writing a query and if it exceed the length of the right indent marker then it will automatically shift to next line. To trun on the word warp in MS SQL 2008, open your MS SQL 2008 , at top menu of MS SQL 2008  click Edit -> click Advanced and then click Word Warp as shown in below figure , to turn off the Word Warp, click Word Warp.
Advertizement 1
Advertizement 2
Advertizement 3
Advertizement 4
Advertizement 5