.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   Sort: Date

How can you increase SQL performance
How can you increase SQL performance ? Following are tips which will increase your SQl performance Every index increases the time takes to perform INSERTS, UPDATES and DELETES, so the number of indexes should not be too much. Try to use maximum 4-5 indexes on one table, not more. If you have read-on... 2007-10-25, 5344👍, 0💬

What is LOCK escalation
What is LOCK escalation? Lock escalation is the process of converting of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a memory structure too many locks would mean, more memory being occupied by locks. To prevent this from happening, SQL Serve... 2007-10-25, 5307👍, 0💬

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? You can use Having Clause with the GROUP BY function in a query and WHERE Clause is applied to each row before they are part of the GROUP BY function in a query. 2007-10-25, 5284👍, 0💬

What are the different types of joins? What is the difference between them
What are the different types of joins? What is the difference between them ? INNER JOIN Inner join shows matches only when they exist in both tables.Example, in the below SQL there are two tables Customers and Orders and the inner join in made on Customers Customerid and Orders Customerid.So this SQ... 2007-10-25, 5284👍, 0💬

What are levels in dimensions
What are levels in dimensions ? Dimensions are arranged in hierarchical levels, with unique positions within each level. For example, a time dimension may have four levels, such as Year, Quarter, Month, and Day. Or the dimension might have only three levels, for example, Year, Week, and Day. The val... 2007-10-25, 5240👍, 0💬

What is the difference between UNION and UNION ALL SQL syntax
What is the difference between UNION and UNION ALL SQL syntax ? UNION SQL syntax is used to select information from two tables. But it selects only distinct records from both the table, while UNION ALL selects all records from both the tables. Note : Selected records should have same datatype or els... 2007-10-25, 5226👍, 0💬

What are advantages of SQL 2000 over SQl 7.0
What are advantages of SQL 2000 over SQl 7.0 ? User-Defined Functions: User-Defined Functions (UDFs) -- one or more Transact-SQL statements can be used to encapsulate code for reuse. Userdefined functions cannot make a permanent change to the data or modify database tables. UDF can change only local... 2007-10-25, 5207👍, 0💬

What are dimensions in OLAP
What are dimensions in OLAP ? Dimensions are the categories of data analysis. For example, in a revenue report by month by sales region, the two dimensions needed are time and sales region. Typical dimensions include product, time, and region. 2007-10-25, 5049👍, 0💬

What are the different ways of moving data between databases in SQL Server
What are the different ways of moving data between databases in SQL Server? There are lots of option available; you have to choose your option depending upon your requirements. Some of the options you have are: BACKUP/RESTORE, detaching and attaching databases, replication, DTS, BCP, logshipping, IN... 2007-10-25, 4962👍, 0💬

What are indexes? What is the difference between stered and nonclustered indexes
What are indexes? What is the difference between clustered and nonclustered indexes? Indexes in SQL Server are similar to the indexes in books. They help SQL Server retrieve the data quickly. There are clustered and nonclustered indexes. A clustered index is a special type of index that reorders the... 2007-10-25, 4757👍, 0💬

< 1 2   Sort: Date

.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