JOIN IN SQL FAQ
1) What types of JOINS exist?
Inner Joins
Outer Joins (LEFT JOIN, LEFT OUTER JOIN, RIGHT JOIN, RIGHT OUTER JOIN, FULL...
2011-10-19
1,453 reads
Blog Posts
Microsoft and HP’s Database Consolidation Appliance
Microsoft and HP have announced another appliance, called the Database Consolidation Appliance (see my blog about the other two appliances). ...
2011-10-19
1,774 reads
More Denali Execution Plan Warning Goodies
In my last blog, I showed how the execution plan in denali has been enhanced by 2 new warnings ,conversion...
2011-10-19
785 reads
Moving to House of Brick
Starting Halloween Monday I will be a Technical Consultant for House of Brick Technologies.
To everyone out there saying "Didn't you...
2011-10-19
526 reads
Next PASS Summit is Nov 6-9, 2012
After enjoying the entirely reasonable weather in Seattle in October this year we’ll return to our more traditional time frame...
2011-10-19
537 reads
No longer just an admin but a DB Astronaut : A poem.
Today we have a guest post from Phil Factor as Brad is on vacation.
‘ I used to fettle databases as...
2011-10-19
547 reads
October 2011 SQL Server 2012 Diagnostic Information Queries
Since Microsoft released the official name for “SQL Server Code Named Denali” last week at the PASS 2011 Summit, it...
2011-10-19
821 reads
Query Memory Spills
When you sometimes look at Execution Plans, you can see that the SELECT operator has
sometimes a so-called Memory Grant assigned....
2011-10-19
5,131 reads
RSS Tuning Whitepaper notes and clarifications
This morning this caught my eye on SQLServerCentral.com: Maximizing SQL Server Throughput with RSS Tuning(it came with a catchy SQLCAT...
2011-10-19
668 reads
SQL Server – Moving table with LOB data to different file group
Last week, i posted about moving tables to different file groups by recreating indexes. However, this method does not *work*...
2011-10-19
2,680 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers