Category Archives: Sql Server

SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing

How to Export Records From SQL Server to Text File using BCP

How to Export Records From SQL Server to Text File using BCP In this tutorial we will learn How to Export Records From SQL Server to Text File using BCP. Bulk Copy Program (BCP) is a command-line utility that ships with Microsoft SQL Server. With BCP, you can import and export large amounts of data in and

The remote procedure call failed (0x800706be)

The remote procedure call failed (0x800706be) In this post we will learn how to solve The remote procedure call failed (0x800706be). Today when i am try to open SQL Server Configuration manager it gives me error: The remote procedure call failed (0x800706be). Solutions: 1. Apply latest service pack. Link for SQL Server 2008 R2 Service pack1: http://www.microsoft.com/en-in/download/details.aspx?id=26727 , Link

How to kill All Running Processes in SQL Server

How to kill All Running Processes in SQL Server In this post we will discuss How to kill All Running Processes in SQL Server. we do have solution by killing the running process to take a lock and perform any activity using a management command namely KILL & a system view sys.sysprocesses. However, what encourages me to write this solution

Performance Monitor

Performance Monitor In this tutorial we will discuss about Performance Monitor. You can use Windows Performance Monitor to examine how programs you run affect your computer’s performance, both in real time and by collecting log data for later analysis. Windows Performance Monitor uses performance counters, event trace data, and configuration information, which can be combined into Data

Some Important Trace Flags for SQL Server DBA

Some Important Trace Flags for SQL Server DBA In this post we will discuss Some Important Trace Flags for SQL Server DBA. A trace flag is used to set specific server characteristics or to switch off a particular behavior of the SQL Server. You can enable the trace flag from Startup Parameters, Session and Global Session level. Trace