This select will be useful for developers/ database designers / DBAs to find the rowlength instantly. This select also makes use of system function to get rid of joins.
Only for sql7 and up.
2002-03-27
2,843 reads
ravinder_k@hotmailcom, 2002-04-30
This select will be useful for developers/ database designers / DBAs to find the rowlength instantly. This select also makes use of system function to get rid of joins.
Only for sql7 and up.
select sum(length) from syscolumns where id = object_id('TableName')
You rated this post out of 5. Change rating
2002-03-27
2,843 reads
This short and simple script is a very fast way to count the rows in all your indexed tables. I ran it against a 2-gigabyte database containing large tables (some with over a million rows!), and it returned results in under a second.
2002-03-12
2,852 reads
It calculates log free space in mb and in percent for all databases, and also show the quantity of different objects for one databases.
2002-02-02
2,747 reads
I wanted to be able to use info about an operating system file in TSQL. So I wrote this stored procedure that uses the special stored procedures xp_fileexist and xp_getfiledetails. This can tell if a file or folder exists, and if it is a file what is its size, created date and time, last written […]
2002-02-01
1,227 reads
This stored procedure reads the file names from a directory and stores just the names in a given table. It returns also the number of files present. The sp uses xp_cmdshell and so permissions are restricted to sysadmins and SQLAgentCmdExec. You can test with the following: Create Table ##tmp2 ( fldx nvarchar(255) ) Declare @FilePath […]
2002-02-01
1,960 reads