Are you responsible for keeping your organization's database systems up and running? Are you the one they call in the middle of the night if the database server is down? If so, the SQL Server 2000 Operations Guide is for you.
2001-07-24
933 reads
2001-07-13
2,956 reads
2001-07-12
3,339 reads
This article addresses some common questions about the Log Shipping tool for Microsoft SQL Server 7.0.
2001-07-02
1,764 reads
An interesting feature added to SQL Server 7.0 and 2000 is the ability to purge
an error log through a stored procedure or DBCC command. In this article, Brian Knight shows some of the undocumented stored procedures to detect, read and purge an SQL Server error log in T-SQL.
2001-06-27
14,844 reads
Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.
2001-06-14
10,124 reads
In some cases, you may have to be able to quickly disable all the constraints and triggers in a database. This article shows you how to do this with a few lines of T-SQL.
2001-05-24
10,025 reads
Instead of triggers are a new feature in SQL Server 2000 which greatly extend the functionality of triggers. This article covers a basic introduction to Instead of Triggers and illustrates possibilities for their use.
2001-05-24
8,879 reads
An interesting database option which is hidden from Enterprise Manager in SQL Server 7.0 is offline.
2001-05-21
9,721 reads
Detaching and attaching a database is an advanced trick that can be useful in anything from transporting your database to recovering from a disaster.
2001-05-10
17,042 reads
By Brian Kelley
Back in June I blogged about pig butchering and the amount of reported losses...
By Kevin3NF
“SQL Server is slow.” We’ve all heard it. But that doesn’t always mean SQL...
By Steve Jones
It’s just a few weeks until the PASS Summit on Tour in New York...
Comments posted to this topic are about the item Critical Data and Insomnia
Comments posted to this topic are about the item Data recovery from an Index
Comments posted to this topic are about the item Working with Indexes on SSMS
Is it possible to recover data from a non-clustered index on the firstname and lastname columns in case of corruption?