Microsoft® SQL Server® 2008 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data integration, analysis, and reporting solutions.
Microsoft® SQL Server® 2008 provides a trusted, productive, and intelligent data platform that enables you to run your most demanding mission-critical applications, [...]
Tags: SQL Server 2008, SQL Server 2008 Features, SQL Tutorial
This article will completely guide you to clear the sql query cache in sql server. Consider you are running the same query one or more times in a row, the execution time may differ time to time. If your are only user on the database, then it is because of build in query cache.
Tags: CHECKPOINT, clear cache, DBCC, DROPCLEANBUFFERS, FREEPROCCACHE, Sql Server DBCC commands
In this tutorial we shall see how to implement Microsoft SQL Server 2005 Encryption Techniques. Microsoft SQL Server 2005 Encryption are a good way to encrypt sensitive and confidential fields such as passport number, credit card number, phone numbers, and other user information.
Many applications require security of important data in today’s fiercely completive business [...]
Tags: SQL Server 2005, SQL Server 2005 Encryption and Decryption, SQL Server Decryption, SQL Server Encryption
Following are the steps to be followed to create a SQL Server Analysis Services (SSAS) Project in Microsoft SQL Server 2005 Business Intelligence Development Studio. Please follow the step by step instructions given in the tutorial to create SQL Server Analysis Services (SSAS) Project.
Tags: Business Intelligence Development Studio, SQL Server 2005, SQL Server Analysis Services, SQL Server Business Intelligence, SQL Server Management Studio, Step by Step Tutorial
The <asp:Wizard> control is a container for a group of <asp:WizardStep> controls, where each WizardStep is a visible portion of a page to display. Like the MultiView control, the Wizard control reveals individual screens coded on a single page. Whereas the MultiView is especially designed for use on mobile devices with restricted screen sizes, the [...]
Tags: ASP.Net Tutorial, asp:Wizard, asp:WizardStep, Wizard Control, WizardStep
Following are the list PL/SQL Features introduced in Oracle11g
Automatic subprogram inlining
A continue statement
A cross-session PL/SQL function result cache
Dynamic SQL enhancements
Mixed, named, and positional notation SQL calls
A multiprocess connection pool
A PL/SQL Hierarchical Profiler
That the PL/SQL Native Compiler now generates native code
PL/Scope
Regular expression enhancements
A SIMPLE_INTEGER datatype
Direct [...]
Tags: continue statement, cross session PL/SQL, oracle 11g, PL/Scope, pl/sql features, PL/SQL Hierarchical Profiler, PL/SQL Native Compiler, plsql, Subprogram Inlining
The difference between RANK() and DENSE_RANK() is that RANK() leaves gaps in the ranking sequence when there are ties. Let us see this function through an example.
Tags: DENSE_RANK, NULLS FIRST, NULLS LAST, RANK, RANK and DENSE_RANK, SQL Tutorial
In subqueries, regardless of whether one row or multiple rows are returned, each of these rows contains only one column worth of data to compare to the main query level. The main query can be set up to handle multiple columns in each row returned, too.
For example
select deptno,ename,job,sal, from emp [...]
In this tutorial we can see how to convert rows into columns using Structured Query language SQL. We cover this tutorial from the basic steps i.e creating tables and inserting values into the table so that it can be useful for basic users as well
Tags: Converting Rows to Columns., CUBE, GROUP BY, oracle tutorial, ROLLUP, SQL, SQL TIPS, SQL Tutorial
Following are some of the items that we need to keep in mind while Reviewing Java Code. The following checklist holds a list of activities that needs to be carried out while Reviewing Java Code.
There are eleven different types issues that have been discussed here and the critical areas in which review should be done [...]
Tags: code review checklist, code review standard, java review checklist
