Useful tips for everyday
Why do database locks occur? A database lock is used to “lock” some data in a database so that only one database user/session may update…
What are the steps of transaction log shipping? SQL Server Transaction Log shipping’s prime steps are Transaction Log backup, copy and restore. The answer to…
How can I find the last restart of SQL Server? Here are a few different ways that you can tell when SQL Server was last…
How can you get a random employee record from the table? There are a lot of ways to select a random record or row from…
How do I check my Replication agent status? Connect to the Publisher in Management Studio, and then expand the server node. Expand the Replication folder,…
What is the period of a fiscal year? A Fiscal Year (FY), also known as a budget year, is a period of time used by…
Which function displays the maximum value? The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty…
How do I configure Informix? The sections that follow explain these steps. Step 1: install the JDBC driver. Step 2: create the Informix database and…
Is clustered index required? You are never REQUIRED to have a clustered index. Either way is fine in the sense that given a particular table…
How do I export a SQL Server database backup? Expand Databases, right-click SQLTestDB , point to Tasks, and then select Back Up…. Select OK. When…