All SQL Posts

The list contains all posts tagged under SQL and SSIS

What is @@IDENTITY ?

Get the consolidated size of all tables in a database.

Check for the existence of a string in all procs and functions within a database.

Using string function DIFFERENCE()

Change the system error messages with custom messages

An easier way to translate query stats and plan/SQL handle information

Calculating the value of proposed indexes and analysing the impact.

Some SQL Server best practices

How to decide between “Rebuild vs Re-organize” for an index on a table.

Difference between Datalength() and Len() functions in SQL server

Changing Identity Seed value of a SQL server table using DBCC

Get the latest identity value inserted into a table / Identity value inserted in the current scope .

Insert values into IDENTITY column of SQL server table / Disable IDENTITY Column in SQL server 2005

Get the owner of the database in SQL server

Executing dynamic queries with more than 4000 characters using variables

Connect to SQL Server 2008 from SSMS for 2005

Get the list of dependent objects for any given object using query.

“ALL” : the transact SQL statement

Get the last database backup time for any database.

Identify the columns on which the indexes needs to be created / missing indexes in a table.

Maximum Length of login/User name and password in SQL Server 2005

Restoring differential backup in SQL server

Save storage disk space by replacing “space” with “horizontal tabs”

Tracking the modifications of objects in a database

Copy all objects from one database to another in SSIS using “Transfer SQL Server Objects Task”

Adding Audit information to you dataset using SSIS.

Database Compatibility Errors : ” If it is intended as a parameter to a table-valued function,ensure that your database compatibility mode is set to 90.”

Insert “Space”,”new line”,”tab” characters into a field as value

ASCII character set table

Perform an action on all tables in a database using ’sp_msforeachtable’

Collation — Another update for Case Insensitive collations.

Changing the collation of a database

Logging using SQL provider in SSIS 2008 and SSIS 2005

resolving collation issues in sql server

Resolving Datetime datatype Issues during insert/select

Difference between IN and EXISTS operators in SQL

Excluding MS shipped objects in a database.

Case insensitive comparison in SSIS 2008 LookUp transformation

Converting multiple record into a single comma seperated value

Return a custom delimited result set

Executing SSIS Packages from command prompt / SSMS

 

  1. September 15, 2013 at 3:42 pm

    I’m curious to find out what blog system you have been utilizing? I’m having some small security problems with my latest website and I’d like to find something more risk-free. Do you have any recommendations?

  2. December 8, 2013 at 9:21 am

    We stumbled over here coming from a different web address and thought I might as well check things out. I like what I see so now i am following you. Look forward to looking into your web page repeatedly.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: