
Mark C
@MarkSQLDev
It's SQL AdventureWorks Time with Mark! Kind of like Sliders but in a SQL Server environment! Open to new adventures and new opportunities!
내가 좋아할 만한 콘텐츠
Hi Mark, I believe MVA retired this seminar. You can find coverage of APPLY in the following two part session. Part 1: m.youtube.com/watch?v=-m426W…, Part 2: m.youtube.com/watch?v=goyWzA….
youtube.com
YouTube
SQLug.se - Itzik Ben-Gan - Creative Uses of the APPLY Operator,...
On my journey to getting an #msca in #Tsql, I came across this really interesting application of intersect in a query. #SQLServer

Read the SQLServerCentral blogs: Execute SSIS Package from PowerShell rd.gt/2vIavy7
Since owning a @AmazonKindle , I started a sampler reading of, "The Data Warehouse Toolkit" by R. Kimball & M. Ross. 100% at the end of the Table of Contents? Huh...

Subsets within the Tables: Proceeding from the previous article, now let's say there's a subset contained in ... bit.ly/2eN9de4
Multiple Tables, Same Key, Dependent on Another Column: Let's say you're working with a table that has simila... bit.ly/2dEhL6D
Table Finder Tool: Here's a tool I developed to help me in my search through a data warehouse for columns and... bit.ly/2dmWNs0
Optimizing Case Statements: In my previous position, I was blown away by the creative uses of case statement ... bit.ly/2cNHHMo
SQL Technical Interview Questions #5: Revisited: Looking back at this previous post, having done a lot more w... bit.ly/2d1dY0I
SQL Technical Interview Questions #5: Two Million Served: I recently completed another technical interview, o... bit.ly/23XkNEx
SQL Technical Interview Tip: When taking a technical interview coding test, it's important to look over the te... bit.ly/23IMIrs
"Inheriting" Temporary Tables: There is an interesting behavior that really rocked me when I first saw it out ... bit.ly/1oS54GN
SQL Tech Interview Overall (Questions 2-4): Now that we've answered all the questions, let's take an overall l... bit.ly/23byfnO
SQL Technical Interview Questions #4: Everyone in Categories: I recently completed another technical intervie... bit.ly/1Rv5CNa
SQL Technical Interview Questions #3: Everyone, with or without that.: I recently completed another technical ... bit.ly/22IOdpa
SQL Technical Interview Questions #2: Details, Details, Details: Going forward, I will be utilizing SQL Fiddle... bit.ly/1UafoYz
A less than ideal use of Variables in SQL: This is actually spurred from my previous post, so here's an exampl... bit.ly/1SZ3hwQ
Got a taste of how sql server handles xml docs. As someone who used java to load xml docs data into sql server, I wish I learned sooner!
This might show my greenness, but fighting over resources is kind of stupid. Why is it even a thing?!
Crap, looks like it'll be another month for me to go to sql pass. Couldn't get back in the city on time for it
United States 트렌드
- 1. Good Saturday 23.9K posts
- 2. Chalobah 3,332 posts
- 3. No Kings 410K posts
- 4. Garnacho 8,039 posts
- 5. #SaturdayVibes 3,378 posts
- 6. Emiru 11.4K posts
- 7. #saturdaymorning 1,659 posts
- 8. Ohtani 238K posts
- 9. Massie 37.1K posts
- 10. Lavia 5,560 posts
- 11. Forest 76.6K posts
- 12. #dominATE_celebrATE 83.8K posts
- 13. Philippians 2,358 posts
- 14. Babe Ruth 3,931 posts
- 15. World Series 65.3K posts
- 16. George Santos 96.2K posts
- 17. #HeartofTaehyung 53K posts
- 18. Sam Harris 1,431 posts
- 19. IT'S GAMEDAY 2,032 posts
- 20. TwitchCon 27.5K posts
내가 좋아할 만한 콘텐츠
Something went wrong.
Something went wrong.