Online Tutorials & Training Materials | STechies.com
Register Login

Home » SQL

SQL

Tutorials

  • SQL Environment SetupSQL Environment Setup
    MySQL or Microsoft SQL Server Installation & DownloadThis tutorial explains SQL Environment setup, in order to practice skill commands, database engine is required. Any database engine oracle, MyS ...

  • Difference between ISQL Utility and DBISQL Utility
    ISQL Utility vs DBISQL UtilityISQL Utility Isql utility is command-line Interactive SQL utility which uses the Adaptive Server Enterprise Open Client API. Isql does not provide an option to create a u ...

  • Visual Studio Community Installation and First ProjectVisual Studio Community Installation and First Project
    This tutorial explains how to download, Install and make your first project on Visual Studio Community version.First, go to your Google chrome or any search engine & just enter Visual Studio Commu ...

  • Configuring SAP Applications for Database Mirroring
    How to Configure SAP Applications for SQL Server Database MirroringConfiguring the database mirroring with SAP applications mainly comprises of three steps, listed below: The first step is related to ...

  • Asynchronous Mirroring- SQL Server Database Mirroring with SAP Applications
    Configuring Database Mirroring in Asynchronous modeAll the transaction log records are sent asynchronously to the mirrored server during the process of the configuration of database mirroring in async ...

  • Monitoring SQL Server Database Mirroring
    The process of monitoring database mirroring along with performance monitor counters delivers critical data on the assessment of evaluating possible bottlenecks present in the system. It is possible f ...

  • SQL Server Database Mirroring with SAP ApplicationsSQL Server Database Mirroring with SAP Applications
    With SAP application the process of utilizing database mirroring entails the design to be well-planned design and few changes in some SAP profiles for making the SAP applications run smoothly along wi ...

  • Principle Configuration Considerations for Database MirroringPrinciple Configuration Considerations for Database Mirroring
    When utilizing the SQL Server database mirroring as a high-availability solution, the following things should be kept in mind: Each database can only have one mirror. It is impossible to mirror a data ...

  • SQL statement does not return row
    How to use OpenXML function and return the valueField values from the XML file?Hello SAP Experts,The below SQL statement do not return any row:select valueField from openXML ( xp_read_file( 'C:SQL ...

  • Synchronous Mirroring- SQL Server Database Mirroring and SAP Applications
    For the process of synchronous mirroring, the primary server confirms the transaction to the SAP application post receiving the acknowledgement from the mirrored server. This configuration is primaril ...

  • Wait Event Analysis For SQL Server
    What are SQL wait events?Wait events are characteristic parts of the Oracle kernel source code that can contain Oracle sessions during execution. Oracle provides statistical information on the wait ev ...

  • Functionality- Wait Event Analysis For SQL Server
    FunctionalityAll functionality is accessible through report /SDF/RSMSSVSE.Collecting wait Event HistoryBy scheduling a background job, the user can collect SQL Server wait events. The default is conti ...

  • Usage- Wait Event Analysis For SQL Server
    UsageCollecting Wait Event History of the Local DatabaseThe user Runs the report /SDF/RSMSSVSE, by selecting 'Scheduling data collection'. In the upper portion of the screen, the default job c ...

  • Known Issues- Wait Event Analysis For SQL Server
    Values larger then 2*31 (2,147,483,648) - negative values In case if WAITTIME or SIGNALWAITTIME is above 2*31 then the display in /SDF/RSMSSVSE might be not - correct. This can be easily recognized by ...

  • Difference between Union and Union all
    What is UNION in SQL? Union in SQL is a set operator that is used to combine the records from two or more tables. The main functionality of the operator is to remove the duplicate records from thes ...