Top posts
-
HOW To modify a synchronization schedule for a push subscription in Management Studio
HOW To modify a synchronization schedule for a push subscription in Management Studio Connect to the Distributor in Management Studio, and then expand the server node. Expand the SQL Server Agent folder, and then expand the Jobs folder. Right-click the...
-
Can you tell me some of the common replication DMV's and their use?
Can you tell me some of the common replication DMV's and their use? sys.dm_repl_articles - Contains information about each article being published. It returns data from the database being published and returns a row for each object being published in...
-
Is it possible to replicate data from SQL Server to Oracle
Is it possible to replicate data from SQL Server to Oracle? Yes this can be done using heterogeneous replication. In SQL Server 2000, publishing data to other databases such as DB2 or Oracle was supported; however, publishing data from other databases...
-
What are publisher, distributor and subscriber in “Replication”?
What are publisher, distributor and subscriber in “Replication”? Publisher-A publisher is any database unit that makes data available to other sources via replication. The publisher can have multiple publications which defines the data to replicate. Subscriber-A...
-
SQL NOT NULL Constraint
The NOT NULL constraint enforces a column to NOT accept NULL values. The NOT NULL constraint enforces a field to always contain a value. This means that you cannot insert a new record, or update a record without adding a value to this field. The following...
-
Violation of PRIMARY KEY
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...
-
What is Restore? What are the recovery states? Explain Each?
What is Restore? What are the recovery states? Explain Each? Restore means recover the data from backups. There are three recovery states for Restore. (1) With Recovery (2) With No-Recovery (3) Standby. a) With Recovery:- With Recovery option the Database...
-
SQL RIGHT JOIN
SQL RIGHT JOIN The RIGHT JOIN keyword returns all rows from the right table (table2), with the matching rows in the left table (table1). The result is NULL in the left side when there is no match. SQL RIGHT JOIN Syntax SELECT column_name(s) FROM table1...
-
DBA Daily Responsibilities
DBA Daily Responsibilities On daily basis DBA should monitor the below Backups Confirm that backups have been made and successfully saved to a secure location Check the backup failure alerts, correct the errors and rerun the backups Review the average...
-
Let’s say we have a situation. We are restoring a database from a full backup. The restore operation ran for 2 hours and failed with an error 9002 (Insufficientlogspace). And the database went to suspect mode. How do you troubleshoot this issue?
Let’s say we have a situation. We are restoring a database from a full backup. The restore operation ran for 2 hours and failed with an error 9002 (Insufficientlogspace). And the database went to suspect mode. How do you troubleshoot this issue? Ans:...
-
SQL Server is not responding. What is action plan?
SQL Server is not responding. What is action plan? Connect using DAC via CMD or SSMS Connect via CMD SQLCMD -A –U myadminlogin –P mypassword -SMyServer –dmaster Once you connect to the master database run the diagnostic quires to find the problem Correct...
-
How many datafiles I can put in Tempdb? What is the effect of adding multiple data files.
Q. How many datafiles I can put in Tempdb? What is the effect of adding multiple data files. By far, the most effective configuration is to set tempdb on its own separate fast drive away from the user databases. I would set the number of files based on...
-
What is the port numbers used for SQL Server services?
What is the port numbers used for SQL Server services? The default SQL Server port is 1433 but only if it’s a default install. Named instances get a random port number. The browser service runs on port UDP 1434. Reporting services is a web service – so...
-
Can we uninstall/rollback a service packs from SQL Server 2005?
Can we uninstall/rollback a service packs from SQL Server 2005? No not possible for SQL Server 2005. To rollback a SP you have to uninstall entire product and reinstall it. For Sql Server 2008 you can uninstall a SP from Add/Remove programs. Some people...
-
tempdb Full issue in sql server dba
How to fix tempdb Full issue ? 1) Since tempdb recovery model is simple , Tempdb log will not grow drastically unless open transactions are there if so we will kill that spid and then shrink it 2) If mdf file is full we can shrink that but sometimes we...
-
Replace function Oracle
Replace function Oracle Posted on September 24, 2012 by sqlandplsql Replace function replaces the string with another string if it matches. It is a character function in Oracle. Replace function is case-sensitive. Syntax:- REPLACE(‘input string’,’find_string’,’replace_string’);...
-
Translate function Oracle
Translate function Oracle Posted on September 30, 2012 by sqlandplsql TRANSLATE function replaces a string with another set of characters.TRANSLATE replace characters in sequential order. Syntax TRANSLATE(string, from_string, to_string) Example 1:- SQL>...
-
%TYPE and %ROWTYPE in oracle
%TYPE and %ROWTYPE %TYPE is used to declare a variable that is of the same type as a specified table’s column. Emp_number emp.empno%type; %ROWTYPE is used to declare a record(variable that represents the entire row of a table). Emp_record emp%rowtype...
-
Birlasoft PLSQL Interview Questions
What is module overloading? What are composite data types? What is the use of record. Why we use record. what is diifrence between where clause and having clause? What is collection? Difference b/w nested tables and varrays? what is a bad file? What are...
-
SQL DBA _Find Failed Jobs in 24 Hours
Sript performs the same function as the one above but it displays failure date, job name, step id, step name and error message. SELECT DISTINCT CAST(CONVERT(datetime,CAST(run_date AS char(8)),101) AS char(11)) AS 'Failure Date', SUBSTRING(T2.name,1,40)...
-
HCL PUNE PL/SQL Interview Questions
Tell me about your self? 11g features? What are the issues you faced in using Cursors? What is varry and nested tables? How the query executed?? Write a query to display even/odd number from a table.? What is the exception?explain raise_application error?...
-
What are attributes of implict cursor?
What are attributes of cursor? · SQL%ROWCOUNT: Number of rows affected by most recent SQL statement. · SQL%FOUND: Boolean attribute that evaluates to TRUE if most recent SQL statement affects one or more rows. · SQL%NOTFOUND: Boolean attribute that evaluates...
-
SQL DBA WORK FLOW
PROCESS: 1 ITIL (Information Technology Infrastructure Library) Process 2 DBAMaintains Activities(Daily\weekly\Monthly) 3 DR (Disaster Recovery) Plan 4 BCP (Business continuity Plan) Plan 5 RACI (Responsible Accountable Consult Inform)Matrix 6 RCA ( Root...
-
VWhat is End Point? How u create end point?
What is End Point? How u create end point? An endpoint is a network protocol which is used to communicate Principal, Mirror and Witness servers over the network. Creation of an end point:- Create endpoint
State=started/stopped/disabled... -
Frequnetly asked Cluster Interview Questions?
What is meant by Active – Passive and Active – Active clustering setup? List out some of the requirements to setup a SQL Server failover cluster? How do you open a Cluster Administrator? What are the differences in Clustering in SQL Server 2005 and 2008...