What is the Difference between Attach and Restore of a Database?

Kiran Patil

 Profile Answers by Kiran Patil Questions by Kiran Patil

• Mar 26th, 2008

Database attach is faster as compaired to Database Restore. SO if you have both options then may be you can choose Database attach than Database Restore.

nbkb9hv

 Profile Answers by nbkb9hv Questions by nbkb9hv

• Feb 13th, 2008

Both are used to restore database, we Use attach database when we have .mdf file to upload data into database while we use restore database when we have .bak file to upload data into database.

Answer Question  Select Best Answer

What will you do if a trigger fails during execution?

charanpathania

 Profile Answers by charanpathania Questions by charanpathania

• Apr 1st, 2009

Rollback your transaction

bugeye

 Profile Answers by bugeye Questions by bugeye

• Mar 14th, 2008

Does it fail all the time?  Did it run before?  Most trigger issuses are with datatype mismatches or constraint voiolations .  Run the DML statement in a SSMS query to see what the error message is. 

Answer Question  Select Best Answer

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

What are the general functions available in SQL?

aghiad

• Sep 11th, 2011

The General function are use in SQL 1-NVL (exp1,exp2) 2-NVL2 (exp1,exp2,exp3) 3-NULLIF (exp1,exp2) 4-COALESCE (exp1,exp2,exp3,......,expn) For example: "sql SELECT last_name...

ElavarasiGophannan

 Profile Answers by ElavarasiGophannan Questions by ElavarasiGophannan

• Feb 11th, 2009

Aggregate Functions: AVG() - Returns the average value  COUNT() - Returns the number of rows FIRST() - Returns the first value LAST() - Returns the last value MAX() - Returns the largest...

Answer Question  Select Best Answer

What are the types of authentications supported SQL Server

ashwani.kumar

 Profile Answers by ashwani.kumar Questions by ashwani.kumar

• Sep 10th, 2008

1) Windows Authentication2) SQL Server Authentication

gopi2008

 Profile Answers by gopi2008 Questions by gopi2008

• Apr 18th, 2008

Sql Server supports two types authentications1)Windows Authentication2)SQL Server Authentication

Answer Question  Select Best Answer

I want to know what do we mean by Database Testing, as well as what role does a Database Tester plays meaning does he performs the similar role as a DBA does or what exactly?What things are performed in Database Testing?

psingla

 Profile Answers by psingla Questions by psingla

• Mar 4th, 2010

Database is a backbone of any of the dynamic web site. It needs a through testing to make an efficient and almost error free site.Database Testing includes:    Load testing   ...

goksn

 Profile Answers by goksn Questions by goksn

• Sep 23rd, 2009

There are various levels in database testing, starting from just seeing whether the database has correct value to 'SQL injection'.Generally database testing includes verification of-Accuracy o...

Answer Question  Select Best Answer

srialekhya

 Profile Answers by srialekhya Questions by srialekhya

• Apr 22nd, 2009

Windows authentication is highly secure than SQL Server authentication why because we need not provide any login details. So the chance of tracing login details from code by the unauthorized?persons will be less. Windows?authentication uses the default windows login credentials.

sidver

 Profile Answers by sidver Questions by sidver

• Jul 16th, 2008

Windows authentication will uses the credentials of the currently logged user to login in to the sql server database. Your application need not to supply the user name and password. for SQL server...

Answer Question  Select Best Answer

How to insert data in multiple tables at same time. using SQL Server 2000

krishna8081

 Profile Answers by krishna8081 Questions by krishna8081

• Feb 24th, 2009

Here is the example for you question.

USE YourDB
GO
INSERT INTO
MyTable (FirstCol,
SecondCol)
SELECT First
,1
UNION ALL
SELECT Second
,2
UNION ALL
SELECT Third
,3
UNION ALL
SELECT Fourth
,4
UNION ALL
SELECT Fifth
,5
GO

swathi660

 Profile Answers by swathi660 Questions by swathi660

• Jan 15th, 2009

Insert into t1 values(,,,) insert into t2 values(,,,) insert into t3 values(,,,,)......try this ........

Answer Question  Select Best Answer

What is T-SQL means? How it is different from SQL?

psingla

 Profile Answers by psingla Questions by psingla

• Mar 3rd, 2010

