Skip to content
Saturday, May 28, 2022
Database Learners
Menu
  • About Database
  • Oracle
    • ASM
    • Data Pump
    • Backup and Recovery
    • Patching and Upgradation
    • Performance Tuning
    • Data Guard
    • Real Application Cluster
    • Golden Gate
    • PL/SQL
  • MySQL
  • PostgreSQL
  • MongoDB
  • MS SQL Server
  • SQL
  • Linux
  • About Me
  • Contact Us
  • Home
  • MS SQL Server

Category: MS SQL Server

How do you clear the SQL Server transaction log

20 August 202020 August 2020 Administrator

Note : You may want to backup first. USE AdventureWorks2008R2;GO– Truncate the log by changing the database recovery model to SIMPLE.ALTER DATABARead More…

What are Versions and Editions in SQL Server?

18 August 202018 August 2020 Administrator

What are Versions and Editions? When you read or listen something like SQL Server 2005, 2008, 2008 R2 and 2012, they are Versions of SQL Server.. Read More…

SQL Server Tips and Tricks

18 August 202018 August 2020 Administrator

Checking SQL Service Running Status !! SELECT dss.[status_desc],servicename,startup_type_desc,service_accountFROM sys.dm_server_services dssWHERE Read More…

SQL Server administration best practices

18 August 202018 August 2020 Administrator

This article explains best practices for system administration in a Microsoft SQL Server 7.0 / 2000 environment, including regular maintenance tasks.Read More…

What is Difference Between SQL and T-SQL

18 August 202018 August 2020 Administrator

1) SQL is a Structured Query Language.It is developed by IBM. TSQL is the Transact SQL.It is implementation of SQL Server. Developed by Microsoft.Read More…

What are SQL Server DBA Responsibilities?

18 August 202018 August 2020 Administrator

This is one of the most frequently asked questions by people who are new to SQL Server. Since they are new to SQL Server, their concern is understandRead More…

SQL Server Performance Tuning

18 August 202018 August 2020 Administrator

When dealing with performance tuning SQL Server, we can broadly classify it into 2 major areas; Physical Server related and SQL Server related. I wilRead More…

SQL Server: Database Basics

18 August 202018 August 2020 Administrator

System Databases Master: composed of system tables that keep track of server installation as a whole and all other databases that are eventually cRead More…

Recent Posts

  • How to Optimize MySQL Tables and Defragment to Recover Space
  • ORA-01031: Insufficient Privileges When Connect As Sysdba
  • Oracle RAC log files locations
  • Drop all tables in Oracle DB (Schema)
  • How to Determine If the Oracle Redo Log File Size Is a Problem

Categories

  • ASM (40)
  • Backup and Recovery (52)
  • Data Guard (36)
  • Data Pump (28)
  • DB Scripts (26)
  • General (1)
  • Golden Gate (7)
  • Interview Questions (24)
  • Linux (86)
  • MS SQL Server (8)
  • MySQL (120)
  • ORA-Errors (45)
  • Oracle (301)
  • Oracle 10g (19)
  • Oracle 11g (24)
  • Oracle 12c (9)
  • Oracle RAC (101)
  • Oracle XE (7)
  • Patching and Upgradation (19)
  • Performance Tuning (61)
  • PL/SQL (26)
  • RMAN (85)
  • SQL (32)

Visitors

  • 0
  • 54
  • 29,904

Reference Links:

  • https://docs.oracle.com/en/database/index.html
  • https://dev.mysql.com/doc/
  • https://docs.mongodb.com/manual/
  • https://docs.microsoft.com/en-us/sql/sql-server/?view=sqlallproducts-allversions
  • https://www.postgresql.org/docs/current/
@2021 databaselearners.com | Theme: BlogMagazine by Dinesh Ghimire.