Blog

There are 5 items on 1 pages.

SQL Select Row Count With Results

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

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

MSSQL convert star or asterisk to column names

Did you know that you could easily insert all the column names into a stored procedure from within Microsoft SQL Management Studio? No more need for that annoying (and slow) asterisk or star operator. - read more.

6 Jul 2015

Scripting MSSQL database schema and data

Covering how to script an entire database with table schema and data into a '.sql' file using Microsoft SQL Server and Management Console, I aim to shoot down any problems people may be facing whilst trying to migrate data to an older version of MSSQL Server. - read more.

5 Aug 2014
Share with
Tags
Latest Comments
By Mark Gentry on Windows Server 2019 - Change product key does nothing
20 Aug 2021, 03:30 AM
By Cathy on In-Place Upgrade for a Windows Server domain controller
31 Jul 2021, 18:28 PM
By Mr. Greymatter on Raspberry Pi - Running Java app on Raspbian
16 Feb 2021, 07:35 AM
By Mikko Seittenranta on Xamarin Forms multiple instances of same app open
16 Feb 2021, 04:34 AM
By Andrew on Auto/Custom height on Xamarin Forms WebView for Android and iOS
22 Jan 2021, 22:15 PM
By Nick on Raspberry Pi - Running Java app on Raspbian
14 Oct 2020, 19:37 PM
By Ivan on Fixed: Value cannot be null Parameter Name: source
15 Sep 2020, 19:47 PM
By Anand on Raspberry Pi - Bluetooth using Bluecove on Raspbian
7 Sep 2020, 16:53 PM
Categories
App Development
Event
Game Development
Mapping
Modelling
Programming
Review
Robotics
Tutorial
Web Development