SQL/PL-SQL/T-SQLSQL(Structured Query Language): is a ANSI complinent languge to operate a database.It includes DDL(Create,alter,drop,truncate),DML(select,insert,delete,update) and  DCL(Grant,revo...

ajitnayak

 Profile Answers by ajitnayak Questions by ajitnayak

• Feb 28th, 2009

As the name indicates that T-SQL means transact SQL queries developed by Microsoft. It is a programming language and the difference between SQL and T-SQL is SQL is the base class for T-SQL and T-SQL is inherited from SQL having some extra features as compared to SQL.

Answer Question  Select Best Answer

What is 'no lock' term in SQL, like "select * from table a (no lock)". What is its purpose?

psingla

 Profile Answers by psingla Questions by psingla

• Mar 19th, 2010

Define: By default select puts exclusive lock. Specifying no lock puts no lock on the table.Advantage: Improve the peformanceDisadvantage: Dirty reads Suggestion: Use in static table data (with fewer DML operations)

sidhuonline

 Profile Answers by sidhuonline Questions by sidhuonline

• Jun 30th, 2009

It is useful to improve the performance in executing the query. However there is a disadvantage in using it. The disadvantage is that one may not be sure that they are getting the data which is curren...

Answer Question  Select Best Answer

Why Transactions are needed in SQL Server?

kirangiet

 Profile Answers by kirangiet Questions by kirangiet

• Aug 17th, 2010

SQL Transactions ensure to follow ACID Properties.A-Atomicity: Using Transactions, either none or all the statements inside the transaction will execute successfully.C-Consistency: Using Transact...

sanjaykp

 Profile Answers by sanjaykp Questions by sanjaykp

• Mar 12th, 2010

To guarantee the authenticity and integrity of any change to data in a database(s), be it an insert, update or delete. Transactions are a fundamental tool used by all industry standard Relation Databa...

Answer Question  Select Best Answer

What is a key in SQL?

Mayank Tripathi

 Profile Answers by Mayank Tripathi Questions by Mayank Tripathi

• Jan 18th, 2012

Candidate Key, Alternate Key, Composite Key are also the parts of SQL Server: A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary ke...

psingla

 Profile Answers by psingla Questions by psingla

• Nov 8th, 2010

We have different types of keys in sql:primary key      identify record uniquely     max one per table     do not contain null values &...

Answer Question  Select Best Answer

In which scenario I can use the unique key and primary key in SQL Server .
I mean in real life database how can I judge where I have to use the unique key and primary key.

sunil neha juhi singh

• Jun 28th, 2012

Primary key=not allow null values,create cluster index by default.
unique key=allow only one null values and by default it create non cluster index

kushgudseva

 Profile Answers by kushgudseva Questions by kushgudseva

• May 29th, 2012

A Unique ID and Primary Key Constrain perform the ability to allow unique data in the column but only the Unique constrain allows NULL values in the field along with the unique data. Primary Key constrain fields allow Unique and Not NULL values.

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

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
 

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
 

Modather Seddik

• Aug 7th, 2015

Code
 

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

sreddy_bond

 Profile Answers by sreddy_bond Questions by sreddy_bond

• May 9th, 2008

Rownum is the id which is assigned to recored, by the time of record set selected (executed).Rowid is, the id which is assigned physically to each record in table.RegadsSarele

Bill

• Nov 10th, 2006

   sql dbname < script_filename > output.out 2>&1

Answer Question  Select Best Answer

psingla

 Profile Answers by psingla Questions by psingla

• Mar 17th, 2010

Hints are instructions given by the developer in the query to use a particular type of exectuion plan.Whenever a query is written then sql comipler creates n number of execution plans and opt for the ...

Bobby

• Oct 13th, 2007

Hints are options or strategies specified for enforcement by the SQL Server 2005 query processor on SELECT, INSERT, UPDATE, or DELETE statements. The hints override any execution plan the query optimizer might select for a query.

Answer Question  Select Best Answer

bharathi

• Jul 12th, 2007

Comparing to SQL Server 2000 SQL Server 2005 have more features1. Reporting?services are available 2. .Net integration3.?HTTP protocols

jayaprakash.raman

 Profile Answers by jayaprakash.raman Questions by jayaprakash.raman

• Apr 26th, 2007

There are plenty of enhancements added since Sql Server 2000. Every feature cannot be explined here. Better you refer Sql Server 2005 Books Online for detailed answer. Also Refer http://www.microsoft....

Answer Question  Select Best Answer