Search

Keyword: SQL

SQL Tips #41 - Listing the Restore Progress of Databases

Wednesday, 23 October 2019

Useful SQL tips - how to list the restore progress of databases

SQL Tips #40 - Finding Queries with Missing Indexes in the Query Store

Saturday, 21 September 2019

Useful SQL tips - how to find queries with missing indexes in the Query Store

SQL Tips #39 - Listing All Keys in a Database

Tuesday, 20 August 2019

Useful SQL tips - how to list all keys in a database

SQL Tips #38 - Finding All Dependencies of a Stored Procedure

Friday, 19 July 2019

Useful SQL tips - how to find all dependencies of a specific stored procedure

SQL Tips #37 - Listing All Stored Procedures Using a Specific Table

Monday, 17 June 2019

Useful SQL tips - how to list all stored procedures using a specific table

SQL Tips #36 - Listing All Stored Procedures or Tables

Thursday, 16 May 2019

Useful SQL tips - how to list all stored procedures or tables in a database

SQL Tips #35 - Finding Tables with Missing Identity Fields

Sunday, 14 April 2019

Useful SQL tips - how to find tables with missing identity fields

SQL Tips #34 - Finding Tables with Missing Primary Keys

Wednesday, 13 March 2019

Useful SQL tips - how to find tables with missing primary keys

SQL Tips #33 - Generating a Comma Separated List of Fields per Table

Saturday, 9 February 2019

Useful SQL tips - how to generate a comma separated list of fields per table

SQL Tips #32 - Listing Recent Deadlock Victims

Tuesday, 8 January 2019

Useful SQL tips - how to list any queries that were recent deadlock or blocking victims

SQL Tips #31 - Deleting Duplicate Entries While Keeping the Original

Friday, 7 December 2018

Useful SQL tips - how to delete duplicate entries in a table while keeping the original

SQL Tips #30 - Listing Databases and Their CPU Usage

Monday, 5 November 2018

Useful SQL tips - how to list databases and their CPU usage

SQL Tips #29 - A Function to Generate Random Numbers

Thursday, 4 October 2018

Useful SQL tips - a user-defined function to generate random numbers in a range

SQL Tips #28 - Generating Random Numbers for Non-Crypto Usage

Sunday, 2 September 2018

Useful SQL tips - how to generate good random numbers for non-crypto usage

SQL Tips #27 - Finding Which Indexes Are Not Used

Wednesday, 1 August 2018

Useful SQL tips - how to find which indexes are not being used

SQL Tips #26 - Getting the Field Types of Fields in a Table

Saturday, 30 June 2018

Useful SQL tips - how to get the field types of fields in a table

SQL Tips #25 - Rebuilding All Fragmented Table Indexes

Tuesday, 29 May 2018

Useful SQL tips - how to rebuild all fragmented table indexes

SQL Tips #24 - Listing All Indexes and Their Fragmentation Percentage

Friday, 27 April 2018

Useful SQL tips - how to list all indexes and their fragmentation percentage

SQL Tips #23 - A Function to Strip Numeric Characters

Monday, 26 March 2018

Useful SQL tips - a user-defined function to strip numeric characters from a string

SQL Tips #22 - A Function to Split a String

Thursday, 22 February 2018

Useful SQL tips - a user-defined function to split a delimited string

SQL Tips #21 - Listing All Table Columns and Their Default Values

Sunday, 21 January 2018

Useful SQL tips - how to list all table columns and their default values

SQL Tips #20 - Showing All Table Data for a Specified User

Wednesday, 20 December 2017

Useful SQL tips - how to show all table data for a specified user

SQL Tips #19 - Listing All SQL Jobs on the Server

Saturday, 18 November 2017

Useful SQL tips - how to list all SQL Agent jobs on the server

SQL Tips #18 - Listing All Tables Without Any Indexes

Tuesday, 17 October 2017

Useful SQL tips - how to list all tables without any indexes

SQL Tips #17 - Table Row Counts and Sizes in Gb

Friday, 15 September 2017

Useful SQL tips - how to list all tables with row counts and file sizes in gigabytes

SQL Tips #16 - Looping Through Records using Cursors

Monday, 14 August 2017

Useful SQL tips - how to loop through records using SQL cursors

SQL Tips #15 - How to use Coalesce

Thursday, 13 July 2017

Useful SQL tips - how to use COALESCE to concatenate row values into a single string

SQL Tips #14 - Clearing the Query Store

Sunday, 11 June 2017

Useful SQL tips - how to clear the Query Store of a SQL database

SQL Tips #13 - Finding the Domain from an Email Address

Wednesday, 10 May 2017

Useful SQL tips - how to extract the distinct domain names from a column of email addresses

SQL Tips #12 - Making a Default Date Rounded to an Hour

Saturday, 8 April 2017

Useful SQL tips - how to create a default date value rounded to the nearest hour

SQL Tips #11 - Rebuilding the Query Cache and Statistics

Tuesday, 7 March 2017

Useful SQL tips - how to update statistics for every table and rebuild the query cache

SQL Tips #10 - Rebuilding Table Indexes Across Databases

Friday, 3 February 2017

Useful SQL tips - how to rebuild the indexes of every table across one or more databases

SQL Tips #9 - Listing Stored Procedures by Change Date

Monday, 2 January 2017

Useful SQL tips - how to list all stored procedures ordered by the date they were last changed

SQL Tips #8 - List Read and Write Counts per Table

Thursday, 1 December 2016

Useful SQL tips - how to list read and write counts for every table in a database

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

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

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

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

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

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

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

Developer Courses

Skype Web SDK: Getting Started

Skype Web SDK: Audio & Video

Follow @MattProctorAU

Favourite Links