SQL Server General DBA
Why do I get an unordered resultset, although my table has a clustered index?
Although the presence of a clustered index often seems to produce an ordered resultset, there is no guarantee that this will work in all cases. If you execute a SELECT statement without an explicit ORDER BY, SQL Server will try to return the information in the fastest possible way. This might be or might be [...]
Import Data Using SSIS from an Excel Workbook which has Dynamic Sheets Using SSIS
Importing data from Excel is a simple task if you are using SSIS. You can accomplish this by simply drag and dropping few controls and you are done. But what if your excel workbook has dynamic sheets, which means you will not know the sheet name. Excel Sheet Let us assume we need to import [...]