What is the difference between the full, simple and bulk log recovery models?

mbhsye786

 Profile Answers by mbhsye786 Questions by mbhsye786

• Jan 13th, 2014

Full recovery model: This model requires log backups, no data is lots due to lost of data file, can be recover data up to point of failure. Bulk Log recovery model: Requires log backups. It is simila...

LGSGEEK

 Profile Answers by LGSGEEK Questions by LGSGEEK

• Mar 29th, 2008

SIMPLE: Uses full or differential copies of the database. Truncates the transaction logs automatically. Does not backup the transaction log file(s). Changes made after the last backup cannot be re...

Answer Question  Select Best Answer

mbhsye786

 Profile Answers by mbhsye786 Questions by mbhsye786

• Jan 13th, 2014

Your answer is incorrect
Sql Server runs only on windows platform and is hardware dependent
where as
Oracle runs in any platform and hardware independent such as can run on unix and windows.

Sivaram

• Dec 31st, 2006

Basic DifferenceSql Server:Runs only on windows platform,Hardware independentoracle:Runs in any platform and hardware dependent..

Answer Question  Select Best Answer

murali chennupati

• Jul 5th, 2014

From jobs->new->step->categories->ssis->select db->select the package & schedule.

Answer Question  Select Best Answer

What is its purpose?How to use it?

Read Best Answer

Editorial / Best Answer

suji  

 Profile Answers by suji Questions by suji

• Member Since Sep-2005 | Nov 5th, 2011

---

Here are multiple ways to get the table information. The DESCRIBE command does not exist in MS SQL SERVER. This is an Oracle command used to describe the structure of objects within a given database. To achieve the same task in MSSQL Server, there are a series of stored procedures with the prefix SP_ that can be used. To view the structure of a table within the current database, use the command

Code
sp_help 'TABLE_NAME';

If you would like to see more details, Create your custom procedure

Code
CREATE procedure DESCRIBE 
(
@tablename varchar(256)
)
AS 
begin
SELECT DISTINCT sCols.colid AS 'order', sCols.name, sTyps.name, sCols.length
FROM [syscolumns] sCols
INNER JOIN [systypes] sTyps ON sCols.xtype = sTyps.xtype
INNER JOIN [sysobjects] sObjs ON sObjs.id = sCols.[id]
AND UPPER(sObjs.name) = UPPER(@tablename)
ORDER BY sCols.colid
end

Here is another alternative way to get the same information

Code
sp_columns 'TableName' (e.g. sp_columns 'Employee')
sp_columns [ @table_name = ] object [ , [ @table_owner = ] owner ] 
[ , [ @table_qualifier = ] qualifier ] 
[ , [ @column_name = ] COLUMN ] 
[ , [ @ODBCVer = ] ODBCVer ]

Here is the usage :

Code
EXEC sp_columns @table_name = 'Department', @table_owner = 'sa';
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TableName'

Contributors for the editorial answer : Kewlshiva, srilakshmi.b, raaghav,kevaburg

Rooshi

• Oct 17th, 2014

Sp_help will give all the details about the table columns, indexes, partitions etc.

Saket Kale

• Oct 24th, 2012

Sp_help dbo.customers;

worked for me just fine.

Thanks to the OP, this runs perfectly on SQL 2008 R2, do not know about other versions

Improve Answer

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 18th, 2015

Select * Into From Where 1=2

David Sarkar

 Profile Answers by David Sarkar Questions by David Sarkar

• Dec 12th, 2014

Select * Into New_table FROM Old_Table WHERE 1=0;

Answer Question  Select Best Answer

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

1. We can restrict the users access to the stored data by using Views. User can be given permission to access database through views that contain the specific data the user is authorized to see. 2. A...

Techiee

• Jun 12th, 2013

1. Hiding Unwanted(users do not have right to see those columns e.g login, password column in table) columns from the user.

2. Reduce the complexity of tables from using joins etc. in your query.

Answer Question  Select Best Answer

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

"c# SqlCommand command = new SqlCommand("dbo.sp_name", (SqlConnection)session.Connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParam...

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

Code
EXEC [dbo].[<Stored_Procedure Name>] [Parameters1, Parameters2 ....etc. ]

Answer Question  Select Best Answer

what are difference between SqlDataAdapter ,SqlCommand and SqlDataReader

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

SqlDataReader are used to retrieve data in read-only forward-only manner from the data source. It is not used for traversing the data or writing it back to the data source. So SqlDataReader are faste...

santhosh

• Aug 6th, 2012

Sqldatareader means only read the datas in the table..
sqldataadapter means the datas read and writes

Answer Question  Select Best Answer

How to define unique key in table? Is it possible to define one primary key and one unique key in a single table?

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

UNIQUE key constraint enforce uniqueness of the column on which they are defined. It allows the column to have distinct & one NULL values. We can make one or more columns unique in a table by defining...

erik

• Jul 21st, 2012

SQL UNIQUE key... The UNIQUE constraint uniquely identifies each record in a database table. The UNIQUE and PRIMARY KEY constraints both provide a guarantee for uniqueness for a column or set of col...

Answer Question  Select Best Answer

nabin

