‘Sql Server 2008’ Archives
Using Common Table Expressions
A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query. A CTE can be used to: * Create a recursive query. For more information, see Recursive Queries Using Common [...]
OUTPUT Clause (Transact-SQL)
Returns information from, or expressions based on, each row affected by an INSERT, UPDATE, DELETE, or MERGE statement. These results can be returned to the processing application for use in such things as confirmation messages, archiving, and other such application requirements. The results can also be inserted into a table or table variable. [...]
FREETEXT (Transact-SQL)
Can computer really understand what you want rather than simply give you what you asked it for?This post is to show the functionality of the FREETEXT (Transact-SQL) in Sql Sever; The FreeText predicate attempts to do just that – understand the meaning of a phrase or sentence. It does this by breaking a phrase into individual words and then [...]
Hospital Uses Business Intelligence Solution to Save Time and Gain Insight from Data
This post is about a case study we read on the topic of Business intelligence and Healthcare. This highlight how critical is to improve and enhance business process management in the face of changing work and business situation. Essentially it has explains the use of Microsoft business intelligence tools and their impact on achieving [...]
Microsoft SQL Server 2008 Express with Advanced Services
Microsoft SQL Server 2008 Express with Advanced Services is a free, easy-to-use version of the SQL Server Express data platform that includes an advanced graphical management tool and powerful features for reporting and advanced text-based searches. This edition provides powerful and reliable data management tools and rich features, data [...]
Tutorial: Creating a Simple ETL Package
We recently did a hands on experience on using sql server 2008 Integration Services by creating a package. We followed the microsoft tutorial and found it a very good to get started with Integration Services 2008. We would like to share it with our reader, so lets enjoy; In this tutorial, you will learn how to use SSIS Designer to create [...]
Another defination of Star Schema
A Star schema is relational database schema used to hold measures and dimensions in a data mart. Measures are stored in a fact table, and dimension is stored in dimension tables". Star schema contains fact table which holds the measures and column for each dimension containing foreign keys for a member of that dimension. The primary key for [...]
Relational Database Management System
Short for relational database management system and pronounced as separate letters, a type of database management system (DBMS) that stores data in the form of related tables. Relational databases are powerful because they require few assumptions about how data is related or how it will be extracted from the database. As a result, the same [...]
How to build a data mart ?
Overview of this Post This post addresses very basic questions like - How to build a data mart? / How to design a Data mart?/ How to create a Data Mart. There is lot of information is available about the exact definition, however we attempted to connect the missing dots for beginners in this field. We did some hands-on work following [...]
What are Data Mart Metrics
Metrics is a direct numerical measure of business data in the light of one or more dimensions. For example total sale by week, in that case the sale will be a metric and week is dimension.
