Query Store

The Basics - Level 1 of the Stairway to Query Store

  • Stairway Step

Introduction Instead of going straight into the topic of the Query Store, I would like to start this Stairway Series by mentioning a few performance tuning scenarios that are very common to production DBAs. I think most of us have been in one of these situations at some time: An application experiencing slowness after a […]

4.8 (5)

You rated this post out of 5. Change rating

2020-10-07 (first published: )

6,319 reads

Blogs

SQLpassion Live Training about running SQL Server in Microsoft Azure

By

From April 24 – 25, 2024 I will run a brand-new SQLpassion Live Training...

The Redgate Summit in Atlanta

By

Navigating the Database Landscape is the headline of our Redgate Summit in Atlanta on...

Friday Flyway Tips–Quick Command Line Access

By

One of the things I had to do recently in a demo was access...

Read the latest Blogs

Forums

row changes per hour by TagID

By Bruin

I have a large table being written too every second with equipment (PLC) information....

row changes per hour by TagID

By Bruin

I have a large table being written too every second with equipment (PLC) information....

Indexing strategy very long text strings

By aaron.reese

Hey guys,  Just looking to see if anyone has any bright ideas how to...

Visit the forum

Question of the Day

Logical Operators

I have this table and data:

CREATE TABLE ProdList
(ProductID INT NOT NULL
, ProductName VARCHAR(100)
, ProductCategory VARCHAR(40)
, ProductSize VARCHAR(4)
, ProductColor VARCHAR(20)
)
GO
INSERT dbo.ProdList
  (ProductID, ProductName, ProductCategory, ProductSize, ProductColor)
VALUES
  (1, 'Dirt Bike', 'Bike', '26', 'Blue'),
  (2, 'Mtn Bike', 'Bike', '26', 'Red'),
  (3, 'Dirt Bike', 'Bike', '24', 'Blue'),
  (4, 'Downhill', 'Ski', '180', 'White'),
  (5, 'Telemark', 'Ski', '175', 'Blue'),
  (6, 'Snowboard', 'Ski', '182', 'Various'),
  (7, 'Goggles', 'Ski', 'L', 'Clear')
How many rows are returned from this code:
SELECT productid, pl.ProductName
 FROM dbo.ProdList AS pl
 WHERE pl.ProductCategory = 'Bike'
 OR pl.ProductCategory = 'Ski'
 AND pl.ProductColor = 'Red'

See possible answers