Common SQL Date and Time Functions

Got these sample functions from SQLAuthority and find it very useful:

—-Today
SELECT GETDATE() ‘Today’

—-Yesterday
SELECT DATEADD(d,-1,GETDATE()) ‘Yesterday’

Query to Count Table Rows and Columns on a Database

Here is a nice query to count number of columns and rows on a table:

USE DatabaseName
GO
CREATE TABLE #temp (
                table_name sysname ,
                row_count INT,
                reserved_size VARCHAR(50),
                data_size VARCHAR(50),
                index_size VARCHAR(50),
                unused_size VARCHAR(50))
    SET NOCOUNT ON
INSERT     #temp
    EXEC       sp_msforeachtable 'sp_spaceused ''?'''
SELECT     a.table_name,
            a.row_count,
            COUNT(*) AS col_count,
            a.data_size
    FROM       #temp a
            INNER JOIN information_schema.columns b
            ON a.table_name collate database_default
    = b.table_name collate database_default
    GROUP BY   a.table_name, a.row_count, a.data_size
    ORDER BY   CAST(REPLACE(a.data_size, ' KB', '') AS integer) DESC
DROP TABLE #temp

Just change Databasename to the target database and #temp to the preferred temporary table

Thanks to SQLAuthority