MyTechMantra.com
Connect With MyTechMantra.com

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter






























Microsoft SQL Server Articles, Tutorials, News, Tips & Tricks


Reasons Behind Large Transaction Log File Size when database is configured for Snapshot Replication

In this tip we will take a look at how to identify and fix sudden surge of transaction log file especially when a database is configured for Snapshot Replication.

SQL Server Replication Articles and Tips

List of SQL Server Replication Articles and Tips which can help DBAs and Developers.

Different Ways to Find Default Trace Location in SQL Server

In this tip we will take a look at different ways to find the location of default trace file in SQL Server and how to enable or disable default trace file in SQL Server.

Different Ways to Enable an Index in SQL Server

This article demonstrates how to enable an index in SQL Server. It is a very useful feature which will help you enable an index which was disabled earlier to check whether the index was really useful or not without actually dropping the index.

Different Ways to Disable an Index in SQL Server

Disabling an Index in SQL Server is a very useful feature which will help you identify whether the index is really useful or not without actually dropping the index.

Download SQL Server 2014 Developer Edition For Free

Microsoft has announced that the SQL Server 2014 Developer Edition will available for free to Visual Studio Dev Essentials members. This article explains how to register and then download SQL Server 2014 Developer Edition for FREE.

SQL Server Best Practice Auto Close Database Option Should Remain OFF

This article explains why it is important to leave AUTO CLOSE database option turned OFF for a Production or a Non Production SQL Server Database across all versions and editions of SQL Server.

SQL Server 2014 Backup and Restore Enhancements

This article outlines some of the major database backup and restore enhancements which is available in SQL Server 2014.

Using System Configuration Checker to Identify Potential Issues before Installing SQL Server

This tip demonstrates how to use System Configuration Checker Tool (SCC) to identify potential issues which one can encounter before even installing SQL Server on any new or existing server.

Different Ways to Enable an Index in SQL Server

This article demonstrates how to enable an index in SQL Server. It is a very useful feature which will help you enable an index which was disabled earlier to check whether the index was really useful or not without actually dropping the index.

Discover SQL Server Components Installed Using SQL Server Discovery Report

In this article we will take a look at how to install and use SQL Server Discovery Tool to discover all the SQL Server Components which are already installed on a local server.

How to Fix 'Cannot execute script. Insufficient memory to continue the execution of the program (mscorlib)' error in SQL Server

Learn How to Fix 'Cannot execute script. Insufficient memory to continue the execution of the program (mscorlib)' error in SQL Server

How to Enable and Refresh IntelliSense in SQL Server Management Studio (SSMS)

In this tip we will take a look at the steps you can follow to quickly enable and refresh IntelliSence in SSMS to resolve this issue of IntelliSense not displaying latest schema changes.

How to Change Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio

Starting SQL Server 2008, SSMS allows you to Select Top 1000 rows and Edit Top 200 rows. However in previous version of SSMS 2005 the only option was to open the entire table. Let us see how to alter select top 1000 rows and edit top 200 rows default value in SSMS.


SQL Server Management Studio Articles and Tips

List of SQL Server Management Studio Articles and Tips which can help DBAs and Developers to better use SSMS.

How to Detect Database Corruption Issues in SQL Server Using Suspect_Pages Table of MSDB Database?

This article explains how a DBA can use SUSPECT_PAGES table available in MSDB system database to keep track of corrupt pages in any of the SQL Server Database residing on an instance of SQL Server.

SQL Server Indexing Tips and Articles for DBAs and Developers

Helpful SQL Server Indexing Tips, Articles, Tutorials, How-to's, Scripts, White Papers and much more for SQL Server DBAs and Developers to Improve the Performance of SQL Server Database across your organization.

How to Fix SQL Server Database Corruption Articles and Tips

List of SQL Server Database Corruption Related Articles and Tips

SQL Server Analysis Services Administration Articles and Tips

List of SQL Server Analysis Services Administration Related Articles and Tips

Why SQL Server Log backups fails and Full backup succeeds? Learn how to Fix BACKUP detected corruption in the database log error in SQL Server

Due to an unplanned reboot of SQL Server one of the transactional log file of a database become corrupt. DBA noticed this issue once regular transactional log backup job started failing with BACKUP detected corruption in the database log error message. This article outlines the steps to be followed to fix BACKUP detected corruption in the database log error in SQL Server.

SQL Server Database Backup Options and Commands a Step by Step Tutorial with Examples

This tutorial will give you compressive information on different database backup options which is available to a DBA or a Developer within SQL Server. The detailed topics mentioned in this tutorial will help you understand database backups in depth whether you are new to SQL Server or an Expert.

Different SQL Server Recovery Models Step by Step Tutorial with Examples

Recovery Models in SQL Server are basically designed to control the transaction log maintenance and to help you recover your data from a disaster. Based on the choice of Recovery Model, SQL Server decides which data it needs to retain within SQL Server transactional logs and for the time period.

SQL Server SIMPLE Recovery Model Step by Step Tutorial with Examples

SIMPLE recovery model as the name suggests it is the most basic recovery model which is available in SQL Server. In this recovery model every transaction is written to the transactional log file and once the transaction is completed successfully the data gets written to data file; SQL Server will automatically clear the space used by the transaction within transaction log file for newer transactions.

SQL Server FULL Recovery Model Step by Step Tutorial with Examples

In Full Recovery Model Point in Time recovery of the database is possible as long as you have all the valid database backups along with the transactional log tail backup file. In Full Recovery model all the transactions are retained within the transaction log file until the log file is backed up or the transactional log file is truncated.

Share this Article





Receive Free SQL Server Tips and Keep Learning
Get Free SQL Server Tips





Latest SQL Server Tips