Found 9 Articles for MS SQL Server

Introduction In the vast realm of database management, primary keys play a pivotal role in ensuring the integrity and efficiency of data storage and retrieval. Like the foundation of a grand architectural structure, primary keys serve as the backbone upon which databases are built. They provide a unique identifier for each record within a table, allowing for seamless organization and manipulation of data. In the world of MS SQL Server, understanding the implementation and utilization of primary keys is essential for any aspiring database administrator or developer. Imagine a bustling library with countless books scattered haphazardly on shelves. Without proper ... Read More

Introduction The compatibility level of a database is important because it determines which features are available and can also affect the performance of queries and other operations in the database. For example, if a database has a compatibility level of 100 (SQL Server 2008), certain features that were introduced in later versions of SQL Server, such as memory-optimized tables or table variables with large record sizes, will not be available for use in that database. It is important to set the compatibility level of a database to the correct level, as changing the compatibility level of a database can cause ... Read More

Oracle golden gate and oracle active data guard is the data replication technologies. They both are used for data replication but with different strategy. As per the oracle docs −Oracle Active Data Guard provides the best data protection and availability for Oracle Database in the simplest most economical manner by maintaining an exact physical replica of the production copy at a remote location that is open read-only while replication is active. GoldenGate is an advanced logical replication product that supports multi-master replication, hub and spoke deployment and data transformation, providing customers very flexible options to address the complete range of replication requirements. ... Read More

Logical standby and physical standby database in two different types of standby database. In case of any failure of primary database Oracle transfer data from primary database to the standby database. This approach helps us to recover data from standby database in case of any failure.Logical standby database is not the exact copy of the primary database. Logical standby uses LogMiner techniques to transform the archived redo logs into native DML statements (insert, update, delete).  This DML is transported and applied to the standby database.Primary standby database is the exact copy of primary database so it helps to minimize the ... Read More

An Index is a lookup table associated with an actual table or View that is used by the database to improve the data retrieval performance timing. In an index,  keys are stored in a structure (B-tree) that enables SQL Server to find the rows associated with the key values quickly and efficiently. Index gets created automatically if the primary key and unique key constraints are defined on the table. There are two types of index namely, Clustered Index and Non-Clustered Index. Read this article to learn more about clustered index and non-clustered index and how they are different from each ... Read More

ETL stands for Extract, Transform and Load. ETL tool is used to extract data from the source RDBMS database and transform extracted data such as applying business logic and  calculation, etc. and  then load data into the target data warehouse. In ETL tool,  transformation of the data performed at the ETL server. It is used for low amount data.ELT stands for Extract, Load and Transform. ELT tool is also used to extract data from source database and then load data into target database without transformation. In ELT, transformation of data is performed at the target database. In general, in an ... Read More

Star schema is relational schema which is follow the concept of facts and dimensions. Fact table is used to store the event like login and dimension tables are used to store the reference data of the partitural event. In star schema , tables are completely denormalized because of this query performance time is very fast.Snowflaking is a method of normalizing the dimension tables in a STAR schema. When we normalize all the dimension tables entirely, the resultant structure resembles a snowflake with the fact table in the middle. In the snowflake schema , one fact table is linked to multiple dimension ... Read More

Both Oracle and SQL Server, both are relational database management systems or RDBMS.Following are the important differences between Oracle and SQL Server.Sr. No.KeyOracleSQL Server1Developed ByOracle Server is owned by Oracle.SQL Server is developed by Microsoft.2Procedural LanguageOracle uses PL/SQL.SQL Server uses T-SQL.3UsageOracle is complex to use.SQL Server is simple to use.4OS SupportWindows, Linux, Solaris, HP-UX and OS X.Windows and Linux.5Database SharingUsers can share databases.Users cannot share databases.6PackageOracle supports Packages.SQL Server has no concept of packages.7PowerfulOracle is more powerful than SQL Server.SQL is way less powerful than Oracle.Read More

This limitation is for Visual Studio. You would require writing separate queries to get different columns and combine the output by comparing common columns.