sutanu_halder

 Profile Answers by sutanu_halder Questions by sutanu_halder

• Dec 14th, 2007

There are over 80 distinct system privileges. Each system privilege allows a user to perform a particular database operation or class of database operations.Such as:- 1. ANALYZE ANY   ...

Answer Question  Select Best Answer

If I have 10 statements, individually committing each statement is efficient or doing a bulk commit of all the 10 statements at the end is efficient.Also if we say one of them is efficient... is it efficient in space or time or cpu?Thanks,rbala_sjsu

debasis.yours

 Profile Answers by debasis.yours Questions by debasis.yours

• Dec 14th, 2007

There is a trade-off in this case. In case of transaction-oriented scenario, I think executing 10 statements separately would be a better option since it will hold the lock for a very short duration a...

Answer Question  Select Best Answer

debasis.yours

 Profile Answers by debasis.yours Questions by debasis.yours

• Dec 14th, 2007

Definitely Windows Authentication Mode. Firstly, the Windows security policy is used to authenticate is employed at user login reducing extra overhead. Secondly, if we implement any extra group policy...

Answer Question  Select Best Answer

Error While creating BACKUP:I am Creating FullBackup for one database Named Postings.I executed below Query and i am getting The Below error message.USE mastergoEXEC SP_ADDUMPDEVICE 'disk','PostingsBac','E:BACKUPPostingsBac.BAK'BACKUP DATABASE Postings TO PostingsBacERROR:'Device Created'One Row Effected.Server: Msg 3201, Level 16, State 1, Line 1Cannot open backup device 'PostingsBac'. Device error...

debasis.yours

 Profile Answers by debasis.yours Questions by debasis.yours

• Dec 14th, 2007

This is basically a problem with the physical path of the Backup device, I suppose. Be sure the physical path that you are giving has full access from your Windows user Account or not.

Answer Question  Select Best Answer

vijaya_pitta

 Profile Answers by vijaya_pitta Questions by vijaya_pitta

• Dec 12th, 2007

Architecture is the frame work of the Database Management System. They are simply classified into logical and physical.

Answer Question  Select Best Answer

I would like to know whether it uses SOAP or XML.

opbang

 Profile Answers by opbang Questions by opbang

• Dec 9th, 2007

XML for Analysis (XMLA) is a Simple Object Access Protocol (SOAP)-based XML protocol, designed specifically for universal data access to any standard multidimensional data source residing on the Web. ...

Answer Question  Select Best Answer

How to display the table data in XML format using SQL Server.

Ravi

• Nov 21st, 2007

The only thing you have to do is to insert "for XML Auto" in your query and the result will be returned in XML format.Eg. Let there be a table with name tblABCNormally??? Select * from tblABCFor XML Data??? Select * from tblABC for XML Auto

Answer Question  Select Best Answer

Abhinav Jain

• Nov 19th, 2007

User Identification: In virtue of Data base server Identification tries to find whether you are registered user in the database or not. It applies to whole database server. Authentication: It ap...

Answer Question  Select Best Answer

teju

• Nov 5th, 2007

You have to connect your database first than you can open asly.....

Answer Question  Select Best Answer

Chetna

• Oct 16th, 2007

SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties > Por number, both on client and the server.

Answer Question  Select Best Answer

Chetna

• Oct 16th, 2007

If a Trigger is having Insert/Update/Delete statement of a table which is also having a trigger defined on it for Insert/Update/Delete, then Trigger1 would cause Trigger2 to get fired when a data Manipulation has occured. This is called nested trigger.

Answer Question  Select Best Answer

ex. Smith,John,India

Chetna

• Oct 16th, 2007

Save the query results to .csv file.

Answer Question  Select Best Answer

dheeruchakri

 Profile Answers by dheeruchakri Questions by dheeruchakri

• Oct 10th, 2007

Create Procedure TestExportasBeginxp_cmdshell 'bcp "SELECT * from YourDatabase.dbo.YourTable" QueryOut d:Temptest.xls -S alexissqlsrv01 -U dpi -P Value*() -c -T'EndAll the Best.- Dheeraj.

Dheeraj Chakravarthy

• Oct 10th, 2007

Create Procedure TestExportasBeginxp_cmdshell 'bcp "SELECT * from YourDatabase.dbo.YourTable" QueryOut d:Temptest.xls -S alexissqlsrv01 -U dpi -P Value*() -c -T'EndAll the Best.- Dheeraj.

Answer Question  Select Best Answer

askvenki

 Profile Answers by askvenki Questions by askvenki

• Aug 13th, 2007

It is to know the no of rows feched from cursorIt is used in situations likeWe have to do the modifications up to five rowsTheir is some situations to print up to no of rows fetched from cursorIn pl/sql table it is used like an array index to store values

waqarali

 Profile Answers by waqarali Questions by waqarali

• Jul 30th, 2007

In the stored procedures to the total counts of the rows affected by the 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

genie_cool

• Jun 6th, 2007

use TableLocks or RowLocks to prevent the other user from modifying the data when the previous user is using the same data.

vmandviya

 Profile Answers by vmandviya Questions by vmandviya

• Feb 5th, 2007

See if two user are updating same time at same time it will affect one by one!! it means 1st user changes will accept then 2nd user changes it iwll accept

Answer Question  Select Best Answer

Genie_Cool

• Jun 4th, 2007

Dirty Pages: Data that has been modified and Stored in the buffer cache and has not yet been written in to the hard disk. (Transaction Logs)Dirty reads: Reading the data that is actually read by Trans...

Answer Question  Select Best Answer

Genie_Cool

• Jun 1st, 2007

If we are speaking about SQL Server and Dynamic SQL, then the following is the answer.Some queries in SQL Server might be given during run-time as we may not know the table that we might use in the pr...

rahultripathi

 Profile Answers by rahultripathi Questions by rahultripathi

• Sep 22nd, 2005

In dynamic SQL method 4 in  queries(select ) there are variable number of column and bind variable . Other word we can say that until run time we don't how many bind varible there.   Exemple...

Answer Question  Select Best Answer

srikanth tirunagari

• May 25th, 2007

1) perform a tail log backup.2) restore wednesday's File 3 backup with no recovery3) restore all hourly transaction log backups in sequence taken after 8 pm on wednesday with no recovery4) finally restore the tail log backup with recovery

Answer Question  Select Best Answer

jayaprakash.raman

 Profile Answers by jayaprakash.raman Questions by jayaprakash.raman

• Apr 24th, 2007

Normalization is the technique of breaking the complex tables into much understandable smaller one to improve the optimzation of the database structure. The concept of "Fucntional Dependancy"...

sm

• Nov 9th, 2005

In database table design we are providing Primary key and Foreign keys.And according to primary and Foreign keys tables are functionaly dependent on each other.

Answer Question  Select Best Answer