Tag Archives: sql

Calculating Percent of Total in a SQL Select Statement

I am always amazed at how SQL server provides a lot of calculations and logic built right into a select statement. Most of the time (if you are like me) …

Tags: , , , , , , , , | Posted under Programming/Coding | Leave a comment

OpenCart – Massive SQL Insert

There will be times that you will be using the Opencart framework for your own web applications where the goal will not be eCommerce or having an online store. In …

Tags: , , , , , | Posted under OpenCart | Leave a comment

Optimize SQL Databases with Microsoft SQL Server Management Studio

A previous article talked about how to shrink a database manually to optimize it. This is a good way to do it, but it requires to run a query, which …

Tags: , , , , , , , , , , , , , , , , , , , , | Posted under ASP .NET 3.5, DotNet/Windows Hosting, WebsitePanel Tutorials, Windows Server Admin | Leave a comment