When Query Store rolled out, there were a lot of questions about controlling the size, and placement of it. To date, there’s still not a way to change where Query Store data ends up, but you can manage the size pretty well.
2019-03-30
SQL Server Transaction Log files store details about every modification made to a SQL Server Data File. This includes when you need to add a 2nd log file. The act of adding a 2nd log file changes data in the primary filegroup for the database.
2019-03-30
This morning, I received the following question from a user: Hello Madam, Could you please clarify SQLServer “Data Row” size:If I run the script below on SQL Server 2012, then Slot(row) Size is 710 bytesif I run the same script against SQL Server 2016...
2019-03-30
With support ending soon, Brent Ozar wonders what all the companies still running SQL Server 2008 are planning to do with those instances.
2019-03-30
In order for a database system to work, you often need to provide programmable server objects. I’ve written very few databases that didn’t include agent jobs and triggers, or that didn’t require XEvents for diagnostics.
2019-03-30
As I have seen the benefit for having a post on Oracle database vs. SQL Server architecture, let’s move onto the next frontier- High Availability…or what people think is high availability architecture in the two platforms.
2019-03-30
409 reads
2019-03-22
620 reads
2019-03-05
913 reads
Learn about how selecting a SQL Server index fill factor can impact storage and performance. Check out the included scripts to help give you better insight.
2019-02-25
3,023 reads
2018-12-28
704 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Using CHOOSE()
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
Comments posted to this topic are about the item The DBA is Dead! Long...
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