Blog

There are 4 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 - 4 Comments

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 - 4 Comments

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 Ecake68 on MVC forms in Umbraco
16 Dec 2018, 16:11 PM
By Wowob43 on Restrict Umbraco Back Office by IP
16 Dec 2018, 10:21 AM
By Rosax69 on How does DNS work? For dummies!
15 Dec 2018, 16:44 PM
By Aroli61 on Using SQL DataTables to speed up database performance
15 Dec 2018, 09:02 AM
By Xasus39 on MVC forms in Umbraco
14 Dec 2018, 20:04 PM
By Shane on Xamarin Forms multiple instances of same app open
14 Dec 2018, 05:33 AM
By Apabu19 on Displaying text on a 16x2 LCD screen with a Raspberry Pi
13 Dec 2018, 18:26 PM
By Anuri66 on Using SQL DataTables to speed up database performance
13 Dec 2018, 13:52 PM
Categories
App Development
Event
Game Development
Mapping
Modelling
Programming
Review
Robotics
Tutorial
Web Development