Articles having tag: TSQL

#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.

Question of the month February 2012 - Find out problamatic query

Without running these queries can you find out the query that would throw an error?

#0132 - SQL Server – SSMS – Tutorial – Part 07 - Database Administration and maintenance - Productivity enhancing features (L200)

The SQL Server Management studio contains many pop-up utilities and tools that help in improving the productivity of our day-to-day database administration and maintenance tasks. While most of these would be implemented using T-SQL code in production...