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 …
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, …
As I have been working on my SQL Server Health Reports for my presentation at SQL Saturday 114 in Vancouver on March 17th, I have changed the way that I do things several times. After attending a SSRS class “SSRS Beyond the …
I learned this from one of my co-workers. A quick tip for formatting SSRS reports. When you are in the SSRS report editor, and you want to move the currently selected object (or objects), you can move them with the …
Other SQL Server CTE Material, Posts, and Samples On This Site CTE Hierarchy compared to the alternative Recursive CTE’s Calculating Factorials with a Recursive CTE Fibonacci Sequence CTE – With An Insert Statement Generating a Tree Path with a CTE …
Before proceeding with the article, please take this quick password safety test. Password Safety Test – Score one point for every YES answer.: Do you write your passwords down? ( YES / NO ) Do you ever re-use a password …
As part of my CTE research for my SQL Saturday presentation in Redmond in 2 weeks I decided to take on some classic computer science algorithms with CTE’s. Here is what I cam up with. Any math geek can tell …
I had a great time presenting at SQL Saturday 108 in Redmond. Below is the presentation and sample code from the presentation. CTE_Redmond.zip The thing that I love about a presentation like this is the people who ask questions at …
After being approved as a speaker at SQL Saturday 114 – Vancouver BC, and SQL Saturday 108 – Redmond WA, I have decided to give it another shot at SQL Saturday 120 in Orange County California. I have submitted 2 …
Sessions Submitted for SQL Saturday #120 Orange County CA Read more »
I just checked the schedule and one of the sessions that I submitted for SQL Saturday 108 in Redmond WA on February 25th has been accepted. I will be presenting Unleashing Common Table Expressions in SQL Server. If you are going to …
Session Accepted For SQL Saturday 108 in Redmond Read more »