3D Printing Ear Savers
On April 5th, I started printing ear savers for healthcare workers. I started with a single Ender 3 Pro printer with a .4 nozzle. When I made a post...
2020-05-24
1 reads
Tim Radney - Database Professional
3D Printing Ear Savers
On April 5th, I started printing ear savers for healthcare workers. I started with a single Ender 3 Pro printer with a .4 nozzle. When I made a post...
2020-05-24
1 reads
Updated Default Settings for Azure SQL Managed Instance Databases
A common saying about Azure is that it is always changing. This is a very accurate statement, want proof, just take a look at Microsoft Build 2020. Microsoft is...
2020-06-10 (first published: 2020-05-23)
401 reads
Updated Default Settings for Azure SQL Managed Instance Databases
A common saying about Azure is that it is always changing. This is a very accurate statement, want proof, just take a look at Microsoft Build 2020. Microsoft is...
2020-05-23
9 reads
Updated Default Settings for Azure SQL Managed Instance Databases
A common saying about Azure is that it is always changing. This is a very accurate statement, want proof, just take a look at Microsoft Build 2020. Microsoft is...
2020-05-23
4 reads
Updated Default Settings for Azure SQL Managed Instance Databases
A common saying about Azure is that it is always changing. This is a very accurate statement, want proof, just take a look at Microsoft Build 2020. Microsoft is...
2020-05-23
2 reads
Updated Default Settings for Azure SQL Managed Instance Databases
A common saying about Azure is that it is always changing. This is a very accurate statement, want proof, just take a look at Microsoft Build 2020. Microsoft is...
2020-05-23
1 reads
T-SQL Tuesday #126 – Folding@Home and 3D Printing
This month’s T-SQL Tuesday is hosted by my friend Glenn Berry. Glenn invites us to write about what we have been doing as a response to COVID-19. Glenn shared...
2020-05-29 (first published: 2020-05-12)
303 reads
T-SQL Tuesday #126 – Folding@Home and 3D Printing
This month’s T-SQL Tuesday is hosted by my friend Glenn Berry. Glenn invites us to write about what we have been doing as a response to COVID-19. Glenn shared...
2020-05-12
1 reads
T-SQL Tuesday #126 – Folding@Home and 3D Printing
This month’s T-SQL Tuesday is hosted by my friend Glenn Berry. Glenn invites us to write about what we have been doing as a response to COVID-19. Glenn shared...
2020-05-12
7 reads
Blogs
How to Build Data Management for Unstructured Data
The post How to Build Data Management for Unstructured Data appeared first on Joyful...
Grinding Away: Brent Ozar
By Steve Jones
Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many...
Monday Monitor Tips: Am I Patched?
By Steve Jones
One of the things that I think is neat is that Redgate Monitor helps...
Forums
Peer review SQL Central articles
Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...
Getting ANY of the data
Comments posted to this topic are about the item Getting ANY of the data
Why Would You Do That?
Comments posted to this topic are about the item Why Would You Do That?
Question of the Day
Getting ANY of the data
I have this data in two tables:
-- Beer table BeerIDBeerNamebrewer 5Becks Interbrew 6Fat Tire New Belgium 7Mac n Jacks Mac & Jack's Brewery 8Alaskan AmberAlaskan Brewing 9Kirin Kirin Brewing -- Beercount table BeerName BottleCount Becks 5 Fat Tire 1 Mac n Jacks 2 Alaskan Amber 4 NULL 7 Corona 2 Tsing Tao 4 Kirin 12What is returned from this query?
SELECT * FROM dbo.BeerCount AS bc WHERE bc.BeerName=ANY (SELECT b2.BeerName FROM dbo.Beer AS b2);See possible answers