SiSense BI Evolved
Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

SSIS File Operations – Copy File, Move File, Rename File and Delete File

In the previous post we saw that how to Load data from Text files to SQL Server Tables and successfully created a package which loads data in to SQL Server table from a flat file. In this post today we will see SSIS File Operations – Copy File, Move File...
Posted: 08-31-2010 2:00 AM by Ashish Gilhotra | with no comments
Filed under: , , , ,

Temporary Tables and Table Variables An Overview

Some days back i was asked about Temp Tables and Table Variables the basic difference why one is better than another one and all, and i am not able to provide a satisfactory reason\answer at that time so this is the time when i studied about a lots about...
Posted: 07-31-2009 9:50 AM by Ashish Gilhotra | with 3 comment(s)
Filed under: , , , , ,

BackUp Status Script

This time its all about a script a backup script.Today early morning i asked to get BackUp details for some of DB’s we have, usually they ask me about the last BackUp taken so its easy for me to tell him. But this time he needs all the history of...
Posted: 07-22-2009 2:17 PM by Ashish Gilhotra | with no comments
Filed under: , , , ,

T-SQL Challenges

Hi All … You all must here about T-SQL Challenges , these challenges are ideal to learn Set Based Queries using TSql. The most beneficial part of these challenges is that, through these challenges , you get a chance to see better solution to solve...
Posted: 07-08-2009 4:05 AM by Ashish Gilhotra | with no comments
Filed under: , ,

Sparse Columns – Introduction

So after a long i get a chance to work on SQL Server 2008 and understand it in better way. So today we look into a new storage feature in SQL Server 2008 as Sparse Column. Sparse column takes no physical usage for a column which may have “NULL”...
Posted: 06-11-2009 11:13 AM by Ashish Gilhotra | with no comments
Filed under: , ,

TechEd on Road – Ahmedabad June 20, 2009

Hi all … This time a great news for all the technology enthusiast and want to meet great peoples in technology and you missed TechEd India 2009 so you can attend now the same kind of event in Ahmedabad, India on June 20, 2009 Saturday(TechEd on Road)...
Posted: 06-11-2009 2:46 AM by Ashish Gilhotra | with no comments
Filed under: , , ,

Copyright © Beyondrelational.com