Tag Archives: sql

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 | 1 Comment

Generating Random Strings in SQL

The other day I was requested to add records to a lookup table only if the description being added didn’t exist. This seemed easy to do since I could run …

Tags: , , , , , , , , | Posted under Programming/Coding | Comments Off