SQL Server Interview Questions
Questions Answers Views Company eMail

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 1953

one table has four field id,name,design,salary. i have to find maximum salary .

6 3402

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 7973




you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 2331

How to find the date and time of last updated table?

Teledata,

6 5124

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 18182

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 5719

What value could be assigned to Varchar Type?

3 3014




Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 2924

What types of integrity are enforced by a foreign-key constraint

1 2481

What are the main control-of-flow T-SQL constructs?

1 3149

What are the two virtual tables SQL Server maintains for triggers?

3 5555

What does the INSTEAD OF trigger do?

3 4654

What are explicit and implicit transactions?

BirlaSoft,

4 16968

What are the two types of concurrency?

4 4601


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How to restore performance issues and how to check?

844


query processing

1000


What is best institute to Learn DotNET And SQL in chennai?

968


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1351


What are the dis_advantages of stored procedures, triggers, indexes?

968






In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

873


Working with TLogs

683


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

904


How you trouble shoot when any job fails

684


System variable and temporary variables

978


how many no of arguments can be passed in procedures and functions

3493


New concepts of sql server 2005 use in your project.

1235


your distribution database is full what will u do

956


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

312


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

947