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




How to Start SQL Server in Single User Mode

There can be certain scenarios when one needs to connect to an SQL Server Instance in a Single User Mode by using the Startup Option -m. For example, the need could be to recover a damaged system database such as Master, Model, MSDB etc or you may want to change the server configuration options. In this article we will take a look at steps which one needs to follow to Start SQL Server in Single User Mode.

What are Virtual Log Files in SQL Server Transaction Log File?

SQL Server Database Engine defines the size of virtual log files dynamically while creating or extending transactional log files in SQL Server. Virtual log files will not have a fixed size and one cannot predict the number of VLFs within the transactional log file. Internally, SQL Server will always try to maintain a smaller number of VLFs. However, there is no way for a database administrator to configure or set a fixed size for VLFs in SQL Server.

Different Startup Options for SQL Server Database Engine Service

SQL Server Database Engine supports different startup options for SQL Server Database Engine Service. A database administrator can set the startup options very easily using SQL Server Configuration Manager. In this article we will explore startup options available in SQL Server Database Engine in detail.

How to Start SQL Server without TempDB Database or How to Start SQL Server with Minimal Configuration

This article demonstrates the steps that one needs to follow to start SQL Server without TempDB database or with minimal configuration.

Different Ways to Retrieve SQL Server Configuration Details

There are often times when as a DBA you need to quickly retrieve SQL Server Configuration Details for a SQL Server Instance. In this article we will explore different ways to retrieve SQL Server configuration details using TSQL queries.

How to Find which user deleted the database in SQL Server

In this article we will take a look at the steps which you can follow to quickly identify the user who deleted the user database in SQL Server.

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.


Share this Article





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



Trending SQL Server Tips