Why contractors need recruitment agents?
Welcome to WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent...
2018-03-15
291 reads
Blog Posts
Dates and Times in SQL Server: TIME
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-14
766 reads
Every Single Execution Plan is an Estimated Plan
All the execution plans are estimated plans. All of them. There fundamentally isn’t any such thing as an “Actual” plan.
Where...
2018-03-14 (first published: 2018-03-05)
1,824 reads
How I became a Data Platform MVP
As I spent last week attending my first MVP Summit in Seattle I thought I’d write this post about how...
2018-03-14
398 reads
Importance of Memory Setting in SQL Server
Memory is one among the resources forming the performance triangle—CPU and storage being the other two. If one is hit,...
2018-03-14
648 reads
Management Studio Shortcut – Change Connection
Update: Now with Object Explorer shortcuts! One of the most common things I do within SSMS is to change connection for...
2018-03-14
507 reads
SQL Server Management Studio Dark theme
Enable dark-theme for SSMS Purpose Guide to enable dark-theme in SQL Server Management Studio(SSMS). Reading time +/- 10 minutes References www.sqlserver.info...
2018-03-14
451 reads
SQL Server Management Studio Dark theme
Enable dark-theme for SSMS Purpose Guide to enable dark-theme in SQL Server Management Studio(SSMS). Reading time +/- 10 minutes References www.sqlserver.info...
2018-03-14
152 reads
SSMS 17.4 Vulnerability Assessment
SSMS 17.5 is out as of February 2018, but the the Vulnerability Assessment (VA) was released in SSMS 7.4
It seems...
2018-03-14 (first published: 2018-03-05)
2,441 reads
The SQL Privacy Summit
This May 18th, Redgate is putting on a SQL Privacy Summit for people that are looking for solutions to help...
2018-03-14
1,250 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
Alamat BCA KCP Summitmas Telp/Wa:0821-8200-203
Hub Cs 08218200203 Summitmas I, Jl. Jend. Sudirman kav 52-53 No.61-62 Lt. Dasar, RT.5/RW.3,...
Alamat BCA KCP Iskandar Muda II Telp:0821-8200-233
Telp/Wa 62 8218200233 Jalan Sultan Iskandar Muda No.78 RT.003/05, RT.10/RW.2, Kby. Lama Sel., Kec....
Alamat BCA KCP Bona Indah Telp/Wa:0821-8200-233
Hub Cs 08218200233 Plaza Bona Indah Jl. Karang Tengah Raya Blk B/12, RT.1/RW.6, Lb....
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