<< < 12 13 14 15 16 17 18 19 20 21 22 > >>   Sort: Rank

What is the use of trace utility?
What is the use of trace utility? Tracing is a very important monitoring and debugging tool for distributed, multitier applications. Such applications often contain problems that can only be observed when the application is under a heavy load and the inherent randomness of a real-life environment. T...
2014-11-10, 1062👍, 0💬

If we write any code for dataGrid methods, what is the access specifier used for that methods in the code behind file and why an
If we write any code for dataGrid methods, what is the access specifier used for that methods in the code behind file and why and how? Give an example. We use Friends Modifer for the dataGrid methods. Friend WithEvents DataGrid1 As System.Windows.Forms.DataGrid
2014-11-07, 1173👍, 0💬

Explain differences between framework 1.0 and framework 1.1
Explain differences between framework 1.0 and framework 1.1 1. Native Support for Developing Mobile Web Applications 2. Unified Programming Model for Smart Client Application Development 3. Enable Code Access Security for ASP.NET Applications 4. Native Support for Communicating with ODBC and Oracle ...
2014-11-07, 1188👍, 0💬

Describe session handling in webform. How does it work and what are the limits?
Describe session handling in webform. How does it work and what are the limits? Session management in ASP.NET can be done in two ways: Using Cookies Encoding of URLs with Session ID
2014-11-05, 1221👍, 0💬

What are the advantages/disadvantages of viewstate?
What are the advantages/disadvantages of viewstate? Disadvantages - Because the view state for a given page must be kept on the server, it is possible for the current state to be out of synchronization with the current page of the browser, if the user uses the Back feature on the browser to go back ...
2014-11-05, 1124👍, 0💬

How do you find the error, how can you know the number of rows affected by last SQL Statement?
How do you find the error, how can you know the number of rows affected by last SQL Statement? Answer1 @@errors-&gt;give the last error occured in the current DB. Ans. select @@rowcount Answer2. Use @@ERROR which returns the error number for the last Transact-SQL statement executed fro knowing t...
2014-11-03, 1075👍, 0💬

What is Task?
What is Task? Whenever you execute a program, the operating system creates a new task for it. The task is like an envelope for the program: it identifies the program with a task number and attaches other bookkeeping information to it.
2014-11-03, 1193👍, 0💬

What is job?
What is job? It can be defined as a task performed by a computer system. For example, printing a file is a job. Jobs can be performed by a single program or by a collection of programs.
2014-10-31, 1118👍, 0💬

How do we upgrade SQL Server 7.0 to 2000?
How do we upgrade SQL Server 7.0 to 2000? Run the installation of the SQL Server 2000 In the Existing Installation dialog box, click Upgrade your existing installation, and then click Next. In the Upgrade dialog box, you are prompted as to whether you want to proceed with the requested upgrade. Clic...
2014-10-31, 1112👍, 0💬

What is OLAP?
What is OLAP? OLAP is an acronym for On Line Analytical Processing. It is an approach to quickly provide the answer to analytical queries that are dimensional in nature.
2014-10-29, 1188👍, 0💬

What is DataWarehousing?
What is DataWarehousing? A data warehouse is a collection of data gathered and organized so that it can easily by analyzed, extracted, synthesized, and otherwise be used for the purposes of further understanding the data.
2014-10-29, 1216👍, 0💬

Explain features of SQL Server like Scalibility, Availability, Integration with Internet.
Explain features of SQL Server like Scalibility, Availability, Integration with Internet. Scalibility - The same Microsoft SQL Server 2000 database engine operates on Microsoft Windows 2000 Professional, Microsoft Windows 2000 Server, Microsoft Windows 2000 Advanced Server, Windows 98, and Windows M...
2014-10-27, 1046👍, 0💬

What is de-normalization? When do you do it and how?
What is de-normalization? When do you do it and how? De-normalization is the process of attempting to optimize the performance of a database by adding redundant data. It’s used To introduce redundancy into a table in order to incorporate data from a related table. The related table can then be elimi...
2014-10-27, 1107👍, 0💬

Explain differences between server.transfer and server.execute method?
Explain differences between server.transfer and server.execute method? Answer1: server.transfer-&gt; transefers the server’s control to the requested page given in the parameter. server.Execute-&gt; executes the requested page from the current page itself,with no change in the address bar. a...
2014-10-22, 1227👍, 0💬

What is indexing?
What is indexing? If we give proper indexes on a table so that any queries written against this table can run efficiently. As your data sets grow over time, SQL Server will continue to rebuild indexes and move data around as efficiently as possible. This property is known as Indexing.
2014-10-22, 1195👍, 0💬

What is referential integrity and how can we achieve it?
What is referential integrity and how can we achieve it? Referential integrity preserves the defined relationships between tables when records are entered or deleted. In SQL Server, referential integrity is based on relationships between foreign keys and primary keys or between foreign keys and uniq...
2014-10-20, 1231👍, 0💬

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, 1045👍, 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, 1151👍, 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, 1131👍, 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, 1205👍, 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, 1120👍, 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, 1053👍, 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 th...
2014-10-13, 1470👍, 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 the b...
2014-10-10, 1304👍, 0💬

<< < 12 13 14 15 16 17 18 19 20 21 22 > >>   Sort: Rank