What is Replication ? Replication is the process of distributing data from one database to another on the same server or servers connected through LAN or the internet. Replication is used to synchronize data between databases that may be at remote lo...
System Triggers The syntax for creating a system trigger is very similar to the syntax used for creating DML trigger SQL> CREATE TABLE session_info 2 (username VARCHAR2(30), 3 logon_date DATE, 4 session_id VARCHAR2(30), 5 ip_addr VARCHAR2(30), 6 hostname...
Top 10 Features of SQL 2008 R2 1. Report Builder 3.0 2. SQL Server 2008 R2 Datacenter 3. SQL Server 2008 R2 Parallel Data Warehouse 4. StreamInsight 5. Master Data Services 6. PowerPivot for SharePoint 7. Data-Tier Application 8. Unicode Compression 9....
Features of SQL Server 2012 1. AlwaysOn Availability Groups -- This feature takes database mirroring to a whole new level. With AlwaysOn, users will be able to fail over multiple databases in groups instead of individually. Also, secondary copies will...
Linked server:SQL Server 2005 new feature. A linked server is simply a connection to an Object Linking and Embedding Database (OLEDB) data source. THE MAIN PURPOSE is to access remote databases from source server instance without login. Permissions to...
Violation of PRIMARY KEY constraint 'PK_Whatever': Why you get this error: Trying to insert duplicate records in publisher or subscriber How to find: Once we get this error message , replication is going to fail. Go to replication monitor> Properties...
SQL Agent SQL agent, also known as SQL server agent, is a Microsoft SQL server relational database management system(RDBMS) background tool. SQL agent allows the database administrator (DBA) to schedule automated execution jobs, as well other management...
SQL DMVs Top 15 SQL Dynamic management Views 1.sys.dm_db_index_physical_stats: This dynamic management function returns information regarding data and index information for data tables and views 2.sys.dm_exec_requests: This view shows information regarding...
What is database mirroring? In which SQL Server version it was introduced? Why mirroring why not Log shipping? What are the difference between Log Shipping and mirroring? Can you explain the specific usability of mirroring, Log Shipping and Replication?...
What are the DMV's in SQL Server ? Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. Important Dynamic management views and functions...
