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
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. #SantaChat 9,192 posts
- 2. Venezuela 771K posts
- 3. Dan Bongino 19.7K posts
- 4. Jack Smith 100K posts
- 5. Big Christmas 15.5K posts
- 6. Talavera 32.2K posts
- 7. FBI in January 7,115 posts
- 8. Endrick 16K posts
- 9. Coinbase 34.9K posts
- 10. Ewers 13.5K posts
- 11. Jared Isaacman 4,297 posts
- 12. #SystemUpdate N/A
- 13. Weaver 7,964 posts
- 14. Oscars 31.8K posts
- 15. Cherki 33.4K posts
- 16. Old Dominion 1,021 posts
- 17. NextNRG Inc 1,529 posts
- 18. Kawhi 5,064 posts
- 19. Fani 36.6K posts
- 20. Bernie 18.3K posts
قد يعجبك
Something went wrong.
Something went wrong.