Set Up And Schedule a Server Side Trace
How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace
2013-12-31 (first published: 2010-12-02)
13,604 reads
Performance Tuning
Troubleshoot Database Concurrency in SQL Server with sp_locks
sp_locks is a useful tool which can help a DBA in detecting and troubleshooting blocking and concurrency scenarios. This article demonstrates a worked example of using sp_locks to troubleshoot a database concurrency issue.
2010-11-30
3,539 reads
Indexed Views
This article will show you the importance of Indexed Views and how they can help performance.
2013-05-10 (first published: 2010-11-16)
24,537 reads
A Check and Foreign Key Constraint Improves Query Performance
Check and foreign key constraint do not degrade performance but actually improve it.
2013-04-26 (first published: 2010-10-21)
26,765 reads
Create a Performance Baseline Repository
This article demostrates how to create a Baseline repository that holds summarized data of all SQL Executions executed on an instance of SQL Server.
2010-10-18
2,532 reads
2010-09-15
3,156 reads
Performance Issue with large number of Virtual Log Files in SQL Server Transaction Log
SQL Server transaction log files have an internal structure called the Virtual Log File or VLF. When the number of VLFs grow out of control due to autogrowth the log can become fragmented and cause delay. In this tip we look at how to see how many VLFs exist as well as how this can be reduced to a more reasonable number.
2010-09-13
3,345 reads
An Informal Look at Database Performance
A review on the basic steps to correct a poorly performing query
2010-09-08
12,505 reads
Early September Free Training from PASS VCs
Hope you got plenty of rest over your Labor Day holiday because the PASS Virtual Chapters have some great free training lined up for you.
2010-09-07
1,122 reads
Using Dynamic Management Objects to Monitor I/Os Against an Instance of SQL Server
To ensure that queries run as efficiently as possible, the database administrator needs to monitor performance to find inefficient queries. This article focuses on exploring how a DBA can monitor the I/Os against an instance of SQL Server, using Dynamic Management Objects, or more commonly know as Dynamic Management Views (DMVs) and Functions (DMFs).
2010-08-11
4,130 reads
Blogs
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...
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...
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