SSAS Dynamic KPI from a table
KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is above or...
2014-01-09 (first published: 2014-01-06)
2,608 reads
Answer - Objective Question (Which table is called Heap table in SQL Server)
Question:-
Which table is called Heap table in SQL Server.
1) Table without any indexes
2) Table without any clustered index (Correct...
2014-01-06
639 reads
Quick tip: Could not load package “xxx” because of error 0xC0014062
I struck this error in one of my SSIS packages, I found lots of tips and suggestions online for the...
2014-01-08 (first published: 2014-01-06)
2,006 reads
Day 12 – High CPU and Bloat in Distribution
This is the final installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2014-01-06
22 reads
Day 12 – High CPU and Bloat in Distribution
This is the final installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2014-01-06
637 reads
Posts I've Found Interesting:
This is a question I had until I came across a great script by The Scripting Guys. The script below...
2014-01-06
382 reads
MDX Root Function
This week I discovered an incredibly useful MDX function, the function is called Root. Full documentation can be found here. In the past, I have encountered scenarios where I...
2014-01-05
21 reads
MDX Root Function
This week I discovered an incredibly useful MDX function, the function is called Root. Full documentation can be found here. In the past, I have encountered scenarios where I...
2014-01-05
55 reads
MDX Root Function
This week I discovered an incredibly useful MDX function, the function is called Root. Full documentation can be found here....
2014-01-08 (first published: 2014-01-05)
2,183 reads
Day 11 – Purging syspolicy
This is the eleventh installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2014-01-04
52 reads
Blogs
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...
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...
Forums
Nomor Resmi Akun WhatsApp Bank BCA (0818751777)
WhatsApp resmi Halo BCA tersedia di nomor 0818751777. Layanan ini dapat digunakan untuk mendapatkan...
Layanan Halo BCA 24 Jam - Nomor Resmi 0818751777
Layanan Halo BCA dapat dihubungi melalui nomor resmi 0818751777. Layanan ini mencakup bantuan terkait...
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
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