Optional Parameters Causing Index Scans
Optional parameters in a stored procedure often lead to scans in the execution plan, reading through the entire table, even...
2014-04-15
739 reads
Simple SQL Server
Why worry about CXPACKET
Many people see CXPACKET at the top of their waits and start trying to fix it. I know this topic’s...
2014-03-11
1,620 reads
Free SQL Server Training (not a sales pitch)
My company cut the training budget this year, and it’s not that uncommon for that to happen anymore. However, I’m...
2014-03-04
1,088 reads
The Approachable DBA
DBAs are the gatekeepers, but if we make it an unpleasant process then people will find a way around the...
2014-02-13
501 reads
Cleaning up the Buffer Pool to Increase PLE
Chances are you have extra information in the buffer pool for a bad query and it’s dragging down your PLE,...
2014-01-08
2,045 reads
Indexing Fundamentals
First, lets understand what the types of indexes are. If you take a reference book, you have the two types...
2013-11-20
1,688 reads
New Job Checklist
I started a new job a month ago, but didn’t want to just figure things out as they came to...
2013-10-08
847 reads
Disaster Recovery and Business Continuity
Fires, SAN failures, tornados, and car accidents all came up today, yet it was a very good day at work. ...
2013-10-04 (first published: 2013-09-30)
2,174 reads
Monitoring and Baselines Presentation
Here’s my full presentation for SQL Saturday #250 in Pittsburgh this past Saturday along with some notes on what I...
2013-09-20
954 reads
Monitoring Database and Table Sizes
Trending database and table sizes helps give you an idea of what to expect, and, sometimes, points out problems and...
2013-09-11 (first published: 2013-09-10)
4,102 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
Alamat BCA KCU BANJARMASIN Telp:(0817825533)
WA CS 62 817-825-533 Jl. Lambung Mangkurat No.11-13, Kertak Baru Ulu, Kec. Banjarmasin Tengah,...
Alamat Kantor BCA KCU TARAKAN Telp:(0817825533)
WA CS 62 817-825-533 Jl. Yos Sudarso Pantai No.08, Karang Rejo, Kec. Tarakan Bar.,...
Alamat BCA KCU PONTIANAK Telp:(0817825533)
WA CS 62 817-825-533 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak...
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers