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 10292
Difference between Cluster and Non-cluster index?32 123348
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1195
explain different types of jions with examples briefly?2 5685
Which databases are part of SQL server default installation? Explain the usage of each?2 4788
What all db objects can be found in MSDB database of a SQL Server instance?2 4992
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 8455
What is Query Execution Plan? How does it help optimize or tune a database driven application?2 7093
How do you fine the performance tunning?2 5440
What are mdf,ndf,ldf files and how to see the data in those files?6 53478
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 14373
Differences between functions and stored procedures?8 9068
event classes in sql server2 4588
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.11 11265
what is the -ve test case in your project.
why we call vestigial side band(VSB) as c3f?
Does anyone know of any genetic defects on animals? I'm just curious why I've never seen an animal with gigantism, or dwarfism, or down syndrome. I'm sure they all dont die at birth. I'm really interested in some information on this. thanks
What are the main issues associated with multiprocessor caches and how might you solve them?
do anyone out there know where to find a compleete list on acronyms/abbreviations used in offshore electric engineering. MCB - Micro Circuit Breaker, MCCB-Mouldes Case Circuit Breaker, ELCB-Earth Lekage Circuit Breaker, ELMCB- etc.....
How to design the NGR Resistance
After first installation of Solaris 10, what and all the Securities We need to set and how ?
Where can I get excellent free Business Analyst training online?
what is Networking?
how we can know the funcions available in a class recording java?
how do I disable dmp?
What is VSCF windelectrical system?
what is the difference between concept and theory
on “sed” command EmpData(Sample Database) 1122|j.b. saxena |g.m. |account |12/12/52|6000 2233|n.k. gupta |d.g.m |sales |31/12/40|9000 4545|anil agarwal |director |account |06/07/47|7500 5656|lalit choudhury |executive|marketing|07/09/50|5000 1265|chanchal singhvi|g.m. |admin |12/09/63|6000 0110|shyam saksena |chairman |marketing|12/12/43|8000 5566|jai sharma |director |account |23/12/89|7000 7733|jayant |d.g.m |sales |29/02/70|6000 1. From the above database substitute the delimiter of first 3 lines with “ : “ 2. From the above database substitute the delimiter with “ : ” 3. Insert the string “ XYZ Employees” in the first line. 4. Store the lines pertaining to the directors, d.g.m and g.m into three separate files. 5. Using address store first 4 lines into a file Empupdate. 6. Find the pattern “account” in the database and replaces that with “accounts”. 7. Select those lines which do not have a pattern “g.m”. 8. Insert a blank line after every line in the database.
IN MY SYSTEM THERE IS ONLY OVER CURRENT EARTH FAULT RELAY IS AVAILABLE. FOR THE UNBALANCE SENSING IS THERE ANY RELAY IS AVAILABLE? THE SAME CTs WHICH ARE USED FOR THE OVER CURRENT EARTH FAULT RELAY CAN USE FOR UNBALANCE ALSO?