SQL server Archives - Page 6 of 7

Date & Time Data Types in SQL Server 2008

April 17, 2010

SQL server, SQL server 2008

The four new data types for storing dates and times in SQL Server 2008 are Date Time DateTime2 DateTimeoffset This post discuss about new date time data types and new date time related functions introduced in SQL Server 2008. (more…)

T-SQL TIP in SQL Server 2008

April 11, 2010

Kalyan Bandarupalli

SQL server, SQL server 2008

No Comments

You love this if you write a lot of T-SQL code. This tip I can say as T-SQL language syntax enhancement. The following are the enhancements in T-SQL Now We can declare and initialize the variables with single statement. (more…)

MERGE Statement in SQL Server 2008

April 3, 2010

Kalyan Bandarupalli

MERGE Statement in SQL Server 2008, SQL server 2008

There has been significant T-SQL improvements in SQL Server 2008. This post explores the most notable changes in T-SQL introduced in SQL Server 2008. The MERGE Statement As name says, It combines Insert,Update, and Delete operations along with the Select…

Creating an Analysis Services Project in Visual Studio 2008

March 10, 2010

Kalyan Bandarupalli

SQL server 2008, SQL Server 2008 Analysis Services

No Comments

Microsoft SQL Server Analysis Services allows the developers to provide a unified access of data for analytical analysis and reporting. Developers can manage and aggregate the queries from multiple subject areas. This can be achieved by creating a cube in…

Table Expressions in SQL server

March 8, 2010

Kalyan Bandarupalli

Common Table Exressions in SQL server, SQL server, SQL server 2008

No Comments

Table Expressions are sub-queries where a table is expected. There are two types of table expressions. This post explains how to use the Table expressions and their advantages. Derived tables Common Table Expressions (more…)

SQL server Joins or Subqueries?

March 6, 2010

Kalyan Bandarupalli

SQL server, SQL server 2008

No Comments

Select statements that use join operator and join statements can be written in Subqueries and similarly Subqueries can be written in Joins. Writing the Select statements with Join operator can help database engine to find more efficient strategy for retrieving…

SQL Server Reports Integration with SharePoint 2007

March 5, 2010

Kalyan Bandarupalli

SharePoint Server IntegrationMode, SQL server, SQL server Reporting Services

No Comments

This post explains how to Deploy the SQL server Reports to Office SharePoint Server 2007. SQL Server Reporting Services can operate in two modes, either in Native Mode or Share Point Integration Mode. (more…)

Report Builder 2.0 in SQL Server 2008

February 23, 2010

Kalyan Bandarupalli

SQL server, SQL server 2008, SQL server Reporting Services

No Comments

Report builder 2.0 is a report authoring tool that we can use to design and publish reports. We can specify the data source, what data to display on report and which layout you prefer to see the report. When you…

SSIS Package Configuration in SQL server 2008

February 13, 2010

Kalyan Bandarupalli

SQL server 2008, SQL Server SSIS, SSIS

SSIS configuration wizard allows you to create configurations for packages. It also allows you to update the properties and objects of the package at run time. Package Configuration Benefits Configuration really helps the developers to smoothly move the packages from…

Runtime Settings with SSIS Package

January 19, 2010

Kalyan Bandarupalli

SQL Server 2005, SQL Server SSIS, SSIS, SSIS Package

Introduction Clients may require to integrate the SSIS packages in their environment(Production). SSIS package settings needs to be changed at run time and all settings needs to be pulled from the database using set of stored procedures. 1. Create a…