Update: Instead of reading this blog post, I suggest you read the article, “The Secret History of Women in Computing: Computer programming once had much better gender balance than...
2018-03-07
21 reads
Hello all-
More than a year's work went into the newest Inside Out book by Microsoft Press, I was happy to...
2018-03-07
722 reads
Here’s a good starter article on SQL Server logins, users, and SIDs: SQL Server Logins, Users and Security Identifiers (SIDs) Some...
2018-03-07
473 reads
Many of the widely advertised and talked about features of SQL Server or other software products focus exclusively on the...
2018-03-07
375 reads
Here’s a quick one for you. If you happen to be managing SQL Servers with a large number of databases...
2018-03-07
360 reads
One of the most important parts of continuing learning as a DBA (or probably an IT Professional) is reading blogs. ...
2018-03-07
377 reads
Someone recently told me that they don't need to worry about SQL injection because they are using an ORM.
Oh boy.
ORMs don't automatically prevent SQL injection
Watch this week's video on YouTube
Object-relational...
2018-03-06
17 reads
Today is the day that Azure SQL Database Managed Instance is available for the world to explore. Private preview means...
2018-03-06
303 reads
Azure SQL DB is a robust data platform that’s cloud native and can be managed from SQL Server Management Studio...
2018-03-06
434 reads
This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing...
2018-03-06
295 reads
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
When I run my query from DW, which uses a linked server, it times...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item The Disabled Index
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers