June 1, 2016 at 11:17 am
Grant Fritchey (6/1/2016)
jasona.work (6/1/2016)
You know what's annoying?When you're reading something, think of something (maybe related, maybe not) that you want to look up, and in the time it took to open a new browser tab you've already forgotten what you wanted to look up...
Squirrel!
red or grey? If the former, don't shoot it; if the latter, do.
Tom
June 1, 2016 at 12:22 pm
Lynn Pettis (6/1/2016)
Just looking at the diagrams here does anyone else think a few of them may be wrong? It could just be me, but I need to do some testing to put my mind at ease.
Okay, I'm good. Just had to use a bit more brain power. Shouldn't try thinking hard right after eating lunch, that is actually nap time.
June 1, 2016 at 12:30 pm
TomThomson (6/1/2016)
Grant Fritchey (6/1/2016)
jasona.work (6/1/2016)
You know what's annoying?When you're reading something, think of something (maybe related, maybe not) that you want to look up, and in the time it took to open a new browser tab you've already forgotten what you wanted to look up...
Squirrel!
red or grey? If the former, don't shoot it; if the latter, do.
The diagrams are correct, but somewhat misleading to me.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 1, 2016 at 12:35 pm
Michael L John (6/1/2016)
TomThomson (6/1/2016)
Grant Fritchey (6/1/2016)
jasona.work (6/1/2016)
You know what's annoying?When you're reading something, think of something (maybe related, maybe not) that you want to look up, and in the time it took to open a new browser tab you've already forgotten what you wanted to look up...
Squirrel!
red or grey? If the former, don't shoot it; if the latter, do.
The diagrams are correct, but somewhat misleading to me.
They look right to me. I've seen them somewhere before. It might have been Aaron Cutshall's presentation on set theory, but but I can't be certain. Of course, I don't particularly like 2 of them because an EXCEPT operator, where possible, is usually more efficient. Most times, I still test both ways, but the set operators usually win.
June 1, 2016 at 12:43 pm
Lynn Pettis (6/1/2016)
Just looking at the diagrams here does anyone else think a few of them may be wrong? It could just be me, but I need to do some testing to put my mind at ease.
The diagrams are correct, but I do not like the use of outer join + IS NULL to replace what should be a simple NOT EXISTS plus correlated subquery.
The lower right one looks odd, I cannot imagine ever needing that in a real situation.
June 1, 2016 at 12:51 pm
Ed Wagner (6/1/2016)
Michael L John (6/1/2016)
TomThomson (6/1/2016)
Grant Fritchey (6/1/2016)
jasona.work (6/1/2016)
You know what's annoying?When you're reading something, think of something (maybe related, maybe not) that you want to look up, and in the time it took to open a new browser tab you've already forgotten what you wanted to look up...
Squirrel!
red or grey? If the former, don't shoot it; if the latter, do.
The diagrams are correct, but somewhat misleading to me.
They look right to me. I've seen them somewhere before. It might have been Aaron Cutshall's presentation on set theory, but but I can't be certain. Of course, I don't particularly like 2 of them because an EXCEPT operator, where possible, is usually more efficient. Most times, I still test both ways, but the set operators usually win.
They came from here. http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 1, 2016 at 12:53 pm
Thanks all. I was able to figure it all out, brain was disengaged after lunch so a couple of them just did not look right to me at the time.
June 1, 2016 at 1:12 pm
Sean Lange (6/1/2016)
Ed Wagner (6/1/2016)
Michael L John (6/1/2016)
TomThomson (6/1/2016)
Grant Fritchey (6/1/2016)
jasona.work (6/1/2016)
You know what's annoying?When you're reading something, think of something (maybe related, maybe not) that you want to look up, and in the time it took to open a new browser tab you've already forgotten what you wanted to look up...
Squirrel!
red or grey? If the former, don't shoot it; if the latter, do.
The diagrams are correct, but somewhat misleading to me.
They look right to me. I've seen them somewhere before. It might have been Aaron Cutshall's presentation on set theory, but but I can't be certain. Of course, I don't particularly like 2 of them because an EXCEPT operator, where possible, is usually more efficient. Most times, I still test both ways, but the set operators usually win.
They came from here. http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
Thanks, Sean. I know I've seen them before, but that wasn't the source. Oh well, I'm not going to figure it out and it isn't worth any more time. I think they're a good visual representation of the different join types, but I won't say they're efficient SQL.
June 1, 2016 at 1:27 pm
Ed Wagner (6/1/2016)
Sean Lange (6/1/2016)
Ed Wagner (6/1/2016)
Michael L John (6/1/2016)
TomThomson (6/1/2016)
Grant Fritchey (6/1/2016)
jasona.work (6/1/2016)
You know what's annoying?When you're reading something, think of something (maybe related, maybe not) that you want to look up, and in the time it took to open a new browser tab you've already forgotten what you wanted to look up...
Squirrel!
red or grey? If the former, don't shoot it; if the latter, do.
The diagrams are correct, but somewhat misleading to me.
They look right to me. I've seen them somewhere before. It might have been Aaron Cutshall's presentation on set theory, but but I can't be certain. Of course, I don't particularly like 2 of them because an EXCEPT operator, where possible, is usually more efficient. Most times, I still test both ways, but the set operators usually win.
They came from here. http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
Thanks, Sean. I know I've seen them before, but that wasn't the source. Oh well, I'm not going to figure it out and it isn't worth any more time. I think they're a good visual representation of the different join types, but I won't say they're efficient SQL.
Here is another link I have bookmarked on the topic. Same concept but the graphics are different. http://blog.codinghorror.com/a-visual-explanation-of-sql-joins/[/url]
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 1, 2016 at 1:27 pm
Grant Fritchey (6/1/2016)
yb751 (6/1/2016)
Steve Jones - SSC Editor (6/1/2016)
yb751 (6/1/2016)
Christmas in June!!!The purchase of some Red Gate tools finally got approved by my boss. 😀
Feels like I've been begging forever. I'm not trying to promote those tools over any other ones mind you. However, I will say that the tools I did demo were very intuitive and I was able to put them to good use right away.
In retrospect, not having some of these types of tools at first probably helped me in the long run though. Had to learn to do some things the old fashioned way. lol
Yeah. Good to hear, and let us know what things you want improved. There is some movement and refocus to update and improve the tools here and there, outside of the big work on Compare and Monitor.
I'm guessing you probably can't mention anything about the 'big work' on Monitor but I will mention the same thing I told the sales rep. I do wish there was a little more focus on SQL Azure (PaaS). I realize that there are no exposed perfmon metrics/WMI on that platform but you already query DMV's on local instances so why not on Azure? That would be my only gripe but overall I'm pretty happy thus far. SQL Compare has been an absolute joy!
I'm interested. What would you want to see for Azure monitoring? DTU certainly, but you can get that from the portal. What else?
It's true the portal does offer a variety of charts to choose from for monitoring, but it would be nice to consolidate all that information in one location. That being said the usual suspects would be great.
-Query Performance
-Wait Stats
-DB Sizes
-Connections
Also I do believe Azure v12 includes some new DMV's to choose from.
June 1, 2016 at 2:05 pm
So here's an interesting thought...
How do "security researchers" manage to find vulnerabilities in a product?
This came to me while I was reading an article on a researcher who during an internal threat assessment at his employer, reportedly found ~50 vulnerabilities in Oracle's eBusiness Suite (11.5-12.2) including a couple SQL injection vulnerabilities.
I mean, short of actively *trying* to exploit the program in some way, how do they manage it? I can't see testing for a buffer overflow or the like by keying in monstrous values into each and every field of an application one at a time, until you find something...
They almost certainly don't have the source code to prowl through looking for potential vectors that they could then test against...
Any thoughts?
June 1, 2016 at 3:17 pm
yb751 (6/1/2016)
Grant Fritchey (6/1/2016)
yb751 (6/1/2016)
Steve Jones - SSC Editor (6/1/2016)
yb751 (6/1/2016)
Christmas in June!!!The purchase of some Red Gate tools finally got approved by my boss. 😀
Feels like I've been begging forever. I'm not trying to promote those tools over any other ones mind you. However, I will say that the tools I did demo were very intuitive and I was able to put them to good use right away.
In retrospect, not having some of these types of tools at first probably helped me in the long run though. Had to learn to do some things the old fashioned way. lol
Yeah. Good to hear, and let us know what things you want improved. There is some movement and refocus to update and improve the tools here and there, outside of the big work on Compare and Monitor.
I'm guessing you probably can't mention anything about the 'big work' on Monitor but I will mention the same thing I told the sales rep. I do wish there was a little more focus on SQL Azure (PaaS). I realize that there are no exposed perfmon metrics/WMI on that platform but you already query DMV's on local instances so why not on Azure? That would be my only gripe but overall I'm pretty happy thus far. SQL Compare has been an absolute joy!
I'm interested. What would you want to see for Azure monitoring? DTU certainly, but you can get that from the portal. What else?
It's true the portal does offer a variety of charts to choose from for monitoring, but it would be nice to consolidate all that information in one location. That being said the usual suspects would be great.
-Query Performance
-Wait Stats
-DB Sizes
-Connections
Also I do believe Azure v12 includes some new DMV's to choose from.
OK. Fair enough. Pretty much the stuff I expect. There are new DMVs too. sys.dm_db_wait_stats is my favorite, waits for a database.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
June 1, 2016 at 5:41 pm
Phil Parkin (6/1/2016)
2016 RTM is available on MSDN ...
Downloaded and desktop upgraded just fine. This desktop has now gone from CTP3 -> RC0 -> Rc1 -> RC2 -> Rc3 -> RTM
Never seen things go smoothly.
One note, there's potentially a c++ update needed, so be sure to read release notes.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 1, 2016 at 7:22 pm
Steve Jones - SSC Editor (6/1/2016)
Phil Parkin (6/1/2016)
2016 RTM is available on MSDN ...Downloaded and desktop upgraded just fine. This desktop has now gone from CTP3 -> RC0 -> Rc1 -> RC2 -> Rc3 -> RTM
Never seen things go smoothly.
One note, there's potentially a c++ update needed, so be sure to read release notes.
I did the same thing. Everything went smooth. BUT, SSMS still shows release candidate. I'm doing a clean install now.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 15 posts - 54,391 through 54,405 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply