.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

<< < 1 2 3 4 5 6 7 8 … > >>   Sort: Rank

How do you use DBCC statements to monitor various ASPects of a SQL Server installation?
How do you use DBCC statements to monitor various ASPects of a SQL Server installation? Database Consistency Checker (DBCC) - Is a statement used to check the logical and physical consistency of a database, check memory usage, decrease the size of a database, check performance statistics, and so on.... 2014-10-20, 1350👍, 0💬

What is the purpose of UPDATE STATISTICS?
What is the purpose of UPDATE STATISTICS? UPDATE STATISTICS- it updates information about the distribution of key values for one or more statistics groups (collections) in the specified table or indexed view. 2014-10-17, 1479👍, 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, 1451👍, 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, 1528👍, 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, 1439👍, 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-&gt; inserts into it without removing any thing. Replace-&gt;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, 1382👍, 0💬

What is an execution plan? When would you use it? How would you view the execution plan?
What is an execution plan? When would you use it? How would you view the execution plan? The Query Analyzer has a feature called Show Execution Plan. This option allows you to view the execution plan used by SQL Server’s Query Optimizer to actually execute the query. This option is available from... 2014-10-13, 1805👍, 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, 1633👍, 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, 1651👍, 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, 1667👍, 0💬

How to find the SQL server version from Query Analyser
How to find the SQL server version from Query Analyser Answer1 To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement: SELECT SERVERPROPERTY(’productversi on’),SERVE... 2014-10-08, 1463👍, 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, 1539👍, 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, 1616👍, 0💬

How many types of cookies are there?
How many types of cookies are there? Answer1 Two type of cookeies. a) single valued eg request.cookies(”UserName” ).value=”Mahesh”b)Multivalued cookies. These are used in the way collections are used. e.g. request.cookies(”CookiName†)(”UserName”)=”Mahesh†request.... 2014-10-03, 1563👍, 0💬

Explain differences between ADO and DAO.
Explain differences between ADO and DAO. dao- can access only access database ado- can access any databases 2014-10-03, 1556👍, 0💬

What is State?
What is State? It is the property of the web forms. ASP.NET provides four types of state: Application state Session state Cookie state View state. 2014-10-01, 1553👍, 0💬

Name atleast two methods of response object other than Transfer.
Name atleast two methods of response object other than Transfer. a) Response.ClearContent( ) Clears the content of the current output stream. b) Response.ClearHeaders( ) Clears the HTTP headers from the current output stream. 2014-10-01, 1506👍, 0💬

Name atleast three methods of response object other than Redirect.
Name atleast three methods of response object other than Redirect. Answer1 a) Response.Clear( ) Clears the content of the current output stream. b) Response.Close( ) Closes the network socket for the current response. c) Response.End( ) Stops processing the current request and sends all buffered con... 2014-09-29, 1577👍, 0💬

What does Server.MapPath do?
What does Server.MapPath do? Answer1 srver.mappath() maps the path given in the argument to the server’s physical path. Answer2 It returns the complete(absolute) path of the file used in parameter. Answer3 It returns a string containing the physical path in the server’s file system that corres... 2014-09-29, 1420👍, 0💬

Is there any inbuilt paging (for example shoping cart, which will show next 10 records without refreshing) in ASP? How will you
Is there any inbuilt paging (for example shoping cart, which will show next 10 records without refreshing) in ASP? How will you do pating? Use DataGrid control which has in-built paging features for the purpose. 2014-09-26, 1486👍, 0💬

Which DLL file is needed to be registered for ASP?
Which DLL file is needed to be registered for ASP? The dll needed for the ASP.net is SYSTEM.WEB.dll 2014-09-26, 1631👍, 0💬

How many objects are there in ASP?
How many objects are there in ASP? Answer1 8 objects, they are request,response, server,application,session,fil e,dictionary, textstream. Answer2 There are 6 objects in ASP.net a) Server b) Session c) Application d) ObjectContext e) Response f) Request 2014-09-24, 1623👍, 0💬

Specify the best ways to store variables so that we can access them in various pages of ASP.NET application?
Specify the best ways to store variables so that we can access them in various pages of ASP.NET application? Declare the variables in Global.aspx 2014-09-24, 1565👍, 0💬

What are the XML files that are important in developing an ASP.NET application?
What are the XML files that are important in developing an ASP.NET application? The XML file necessary for the for developing an asp.net application is Web.config 2014-09-22, 2046👍, 0💬

<< < 1 2 3 4 5 6 7 8 … > >>   Sort: Rank

.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