March 2011 S3OLV Meeting Recap
The Las Vegas SQL Server Users Group met on March 10, 2011. The meeting was both virtual and in-person. Good...
2011-03-15
711 reads
SQL RNNR
March 2011 S3OLV Meeting Recap
The Las Vegas SQL Server Users Group met on March 10, 2011. The meeting was both virtual and in-person. Good news – we had just about as many person...
2011-03-15
10 reads
DB Benchmarking
As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance. When benchmarking,...
2011-03-14
1,104 reads
DB Benchmarking
As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance. When benchmarking, it is preferable to get a baseline and then...
2011-03-14
10 reads
SQL Bitwise Operations
How many DB professionals have never had to deal with bitwise operations in SQL Server? Who has never had a...
2011-03-10
2,835 reads
SQL Bitwise Operations
How many DB professionals have never had to deal with bitwise operations in SQL Server? Who has never had a single value in the database represent more than one...
2011-03-10
28 reads
Database Maintenance
I often see a request for some scripts to help with database maintenance. Sometimes those questions come in the form...
2011-03-09
1,044 reads
Database Maintenance
I often see a request for some scripts to help with database maintenance. Sometimes those questions come in the form of recommendation requests for maintenance plans. As many already...
2011-03-09
8 reads
T-SQL Tuesday #016: Aggregates and Statistics
Data Size Collection and Analysis
By now you should be well acquainted with this phenomenon we call TSQL Tuesday. This party...
2011-03-08
681 reads
T-SQL Tuesday #016: Aggregates and Statistics
For my data analysis and trending, I wanted to find a simple distribution across quartiles.
Related Posts:
T-SQL Tuesday 109: Influence Somebody Invite December 4, 2018
T-SQL Tuesday Participation Over the...
2011-03-08
12 reads
Blogs
What Does It Mean to Make Data AI-Ready?
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
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...
Forums
Having some performance issues with linked server query
When I run my query from DW, which uses a linked server, it times...
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
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