22 December 2008 by Shiva
T-SQL code snippet for selecting rows from a database table based on time values in the datetime field.
16 December 2008 by Shiva
1 line T-Sql code snippet to concatenate a table column’s values into A csv string
21 September 2008 by Shiva
Script to get the number of physical and logical CPUs (processors) on a 'SQL Server' Server Machine.
20 September 2008 by Shiva
T-SQL Script to get the row counts, column counts and data sizes for all the tables in a database.
19 September 2008 by Shiva
1 line script to truncate all tables in a database
15 September 2008 by Shiva
T-SQL (SQL Server) code snippet to get the number of days in the current month.