Monthly Archives: January 2013

SQL Server – How big are my tables?

Code Snippet create table #t (     name sysname primary key clustered,     rows bigint,     reserved sysname,     data sysname,     index_size sysname,     unused sysname ); exec sp_MSforeachtable 'insert into #t exec sp_spaceused ''?'''; select     name,     rows,     convert( bigint, replace( reserved, ' kb', '' … Continue reading

Posted in SQL Server | Tagged | Leave a comment

which

unix has a which command to tell you the path of the executable file which is first found on the path and which will get executed when you type the command without an explicit path. The simplest use can be … Continue reading

Posted in Uncategorized | Leave a comment