Monthly Archives: July 2016

The Expert

In one of the discussions this week, I mentioned to the group a video I saw a few years ago that is quite humorous and has some element that will speak to almost anyone who has ever worked on any...
Continue Reading →

More SQL Learning – Performance, Tuning, and Troubleshooting

I recently came across a new blog by Ramesh Meyyappan on “Seek or Scan – Cost Based Optimizer in SQL Server“.  In the youtube video (17 minutes) he covers the topic with some good examples and explanations, assuming you have...
Continue Reading →

Loading Data into SQL Server From Excel

Oft times trying to use the SQL SSIS Import wizard to load data into SQL server from excel you run into data type conversion errors and have to go through many machinations to alter the offending column data types and...
Continue Reading →

Changing the batch separator in SSMS

I can see the confused looks. “Joel what are you talking about?” We’re talking about Batches By default, in SQL Server Management Studio (SSMS), your query is submitted and executed in a batch. The batch separates the work you want...
Continue Reading →