Articles having tag: TSQL

OPENROWSET (T-SQL) – Sometimes You Have to Stop and Smell the Roses

Ever been in the situation where you're so fixated on debugging an error that you fail to see the solution which has been staring you in the face the whole time? Me too. The other day I was trying to import data from an Excel spreadsheet into a SQL Server...

LTRIM RTRIM doesn’t always work

By Israel Cris Valenzuela

LTRIM and RTRIM don't always remove all the whitespace characters in a field such as carriage return or linefeed

#0135 - SQL Server – SSMS – Tutorial – 10 - Troubleshooting (L200)

All systems are susceptible to failure. No software is perfect, and therefore it is natural that SSMS too will fail. Today, I have put together some of the most common failures that I have experienced with SSMS and their known workarounds. The reason...

LTRIM RTRIM doesn’t always work

By PIEBALDconsult

In SQL Server 2008, I do that with a CLR User Defined Function:namespace PIEBALD.Lib{ public static partial class LibSql { public static string Trim ( string Victim ) { return ( Victim.Trim() ) ; } }}Needs to be built into a...

#0134 - SQL Server – SSMS – Tutorial – 09 - Integrating with peripheral services & other SQL Server tools (L200)

As mentioned in Part 01 of this tutorial series, one of the key responsibilities of SSMS was to replace the erstwhile SQL Server Enterprise Manager \u2013 the interface that is used to manage & maintain the SQL Server instance configuration. In addition...

SSIS - Delete files older than retention period from folder with parameter using Script Task in SQL Server

After using some of the ways to delete the files from the particular folder like Delete file using Script Task and File System Task in SSIS. We have seen such methods and used logic to get the files from the loop container and process to delete them and...

Jeff Wharton's Blog - SQL Server Integration Services 2012 (RC0) Project Conversion Bugs

UPDATE \u2013 10th February 2012 Since writing this article I've discovered that the Int32 error discussed below occurs irrespective of whether the ServerPort value is greater than 32767 i.e. even a value of 21 (the default) causes the same error. I've...

#0133 - SQL Server – SSMS – Tutorial – 08 - How SSMS helps in reviewing and configuring your SQL Server Instance (L200)

One of the most important aspects of SQL Server administration and maintenance is the ability to review and changing the existing configuration of the server. In Part 01 of this tutorial series, I had mentioned that one of the key responsibilities of...

SSIS Tutorial - Getting started with SSIS - Part 4: Control Flow - Sudeep Raj

In Control Flow, we set up the flow of jobs in an ETL process, like fetching the files from ftp location to local and then make the file ready for ETL or at times, we clear the staging tables before the ETL process. All such tasks are done before ETL commences.