Blog

There are 6 items on 1 pages.

Using SQL DataTables to speed up database performance

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

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

Solved: SQLite TypeInitializationException

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

Selecting records from an MS SQL database and improving query performance

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

SQL - Select records/rows with paging and result count

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

SQL Server - Delete all non distinct rows

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
Share with
Tags
Latest Comments
By jack of ass on Replacing the Xamarin Header/Navigation bar with a custom view/template
16 Feb 2019, 03:13 AM
By Zal on Xamarin MasterDetailPage has large margin/padding at top
7 Feb 2019, 12:20 PM
By AndrewEcopE1 on MVC forms in Umbraco
7 Feb 2019, 01:16 AM
By AndrewEcopE1 on MVC forms in Umbraco
4 Feb 2019, 23:53 PM
By Ramachandran on Reducing Umbraco memory usage by enabling 32-bit applications
4 Feb 2019, 17:39 PM
By encoderu9 on MVC forms in Umbraco
4 Feb 2019, 10:51 AM
By AndrewEcopE1 on MVC forms in Umbraco
28 Jan 2019, 19:48 PM
By Luca Ziegler on Xamarin Forms app not updating after deploy
25 Jan 2019, 11:00 AM
Categories
App Development
Event
Game Development
Mapping
Modelling
Programming
Review
Robotics
Tutorial
Web Development