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 t

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

Home > .NET

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â€?

✍: Guest

Answer1.
Use Storedprocedure for any optimized result, because it is an compiled code.

Answer2.
One of the best ways to increase query performance is to use indexes.

2014-10-10, 2033👍, 0💬

What is the purpose of using COLLATE in a query?
What is the purpose of using COLLATE in a query? Answer1. Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character typ... 2014-10-10, 2076👍, 0💬

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table.
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table. Answer1. a. Select count(*) from table1 b. SELECT object_name(id) ,rowcnt FROM sysindexes WHERE indid IN (1,0) AND OBJECTPROPERTY(id, â€˜IsUserTableâ€™) = 1 c. exec sp_table_validation @table = â... 2014-10-08, 2069👍, 0💬

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 t
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â€? Answer1. Use Storedprocedure for any optimized result, because it is an compiled code. Answer2. One of... 2014-10-10, 2034👍, 0💬

Tell few steps for optimizing (for speed and resource) ASP page/application.
Tell few steps for optimizing (for speed and resource) ASP page/application. Avoid mixing html code with asp code 2014-10-06, 2008👍, 0💬

What is the difference between a Local temporary table and a Global temporary table? How is each one used?
What is the difference between a Local temporary table and a Global temporary table? How is each one used? Answer1: Local templrary table will have a single # (#tablename) appended with the table name.Global templrary table will have Double # (##tablename) appended with the table name. Ex:create tab... 2014-10-15, 1929👍, 0💬

Which command using Query Analyzer will give you the version of SQL Server and Operating System?
Which command using Query Analyzer will give you the version of SQL Server and Operating System? @@VERSION Returns version, processor architecture, build date, and operating system for the current installation of SQL Server. 2014-10-06, 1924👍, 0💬

What does it mean to have quoted_identifier on? What are the implications of having it off?
What does it mean to have quoted_identifier on? What are the implications of having it off? SET QUOTED_IDENTIFIER ON- Causes SQL Server to follow the SQL-92 rules regarding quotation mark delimiting identifiers and literal strings. Identifiers delimited by double quotation marks can be either Transa... 2014-10-15, 1870👍, 0💬

What are cursors? Name four type of cursors and when each one would be applied?
What are cursors? Name four type of cursors and when each one would be applied? Opening a cursor on a result set allows processing the result set one row at a time. The four API server cursor types supported by SQL Server are: a) Static cursors b) Dynamic cursors c) Forward-only cursors d) Keyset-dr... 2014-10-17, 1863👍, 0💬

What is the STUFF function and how does it differ from the REPLACE function?
What is the STUFF function and how does it differ from the REPLACE function? Answer1: stuff-> inserts into it without removing any thing. Replace->replace the given text with the new one. Answer2: STUFF - it deletes a specified length of characters and inserts another set of characters... 2014-10-13, 1843👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.