Tag Archives: sql

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

Finding Date Closest to Middle or Last Day of Month in SQL

If you have ever worked in SQL or other databases you know that dates can be very tricky. It is not always simple to capture differences and length of time …

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