When you're working with a large database and have to search that result set with paging, your first thought might be to select all results and then do the manipulation/count on the web server, sure that'd work, but it isn't exactly the most performant approach. Let's take a look at other ways we can produce some easily understood and most importantly, fast code. - read more.
27 Mar 2019
If like me, you've found yourself with a project that requires operations on hundreds of records simultaneously from a web project, you might have found yourself running a SQL insert/update/delete command for every one, but with the use of a C# DataTable, you'll be able to perform an action on all items with one command. - read more.
27 Feb 2018
Moving SQL Server System Tables sounds like it's going to be a complicated and fairly long-winded task, but with a few SQL queries, you're good to go. - read more.
22 Feb 2018
Encountering the SQLite PCL error 'TypeInitializationException' after updating SQLite or installing it on a new project? This will solve it. - read more.
22 Nov 2016
Understanding simple select statements and how they are used to select data/records/rows from a table with an overview of how to use indexes as a go further exercise. - read more.
11 Jul 2016
A nice and simple trick to return a paged result set using MS SQL and have the total results returned as a parameter which is useful for calculating how many pages there are. - read more.
17 Dec 2015
A quick and easy to use snippet of SQL to run on MSSQL that will delete all rows where the specified columns are not unique. - read more.
9 Dec 2015