Search

Keyword: SQL

SQL Tips #7 - Which tables or stored procedures were updated recently

SQL Tips #7 - Which tables or stored procedures were updated recently

Wednesday, 16 November 2016

Useful SQL tips - how to list all stored procedures or tables updated recently

Read More


 

SQL Tips #6 - Looking for tables with specific fieldtypes

SQL Tips #6 - Looking for tables with specific fieldtypes

Friday, 16 September 2016

Useful SQL tips - how to a specific type of field in a SQL table

Read More


 

SQL Tips #5 - Listing the recovery model for each database

SQL Tips #5 - Listing the recovery model for each database

Saturday, 16 July 2016

Useful SQL tips - how to list the SQL Recovery Model of all your databases

Read More


 

SQL Tips #4 - Listing all SQL databases with their file locations and sizes

SQL Tips #4 - Listing all SQL databases with their file locations and sizes

Monday, 16 May 2016

Useful SQL tips - How to list all your SQL databases with their file locations and sizes

Read More


 

SQL Tips #3 - Searching for a keyword in a stored procedure

SQL Tips #3 - Searching for a keyword in a stored procedure

Wednesday, 16 March 2016

Useful SQL tips - how to list all stored procedures that have column names that match a keyword

Read More


 

SQL Tips #2 - Searching for a specific field name in a SQL table

SQL Tips #2 - Searching for a specific field name in a SQL table

Saturday, 16 January 2016

Useful SQL tips - how to list all tables that have column names that match a keyword

Read More


 

SQL Tips #1 - Table Row Counts & Sizes

SQL Tips #1 - Table Row Counts & Sizes

Saturday, 12 December 2015

Useful SQL tips - how to list all tables and retrieve their row counts and file sizes

Read More