So here’s another SSMS Object Explorer tip for youThere was a question asked in one of the forums couple of days back.In SSMS object explorer you’ve the option to Edit and Select records from a table The question was whether…
SSIS Tips: Deduping Flat File Data without using Staging Table
Recently there was a SSIS challenge that was brought up by one of my fellow colleagues in his project. The project involves importing data in the form of flat files daily.Some cases the file is found to have duplicate data…
Issues in Altering Objects through SSMS Table Designer
Many people use the table designer component in SQL Management Studio for creating and altering objects in SQL Server. I’ve never used it and I’m more comfortable in using T-SQL queries for doing these activities. Anyways many of my colleagues…
Rowset Concatenation with Special Characters
Whenever we think about row set concatenation in SQL Server the first method that comes to our mind is by the use of FOR XML PATH. There are numerous blogs on the method explained in web.Couple of days back one…