(Michael J. Swart) I explain how SQL Server is aware that inner joins are commutative and so the order of tables in your queries doesn’t matter.

(VidhyaSagar) I was looking for a script to find out the indexed column details as part of our migration. I tried to use sp_helpindex however it requires a object name which means you can find details for only one table at a time. My requirement is to get details about all indexed columns across the

(Derek Colley) New stored procedures or types, INSERT, UPDATE and DELETE transactions are being executed against your SQL Server databases by developers or other stakeholders on an ad-hoc basis, changing data without rollback plans, controls or an adequate audit trail.

(Kevin Kline) The Microsoft SQL Server 2012 Best Practices Analyzer (BPA) is a powerful tool that reviews the configuration and settings of your SQL Server 2012 instances. In addition, the tool highlights settings that differ from best practice recommendations.

(Shehap El-Nagar) In earlier installments of this series we looked at T-SQL Performance optimizations along with different T-SQL practices, we can now turn our attention to the second part of this series which is index Tuning

(Balmukund Lakhani) I am sure that all of us have used SQL Server Management Studio countless times. It’s the common tool used by all DBA and developers. Most of the time we give server name, user name and password (if needed) and hit connect.

(VidhyaSagar) I was working in a migration project where we migrated SQL Server 2000 to SQL Server 2008 R2. Everything went fine except one SSIS package. It’s a simple package where we are importing data from a csv file. This csv file is created from Unix environment with TAB as column delimiter and

(Koen Verbeeck) Originally this blog post would have had the title “Disabling aggregations over a parent-child hierarchy”, but I thought it could create confusion with the Aggregation Design concept in Analysis Services (SSAS), which is something completely different.

(Arshad Ali) We often need to create similar SSIS packages which contain some common components such as connection managers, data flow components, log providers, event handlers, etc… So do we really need to create a package from scratch each time and add all these commonly used components in each

(Kenneth Fisher) This isn’t really one of those features of SSMS that I’ve used a great deal. At least didn’t until recently. For those that don’t know, if you right-click on the tab of a query window you will get, among other things, options for a new tab group.