Title15 Aspects of SQL Server Indexes that You Might Not Know WhenApr 16th 2013 at 6:00pm Where NJ SQL Server Users Group Meeting SPS Commerce Inc. 6 Upper Pond Road Parsippany , NJ
Abstract You probably know that indexes make you queries faster. But do you know why? Knowing how the different index types work under the covers will help you make the right decisions when (re-)designing you indexing strategy. After attending this demo rich session you will be able to Explain the differences between SQL Servers 9 [more...]
One of the most often encountered concurrency problems in T-SQL code happens in the Insert or Use scenario in which a new row is inserted if it does not exist yet and afterwards the primary key of the existing or the new row is returned. One of the easiest and safest ways to get this right is provided by the MERGE statement.
Last weekend was Philly GiveCamp 3. I got to work on creating a Choropleth Map of Pennsylvania for the Coalition Against Hunger in Philadelphia. Get all the details about the weekend and the project here.