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!
Bạn có thể thích
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 Xu hướng
- 1. No Kings 960K posts
- 2. Carnell Tate 3,662 posts
- 3. Vandy 11.4K posts
- 4. Brian Kelly 5,703 posts
- 5. Vanderbilt 9,186 posts
- 6. Diego Pavia 3,664 posts
- 7. Beamer 2,900 posts
- 8. Clark Lea 1,010 posts
- 9. South Carolina 11.1K posts
- 10. Tony Vitello 2,700 posts
- 11. Dork Cult Protest Day 43.2K posts
- 12. Cash Jones N/A
- 13. Shula 2,544 posts
- 14. Nuss 3,346 posts
- 15. #GoBlue 2,602 posts
- 16. Joe Sloan 1,081 posts
- 17. Julian Sayin 1,008 posts
- 18. Sellers 10.1K posts
- 19. Marchand 2,479 posts
- 20. #UFCVancouver 4,872 posts
Bạn có thể thích
Something went wrong.
Something went wrong.