In SQL Server 2022, a new feature called Intelligent Query Processing (IQP) makes use of machine learning to enhance query performance. Because of the automatic workload adjustment provided by...
2023-03-20 (first published: 2023-03-09)
508 reads
SQL Server 2022 and its enhancement … Continue reading SQL Server 2022: The Future of Data Management →
2023-02-27
314 reads
In this blogpost we will see the step by step installation and few details about SQL Server 2019. For SQL Server 2019 Installation, We have following System Requirements SQL...
2022-04-20 (first published: 2022-04-06)
4,226 reads
Good day everyone , In last post
In Memory OLTP – 1
we saw the what is In Memory OLTP and what are the...
2016-12-09
498 reads
In-Memory OLTP (A.K.A. Hekaton) is a specialized, memory-optimized relational data management engine and native stored procedure compiler, integrated into SQL...
2016-12-06
625 reads
Page splits can slow down your queries and increase the amount of I/O needed to retrieve your data.
So, how do...
2015-11-13
2,028 reads
Hi all
i have posted quite a few blogs till now, all of them were individual post except a short series...
2015-11-06
358 reads
Blocked processes are often a big problem for DBAs, because they’re difficult to monitor. We receive desperate calls saying “Everything...
2015-11-06 (first published: 2015-10-30)
7,002 reads
Check constraints are useful for more than just verifying the data that goes into your tables. The query optimizer can...
2015-10-09
1,244 reads
Again another interesting article from RED GATE …
SQL Server’s statistics provide the query optimizer with the information it needs to...
2015-09-14
851 reads
By Steve Jones
Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many...
By Steve Jones
One of the things that I think is neat is that Redgate Monitor helps...
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...
Comments posted to this topic are about the item Getting ANY of the data
Comments posted to this topic are about the item Why Would You Do That?
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