What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?2 10111
Difference between Cluster and Non-cluster index?32 122798
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1149
explain different types of jions with examples briefly?2 5597
Which databases are part of SQL server default installation? Explain the usage of each?2 4688
What all db objects can be found in MSDB database of a SQL Server instance?2 4907
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?3 8364
What is Query Execution Plan? How does it help optimize or tune a database driven application?2 6984
How do you fine the performance tunning?2 5357
What are mdf,ndf,ldf files and how to see the data in those files?6 53223
how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?15 14081
Differences between functions and stored procedures?8 8932
event classes in sql server2 4463
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.11 11013
What type of entry after consignment business starting?
Purpose of TTL. How it gets modified.
What are the causes of positive and negative propeller slip?
How much qty of stone ; sand; cement in R/R stone masonry of 136 CUM
How to calculate closing stock? I have opening stock of 72 lacs (average costing without tax) and purchase of 49 lacs (with tax) and sales of 101 lacs (without tax). What is my closing stock then???? Should i add tax in sales? Where all should tax be included and where all should tax NOT be included? Right now i calculated => 72(no tax)+49(with tax)-101(no tax) = 20 lacs. IS this correct?
Hi Friends i am going to write BARC written test by this month 20th (20-5-2008). So please if any body knows the details about this or having previous question papers pls mail me to email@example.com. For Suggestions give one message to 9962122264
What do you like most about Quality Assurance/Testing?
i completed bsc microbiology,DMLT and i finished ILETS exam and got overall 5.5 score,is it possible to get job in melbourne hospital,wat i hav to do
What is missing report and how to prepare
How do you compare the structure of 2 tables in database and check whether they are similar using qtp.
"WHERE THERE IS A RIGHT, THERE IS REMEDY" EXPLAIN THIS WITH REFERENCE TO BREACH OF CONTRACT.
Somebody tell me in what way i need to prepare for csio pgrpe(adv instrum eng)interview?what all the quest can i expect?
purchase car from toyota innova 50000 cheque from one firm and 449893 from other firm.... and 1350000 loan saction from kotak mahindra.....how can entry make with interest
hi i want license key for qtp 9.2 pls its adjust product name : quick test professional locking code :8 - 54A6A license type : seat license maintenance number : 88888888-8888 pls send license key to my email id firstname.lastname@example.org
please guide me from where I got semple of written test solved paper