• Mar 25th, 2015

Normalization is all about reducing the redundancy where we segregate the data (a big row data) into multiple tables(does depend on various requirement and design) while maintaining the relationship b...

siva

• Apr 27th, 2012

It is good.I understood if you put some brief explanation with data, is very usable to the persons who are not understanding about normalization like me. ...

Answer Question  Select Best Answer

Can i update views in SQL if yes in what scenarios?
if your view is joining multiple tables

Ayushi

• May 7th, 2015

We can update simple views(having data from one table) and complex views(having data from multiple tables) but columns should be taken from one base table for update.

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 18th, 2015

Yes, we can update view when view is created by single table (simple view). If we want to Update view that are based on multiple tables using Joins, Update does not work. So we used "Instead of Triggers" for updating Complex view.

Answer Question  Select Best Answer

In application supporter for .net, interviewer ask me how you support the application,but I could not answer properly. Please explain answer technically?

Ravi Sharma

• Jun 2nd, 2015

We provided end to end solutions. Taking the requirement from client side, analysis on that requirement. Providing the analysis documents. Starting developing part then testing and deployment.

Answer Question  Select Best Answer

I was asked a question in an interview, where I was given a situation which is:
I have registered to an online gaming website. It displays my rank on the basis of my score when I play a game.
Database table has 2 columns: 1. UserName 2. Score.
Since the login page was loading very slowly so the programmers created an non-clustered index on UserName and now the welcome page problem...

Yaman

• Aug 10th, 2015

First of all table is not well designed. Table should have a clustered index. Right now its a heap and if we create a clustered index on username its a bad idea as data gets physically sorted everytim...

nabin

• Mar 25th, 2015

create clustered index on name. Reason is clustered index should be applied on columns which do not change frequently. Since the user will register once and will not change name that frequently it is ...

Answer Question  Select Best Answer

Explain Self Join with the help of an example?

Chaitali

• Sep 29th, 2015

Self join - Joining table itself called "Self join". In Self join we need to use alias for the same table.
Example -

SELECT E.EmpID, E.Name, M.Name As Manager Name
FROM Employee E SELF JOIN Employee M
WHERE E.MgrID = M.EmpID

asifeqbal

 Profile Answers by asifeqbal Questions by asifeqbal

• Mar 19th, 2015

The Join in which a table joined itself are called Self Join.

Code
SELECT M1.Name, M2.Name
FROM Manager M1 JOIN Manager M2 ON M1.EmpId=M2.EmpId

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Steven

• Oct 4th, 2011

---

Normalizatiopn is the process of splitting tables up to reduce record redundancy. For instance if you have a table of addresses you may want to create a table of cities and link the addresses to the cities table in a foreign key. Since the city names would be identical on several records this would save a lot of space. In some cases if tables are not normalized the amount of space they would take up would be so large that it would not be possible to record the data. The amount of normalization that you choose would depend upon how often field data is repeated throughout the table.

Jatin Girdhar, Gurgaon

• Oct 12th, 2015

SQL Normalization is a systematic approach of de-composing tables to: 1. To eliminate redundant (useless) data 2. To store the data logically Benefits: 1. Removes Data redundancy 2. Improves perform...

rayudu

• Oct 11th, 2011

Normalizatilon is the process of organizing the table to minimize the redundency

Improve Answer

badri

• Dec 9th, 2015

Can I write a trigger within Stored Procedure?

psingla

 Profile Answers by psingla Questions by psingla

• Mar 19th, 2010

No.Its automatically fired on DML statements.these can not be triggered manually.

Answer Question  Select Best Answer

How to read the data from a pdf in SSIS?

Amaleswar

• Jan 23rd, 2016

Using Import transformation.

Answer Question  Select Best Answer

Write a query to display employee records having same salary department wise?

Empname Empsalary Empdep
a 1000 IT
b 1000 CSE

Sreeram

• Jul 30th, 2016

Code
SELECT *
FROM  Employe A(nolock)
WHERE EXISTS(SELECT X FROM Employe B(nolock) WHERE B.Empsalary= A.Empsalary AND B.Empdep<> A.Empdep)

Modather Seddik

• Aug 7th, 2015

Code
SELECT * FROM Employe WHERE [Empsalary] = 1000 AND [Empdep] = 1000

Answer Question  Select Best Answer

How to extract the values from table based on the current date. How to write the query?

Select event_code from table name where date = sysdate

What will be added in the place of sysdate? This query will run daily to fetch the records.

Shiv

• May 18th, 2017

Select event_code from tablename where date=convert(varchar(10),getdate(),105)
GetDate() --- will give you the current date time
Convert function is used to convert the Date Time to Date
Using 105 code in the Convert function to convert it to DD-MM-YYYY Format

teja

• Mar 8th, 2017

GETDATE()

Answer Question  Select Best Answer

How to delete duplicate records?

Naveen

• Jun 16th, 2017

Insert the distinct rows from the duplicate rows table to new temporary table. Delete data from table which has duplicate rows then insert the distinct rows from the temporary table

Raj Acharya

• Sep 30th, 2016

Using CTE ...you can remove duplicate records in one query....

Answer Question  Select Best Answer