Wednesday June 21st 2017

Categories

Insider

Archives

‘Sql Server 2008’ Archives

Tracking data changes in SQL Server 2008 and up

Tracking data changes in SQL Server 2008 and up

Commonly asked question in interview question. Please note that beginning from SQL server 2008 Microsoft introduced change tracking and change data capture (CDC) to help answer questions about data that changes in a database. Comparing Change Tracking to CDC SQL Server 2008 introduces two tracking features that enable applications to determine [...]

Examples Use string concatenation

Examples Use string concatenation

Recently I was trying to import datafeeds into the wordpress blog. images on the post and links needs some html tags. I used SQL language string concatenation operator to fill up the missing tags as follows; select  , '<img src="' + '' +IMAGEURL + '"' + ' Detail: ' + + ', '+ 'Price in USD:'+ ', '+ cast(PRICE as CHAR)+ ', '+ '<a href="' + [...]

Modifying table using SQL Server Management Studio in SQL Server 2008

Modifying table using SQL Server Management Studio in SQL Server 2008

Modifying table using SQL Server Management Studio 2008. In the Tools - Options menu, select the Designers node, and under Table options, uncheck "Prevent saving changes that require the table to be re-created".

Using Common Table Expressions

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)

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)

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

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

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

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

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 [...]

 Page 1 of 3  1  2  3 »