Distributed AG
going though Allan Hirt’s 24 SQLPASS recording, he has explained the new feature of SQL Server Availability group you can get...
2016-09-19
385 reads
Vinay Thakur
Future DBA part 2
I do not say you should be expert in other technologies but you should be aware of what it is...
2016-09-15
390 reads
Future DBA Part 1
As I stated in my earlier blog on future DBA, we should learn many things as we can to be...
2016-09-14
467 reads
World is changing so DBA should
I was going through SQLPASS recording and on first time I could see a session as “MongoDB for the SQL...
2016-09-13
384 reads
24 Hours of SQLPASS
Like every years before PASS summit, this years also SQLpass has 24 hrs sessions… it has great sessions every time,...
2016-09-12
378 reads
SQL 2016-Always Encrypted
As you know this has been introduced in sql server 2016, I am not going in details on it but...
2016-05-07
467 reads
SQL Server 2016 …whats new…WOW!!!
Hey there…. I wrote on SQL Server 2016 in my earlier blog Lets See and Whats new, during that time I knew that SQL...
2016-04-01
682 reads
2016-01-11
559 reads
SQL Server 2016 – whats new…lets see
Hey friends. I am here again with what’s new blog … Things are changing quite frequently and requirement is also changing....
2016-01-11
436 reads
Installation SQL Server 2016
Here is some of the installation processes(https://thakurvinay.wordpress.com/category/installation/) Below is very nice step-by -step installation process for SQL Server 2016: http://www.databasejournal.com/features/mssql/installing-sql-server-2016.html
2015-12-15
977 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Forums
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
The Disabled Index
Comments posted to this topic are about the item The Disabled Index
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Question of the Day
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