Monday, July 28, 2014

Report SQL Server Percentage Backup Completion and Time Completion

When executing a backup from a t-sql command, it is difficult to know what percentage has completed and when the backup will be complete. This FAQ tells how to do it.

Wednesday, July 23, 2014

Cannot show the editor for this task.

I got this error in SSIS when I try to open Execute SQL Task.

 

image

Then I tried to open already configured Execute SQL Task in some other SSIS packages. Still the error exists. I was wondering this is an error in SQL Server 2014 so I installed SQL Server 2012 and tried but it was no difference.

So the work around is by clicking F4 and enter the configuration values in the Properties box.

image

Tuesday, July 22, 2014

Difference Between LEN and DATALENGTH

DATALENGTH - Returns the number of bytes used to represent any expression.

LEN - Returns the number of characters of the specified string expression, excluding trailing blanks

image

Output is 30, 3.

Important point to remember is is LEN function does not depend on the data type and it is storage mechanism. LEN function total depends on the number of string characters.

image

Output is 8 and 3.

So DATALENGTH is depends on the storage but not the LEN function.

Monday, April 21, 2014

APRIL 2014 MEET-UP

image

More at http://www.sqlserveruniverse.com/SSSLUG.aspx