What is tail log backup? Where can we use it?

Kiran Patil

 Profile Answers by Kiran Patil Questions by Kiran Patil

• Mar 26th, 2008

Tail Log Backup is the log backup taken after data coruption (Disaster). Though there is file corruption we can try to take log backup (Tail Log Backup). This will be used during point in time re...

Answer Question  Select Best Answer

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

Kiran Patil

 Profile Answers by Kiran Patil Questions by Kiran Patil

• Mar 26th, 2008

Yes, there is table partitioning in SQL Server. Unfortunately I don't know how to do that, If anyone knows that, let me know.

Answer Question  Select Best Answer

Kiran Patil

 Profile Answers by Kiran Patil Questions by Kiran Patil

• Mar 26th, 2008

Select * from sysdatabases

prashanth.n

 Profile Answers by prashanth.n Questions by prashanth.n

• Jan 30th, 2008

Use "sp_databases" stored procedure

Answer Question  Select Best Answer

sutanu_halder

 Profile Answers by sutanu_halder Questions by sutanu_halder

• Mar 29th, 2008

DTS is a set of tools you can use to import, export, and transform heterogeneous data between one or more data sources, such as Microsoft SQL Server, Microsoft Excel, or Microsoft Access.The Import/Ex...

Answer Question  Select Best Answer

rudatha

 Profile Answers by rudatha Questions by rudatha

• Apr 23rd, 2008

Select * into new table name from old table name where 1=0

ramakrishnasri

 Profile Answers by ramakrishnasri Questions by ramakrishnasri

• Dec 6th, 2007

Hai,here is the example for ypour qustionselect * into emp1 from emp where 1=9execute this u can have the structure of the new table as old with out the data in the new tablei hope it will solve your problem

Answer Question  Select Best Answer

Hello:I would like you to help me guys for my Project Dynamic Document Management System (DDMS) .I was looking for any information to help me to make my project ,but I couldn’t find good recourses to help my. If you have any idea to help me or books ,I’ll be very grateful. Especially about how to create and design Dynamic database SQL Server 2005 .

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

What is the different between Logging and Transaction?

Explain what is Distributed deadlock?

How to select Distinct columns from the table, table having 20 columns and i want all columns

Thenchinnu

 Profile Answers by Thenchinnu Questions by Thenchinnu

• May 15th, 2008

SELECT DISTINCT *FROM Tabe1

Answer Question  Select Best Answer

How to transfer data from a text file to SQL table, Which is the best method to do that?

sakthi.jaganathan

 Profile Answers by sakthi.jaganathan Questions by sakthi.jaganathan

• Aug 25th, 2008

By using OPENROWSET commandExample:                   INSERT INTO dbo.ImportTestSELECT * FROM OPENROWSET('Microsoft.Jet.OLED...

Answer Question  Select Best Answer

smithsi

 Profile Answers by smithsi Questions by smithsi

• Jun 2nd, 2008

Set statistics io onset statistics time on

sapna

• Sep 20th, 2006

set showplan onset showplan_text on

Answer Question  Select Best Answer

ramaniy

 Profile Answers by ramaniy Questions by ramaniy

• Jun 2nd, 2008

Prefix column name with table name like tableName.columnName

Answer Question  Select Best Answer

Naseer4u

 Profile Answers by Naseer4u Questions by Naseer4u

• Aug 6th, 2008

Select * from sysobjects where xtype='U'

srikanth tirunagari

• May 25th, 2007

select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'BASE TABLE'

Answer Question  Select Best Answer

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

Use IsNULL(,value) .If query return null ,it will replace by  value.

Pandian S

 Profile Answers by Pandian S Questions by Pandian S

• Mar 5th, 2007

Hi1. Without any Null Value for Column1:Select * From Table1 Where Column1 Is Not Null2. Instead of Null values it returns as '0':Select IsNull(Column1,0) Column1,* From Table1

Answer Question  Select Best Answer

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

Deadlock occurs when two or more processes have?lock objects and each process is trying to acquire a lock on an object that the other processes have previously locked.? Let p1 process? has an exclu...

rup

• Jan 30th, 2007

Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other's piece. Each process would wait indefinitely for the other to release the ...

Answer Question  Select Best Answer

Question: Write a SQL Stored Procedure to create a GUID and add it to a table. Make that GUID an OUTPUT of that Procedure

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

Create a out parameter.Set?value with NewId() which return a guid.then insert it into a table.

sutanu_halder

 Profile Answers by sutanu_halder Questions by sutanu_halder

• Dec 14th, 2007

GUIDs are created by the newid() function. If the default of the primary key is set to NewID(),a new GUID is generated for any new row. In addition, the newid() function may be declared within an inse...

Answer Question  Select Best Answer

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

There is no hard and fast rule. It depends on you SQL statements.There some usefull guideline.Turn on Execution plan.Avoid cursorUse Cluster index (try to keep it small).If possible use 'If Exit'Try to avoid Rebuild option.

subhashsubramanyam

 Profile Answers by subhashsubramanyam Questions by subhashsubramanyam

• Apr 17th, 2008

Optimizing Stored Procedure involves1) Identify long runnning queries and rectify issues associated with it2) Identify whether they are resource intensive (Eg: I/O intensive ? Replace Cursor...

Answer Question  Select Best Answer

How are SQL Server databases physically stored under Windows 2000?