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
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,516 reads
Check and foreign key constraint do not degrade performance but actually improve it.
2013-04-26 (first published: 2010-10-21)
26,736 reads
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,150 reads
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
A review on the basic steps to correct a poorly performing query
2010-09-08
12,482 reads
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,108 reads
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
A webinar from the PASS Performance VC on Aug 3, 2010
2010-08-02
3,191 reads
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Spring Connections and Learning at...
Comments posted to this topic are about the item Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers