Microsoft, SQL Server, SQL Server Sri Lanka User Group, SS SLUG

SS SLUG Kaleidoscope – May 2012 Action

After a month’s break SS SLUG came into action, but with a low attendance this time, probably because its the season of convocations and many of the regular attendees were missing or lack of communication about the meeting. Nevertheless, this month’s meeting was pretty concise and compact, likewise the post comes out short and early.

The meeting kicked off with two sessions that were lined up for the evening.

  • Windowing Functions in SQL Server by Dinesh Karunarathne
  • Breaking an SQL Myth in 300 Seconds – Table Variables with less data does not go to tempdb by Dinesh Asanka (MVP, SQL Server)

Dinesh K. explained that Window Function, is primarily a function that affects a particular set of rows and there are three types of Window Functions.

  1. Ranking Functions
  2. Aggregate Functions
  3. Analytic Functions

He did an in-depth explanation of each type along with a small demonstration. With regard to the third section, he went on to explain the new improvements in SQL Server 2012. A side comment was made that, this function thought it seems very useful, doesn’t come that handy with big data sets.

Next in line was Dinesh A., with a new segment, where he had to bust an SQL myth within 300 seconds. The myth for the evening was, “Table Variables with less data does not go to tempdb“. He proved a point with a demonstration on Temp Tables Vs Table Variables Vs CTE.

Overall view, this time meeting compared to the previous meetings was played at a lower key. So let’s see if June will raise the bar higher…