What a great day at Code Camp today. Click here to download the slides and sample code from the presentations. The first presentation that I attended was Accelerating your Development Workflow presentation by Ian Davis. What a great presentation, it touched on the lean and agile development processes, it was very well done. The next one was a PowerShell presentation that …
I am headed to Code Camp in Redmond WA today. I ended up with 3 sessions that I will be presenting, and I am really looking forward to the day. I am looking forward to attending the Accelerating your Development Workflow presentation by Ian Davis. Here is what I am presenting… What’s New in TSQL 2012 This is the first time that …
SQL Saturday 166 in Olympia WA on November 10th was announced, and that one is close enough to drive to. I have submitted 2 sessions for this event. What’s New in TSQL 2012 By November, this with be the fourth or fifth time presenting this one. Its going to be a lot of fun working with the new features …
June 16th 2012 in Redmond. What’s New in TSQL 2012 This presentation was a lot of fun. Although, I wish I had about 30 minutes longer. Here is the zip file with all the TSQL and the slides from the presentation. Whats New in TSQL 2012_SteveStedman.zip Unleashing Common Table Expressions in SQL Server The CTE presentation went great. Lots of …
Here are the sessions that I will be presenting at Code Camp in two weeks.. What’s New in TSQL 2012 This is the first time that I will be presenting this one. Its going to be a lot of fun working with the new features in TSQL 2012. Unleashing Common Table Expressions in SQL Server This will be about the …
Today I started the day early with a great presentation for the SQL Lunch UK group on Common Table Expressions. For those who attended the presentation here is the Zip file with the Powerpoint and the SQL code from the demo. Feel free to download it and learn from it. CTE_SQL_LUNCH_UK_May_2012.zip Here are a few links to some of …
Its about time, MySQL has had a feature LIMIT which is similar to the usage of OFFSET and FETCH for years. Now in SQL Server 2012 Microsoft introduces OFFSET and FETCH. The OFFSET and FETCH functionality is used to achieve data paging server side in TSQL. Thing of a page like your typical search results where you are shown the …
SQL Server 2012 introduces 8 new analytic functions. This post will cover 2 of them LEAD and LAG, which can be used to reference a value in the row before or the row after the current row. If you have read my OVER clause articles you will recognize the REVENUE table. Just a table listing department revenue year over year …
In a previous article I covered the usage of ROWS PRECEDING and FOLLOWING in the over clause. For this example I am going to use the same database and tables that I created in the previous example to show ROWS UNBOUNDED both PRECEEDING and FOLLOWING. One of the new features available in TSQL in SQL Server 2012 is the ROWS UNBOUNDED …
Transact SQL OVER Clause – ROWS UNBOUNDED PRECEDING or FOLLOWING Read more »
Part of SQL Server running queries is that once a query is analyzed, parsed and compiled, that compiled plan is kept in memory so that it can be quickly re-used in the future. If you are using proper parameterized queries, most of your queries will get kept around and re-used saving lots of CPU and memory on SQL Server. If …