SQL Azure Databases - Active Secondary - How to connect? - Part 2
As a continuation of "SQL Azure Databases - Active Secondary" series started earlier, this post will cover how to connect to...
2017-05-27
637 reads
SQL and SQL Only
Find the number of rows for a value, without querying the table
Dear all,Being a DBA, developers approach me with questions like can you run this query for me in production?Select *
FROM
[dbo].[FactInternetSales]
WHERE UnitPrice = 32.6
Lets, say the table contains...
2017-05-11
57 reads
Find the number of rows for a value, without querying the table
Dear all,Being a DBA, developers approach me with questions like can you run this query for me in production?Select *
FROM
[dbo].[FactInternetSales]
WHERE UnitPrice = 32.6
Lets, say the table contains...
2017-05-11
12 reads
Find the number of rows for a value, without querying the table
Dear all,
Being a DBA, developers approach me with questions like can you run this query for me in production?
Select*FROM[dbo].[FactInternetSales]
WHERE UnitPrice...
2017-05-24 (first published: 2017-05-11)
2,458 reads
SQL Azure Databases - Active Secondary - How to configure? - Part 1
Dear all,I have taken the azure dive at last 🙂
In case if you are new to azure, azure is the Microsoft cloud platform service, offering lots of services for...
2017-05-07
73 reads
SQL Azure Databases - Active Secondary - How to configure? - Part 1
Dear all,I have taken the azure dive at last 🙂
In case if you are new to azure, azure is the Microsoft cloud platform service, offering lots of services for...
2017-05-07
12 reads
SQL Azure Databases - Active Secondary - How to configure? - Part 1
Dear all,
I have taken the azure dive at last 🙂
In case if you are new to azure, azure is the Microsoft...
2017-05-22 (first published: 2017-05-07)
1,265 reads
Data Channel Interview - 07 - Steve Knutson on Managing Sharepoint Databases
7th Interview of #DataChannel is out 🙂 Very happy to have Mr.Steve Knutson, office servers and SharePoint MVP, share his knowledge on "Managing SharePoint Databases" on #DataChannel. Steve, demystifies...
2017-05-05
19 reads
Data Channel Interview - 07 - Steve Knutson on Managing Sharepoint Databases
7th Interview of #DataChannel is out 🙂 Very happy to have Mr.Steve Knutson, office servers and SharePoint MVP, share his knowledge on "Managing SharePoint Databases" on #DataChannel. Steve, demystifies...
2017-05-05
18 reads
Data Channel Interview - 07 - Steve Knutson on Managing Sharepoint Databases
7th Interview of #DataChannel is out 🙂
Very happy to have Mr.Steve Knutson, office servers and SharePoint MVP, share his knowledge...
2017-05-04
425 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
nitazoxanide 500 mg Buy Online - Medzsupplier
Nitazoxanide 500 mg Buy Online is a search term used by people looking for...
Using CHOOSE()
Comments posted to this topic are about the item Using CHOOSE()
Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary)
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
Question of the Day
Using CHOOSE()
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers