Found 8 Articles for MS SQL Server

How to Setup Compatibility in Microsoft SQL Server?

Bharti Kumari
Updated on 25-Jan-2023 11:13:04
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

Difference between oracle golden gate and oracle active guard in the oracle

Himanshu shriv
Updated on 21-Jan-2020 09:53:06
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

Difference between logical and physical standby database in the oracle

Himanshu shriv
Updated on 21-Jan-2020 09:49:10
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

Difference between clustered index and non-clustered index in SQL server

Kiran Kumar Panigrahi
Updated on 20-Feb-2023 16:46:00
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

Difference between ETL and ELT in SQL Server

Himanshu shriv
Updated on 21-Jan-2020 09:29:42
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

Difference between Star schema and Snowflake schema in SQL Server

Himanshu shriv
Updated on 21-Jan-2020 09:28:49
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

Difference between Oracle and SQL Server

Mahesh Parahar
Updated on 27-Nov-2019 07:29:32
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

Limitation on number of columns in Visual Studio 2008

Updated on 30-Jul-2019 22:30:20
This limitation is for Visual Studio. You would require writing separate queries to get different columns and combine the output by comparing common columns.