SqlServer-QA.net

Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes occur in a database the changes are formed as transactions that are held in buffer pool ...

When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as:  [Id]  INT (make this primary key clustered), [Unit_Id]  UNIQUEIDENTIFIER, [EventType_Id]   ...

Do you have a large ETL process to finish on day-to-day basis? Is your ETL process is suffering with performance loss during the BULK insert or export task? Are you using SQL Server 2005? If it is YES for all the above then you can take advantage of SQL 2005 in speeding up the ETL process to perform better. Also it is one of the best ...

There should be no special consideration to perform BACKUP activities within your SQL Server environment. But if you are using FTS with full-text indexes/catalogs then you should be concerned about point-in time recoverability with the backups. You may be aware that from SQL Server 2005 onwardsyou can use the BACKUP ...

Normally the backup and restore operation will be quick enough or depends upon the server configuration to complete. Say if you have started with a 2GB size of database and over the time as that database is updated, the amount of data that is included in differential backups increases. This makes the backup slower to create and to restore. ...

Snapshot backups are introduced in SQL Server 2005 version that uses:  The underlying backup technology creates an instantaneous copy of the data that is being backed up. The instantaneous copying is typically accomplished by splitting a mirrored set of disks or by creating a copy of a disk block when it is written. This ...

You might be aware that now a days many high-end and high-spec disk subsystems provide high-speed cache facilities to reduce the latency of read and write operations. In general this cache is supported by a battery-power backup facility, which is necessary to maintain the data in cache in case of any power surge in hardware. But the implementation ...