Unexpected View Performance
Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer.
SQL Server Performance Tuning Using Wait Statistics: A Beginner's Guide
This beginner's guide to Wait Stats by Jonathan Kehayias and Erin Stellato is a free PDF download brought to you by SQL Skills and Simple-Talk.
One Database to Rule Them All
Twitter is working on a new database that can handle unstructured as well as structured data well. Is this a competitor for SQL Server?
XML Schema validation in SQL Server
An introduction to the XML Schema Collection and XML validation.
Call for participants in deployment process research
The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers for participants.
Explaining the Calculations of Probability and Importance for Complex Association Rules in SSAS
The output from the Association Rules data mining model in SSAS 2012 can be difficult to understand, especially when the generated rules become more complex. In this tip we go through an example to provide a better understanding.
Stairway to SQL Server Agent - Level 9: Understanding Jobs and Security
Security is a confusing topic to many, especially when it comes to understanding what rights are needed to monitor and use SQL Server Agent. This article will examine the rights and roles used for SQL Server Agent, as well as the security context requirements for jobs.
SQL Server 2014 In-Memory OLTP Dynamic Management Views
Greg Larsen provides a quick primer of the new Dynamic Management Views (DMVs) to help you better understand and manage your In-Memory OLTP tables and your Instances that support In-Memory OLTP tables.
Doing What It Takes To Get The Job Done
It can be a point of pride in technology that we work ourselves to get the job done. Is that a good thing? Andy Warren has a few thoughts.
Blogs
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
Why sys.fn_dblog Is Undocumented And Why It's Still There
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
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