https://www.revindex.com/Resources/Blogs/blog/6/locale/en-US/SQL SQL database query language slim@revindex.com Mon, 18 May 2026 09:02:37 GMT Mon, 18 May 2026 09:02:37 GMT DotNetNuke Blog RSS Generator Version 6.4.2.0 30 https://www.revindex.com/Resources/Blogs/Post/580/Easy-Upgrade-SQL-Server-2000-2005-to-SQL-Server-2008 Easy way to upgrade SQL Server 2005 to SQL Server 2008. slim@revindex.com (Revindex Solution) Revindex Solution https://www.revindex.com/Resources/Blogs/Post/580/Easy-Upgrade-SQL-Server-2000-2005-to-SQL-Server-2008 Fri, 31 Oct 2008 12:26:00 GMT 2008-10-31 12:26:00Z https://www.revindex.com/Resources/Blogs/Post/578/DateTime-MinValue-underflow-in-SQL-Server You get an overflow exception when you save DateTime.MinValue into a SQL Server "datetime" column. (.NET, C#, VB.NET, SQL Server, PostgreSQL) slim@revindex.com (Revindex Solution) Revindex Solution https://www.revindex.com/Resources/Blogs/Post/578/DateTime-MinValue-underflow-in-SQL-Server Wed, 22 Oct 2008 09:29:00 GMT 2008-10-22 09:29:00Z https://www.revindex.com/Resources/Blogs/Post/575/Get-Approximate-Row-Count-Fast-on-SQL-Server Here's how to find the approximate row count for any indexed table quickly in SQL Server. slim@revindex.com (Revindex Solution) Revindex Solution https://www.revindex.com/Resources/Blogs/Post/575/Get-Approximate-Row-Count-Fast-on-SQL-Server Fri, 26 Sep 2008 08:51:00 GMT 2008-09-26 08:51:00Z https://www.revindex.com/Resources/Blogs/Post/574/Cycling-SQL-Server-Logs You can force SQL Server to flush the log to file and cycle the log numbers (SQL Server 2005, 2008) slim@revindex.com (Revindex Solution) Revindex Solution https://www.revindex.com/Resources/Blogs/Post/574/Cycling-SQL-Server-Logs Tue, 23 Sep 2008 18:55:00 GMT 2008-09-23 18:55:00Z https://www.revindex.com/Resources/Blogs/Post/636/How-to-Backup-SQL-Server-to-a-Network-Shared-Folder If you try to backup your SQL Server database to a Windows shared folder on a network PC, you're in for a little bit of a surprise. The following command is a valid statement but SQL Server will throw you an ugly exception. There are a couple of solutions you can workaround the problem. slim@revindex.com (Revindex Solution) Revindex Solution https://www.revindex.com/Resources/Blogs/Post/636/How-to-Backup-SQL-Server-to-a-Network-Shared-Folder Tue, 17 Jul 2007 16:14:00 GMT 2007-07-17 16:14:00Z https://www.revindex.com/Resources/Blogs/Post/567/New-Snapshot-Isolation-Level-in-SQL-Server-2005 Starting with SQL Server 2005, you can now use Snapshot Isolation to eliminate blocking READ operations and get rid of those pesky SQL locks. Snapshot Isolation is a better choice for OLTP operations where you expect a large number of reads and moderate writes. Your system will be able to scale much higher. Here's how to set your SQL Server database to use the new isolation level... slim@revindex.com (Revindex Solution) Revindex Solution https://www.revindex.com/Resources/Blogs/Post/567/New-Snapshot-Isolation-Level-in-SQL-Server-2005 Sat, 14 Jul 2007 13:05:00 GMT 2007-07-14 13:05:00Z https://www.revindex.com/Resources/Blogs/Post/561/How-to-Find-and-Delete-Duplicate-Entries-in-a-Table Someone asked me today how to find a duplicate entry in a table using SQL. One of his tables became corrupted after SQL Server accidentally dropped his Unique Index on a field. As a result, the same data got inserted multiple times and he needed a way to find out which and how to delete them... slim@revindex.com (Revindex Solution) Revindex Solution https://www.revindex.com/Resources/Blogs/Post/561/How-to-Find-and-Delete-Duplicate-Entries-in-a-Table Thu, 05 Jul 2007 10:24:00 GMT 2007-07-05 10:24:00Z