|
|
|
|
|
How to Backup SQL Server to a Network Shared Folder |
|
|
By revindex on
7/17/2007 12:14 PM
|
|
|
|
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.
|
 |
|
Comments (0)
|
More...
|
|
|
New Snapshot Isolation Level in SQL Server 2005 |
|
|
By revindex on
7/14/2007 9:05 AM
|
|
|
|
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...
|
|
|
|
Comments (0)
|
More...
|
|
|
How to Find and Delete Duplicate Entries in a Table |
|
|
By revindex on
7/5/2007 6:24 AM
|
|
|
|
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...
|
|
|
|
Comments (2)
|
More...
|
|