Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
MS SQL Server Articles
Found 6 articles
Limitation on number of columns in Visual Studio 2008
Visual Studio 2008 has a limitation on the maximum number of columns that can be displayed in certain contexts, particularly in DataGridView controls and query result sets. This limitation can affect applications that need to display large datasets with many columns. Understanding the Column Limitation The column limitation in Visual Studio 2008 typically manifests when working with − DataGridView controls − Limited display capacity for numerous columns Query result visualization − Database query results with excessive columns Designer view − Form designers struggling with wide datasets ...
Read MoreHow to Setup Compatibility in Microsoft SQL Server?
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 MoreDifference between oracle golden gate and oracle active guard in the oracle
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 MoreDifference between logical and physical standby database in the oracle
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 MoreDifference between ETL and ELT in SQL Server
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 MoreDifference between Oracle and SQL Server
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