Try our JOIN types course today! So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this …
After being inspired by reading about Brent Ozar’s Epic Life Quest, I created my own Epic Life Quest list, and for level 1 one of my goals was to run in a 5K race. I completed that goal today, I …
Epic Life Quest Level 1 – partially completed today. Read more »
A cursor is a tool in SQL Server that allows a user to traverse through the rows of a result set one row at a time. This can be useful for performing operations on each row of the result set …
On Thursday March 19th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I to prepare for the Microsoft 70-461 SQL Queries exam. This week we will be a three part session on functions. This …
Next Weekly Training: Functions (Logical Functions, Time Functions, and UDFs) Read more »
Here is the outline: Using Cursors Using String Functions Here is the link to the Google On Air Broadcast where you can watch for free. https://plus.google.com/events/ci8jms67qttuteegimrf4sj70sk After the presentation, I will update this page with a link to the YouTube …
Today’s Live Training: Using Cursors and TSQL String Functions Read more »
First lets take a look at two queries using CURSORS, the first one will use the FORWARD_ONLY type cursor, and the second will use the FAST_FORWARD type cursor. These two types sound very similar, but perform quite differently. Now for …
Simple Cursor Example : FORWARD_ONLY vs FAST FORWARD Read more »
This has been replaced with a new updated version of the poster. Click here to visit the new page. >>> Try our JOIN types course today! So many times I have been asked for help with a query, where the …
On Tuesday March 24th at Noon the Bellingham SQL Server Users Group will have its monthly lunch networking meeting at Buffalo Wild Wings at Bellis Fair Mall. This is open to everyone who is a member of the Bellingham SQL Server Users …
Bellingham SQL Server Users Group – Lunch Networking Read more »
In SQL Server the cursor is a tool that is used to iterate over a result set, or to loop through each row of a result set one row at a time. It may not be the best way to …
T-SQL: A Listing Databases Example Using a Cursor Read more »
Using the GO commend in TSQL to run a batch of code multiple times is something that I commonly do in demo’s and training’s. What amazes me is how many people after the training will tell me that they didn’t know …