Estimated Number of Rows to be Read
Rob Farley uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read.
Performance of the SQL MERGE vs. INSERT/UPDATE
The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?
Your Favorite Feature that Needs Work
This week Steve Jones asks what parts of SQL Server would you improve and why.
PowerShell Invoke-SQLCmd outputs DataTables you can INSERT into SQL Server
Aaron Nelson explains how you can take an existing SQL query, run it against a SQL Server and then take the results and save them to a different SQL Server without using Linked Servers.
A Failed Jobs Monitoring System
One DBA's tale of how to monitor jobs for failure and ensure that the DBA is alerted to the fact that there is a problem. (from Feb 2008)
Adding Slicers to a Reporting Services Report
This article shows you how to create dynamic slicers from a data set in an SSRS report
DBA Morning Check List
This article helps the DBA find and fix issues quickly by creating a DBA Morning Checklist.
Execution Plans
How many of you use Execution Plans to tune your queries? Do you understand the impact of different indexes? Mr. Vijayakumar looks at his experiments with different types of indexes and their effects on the execution plan use. A great article for those of you that want to learn more about how you can tune your server for better performance.
Monitoring Drive and Database Free Space
SQL Server will autogrow your databases as they run out of space. But the process doesn't manage space, nor does it check the free space on the drive. Allowing autogrow to grow unchecked and unmanaged will eventually use up all the free disk space and potentially crash your server. New author Mark Nash brings you his system for monitoring space usage and generating a report that eases this process.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Taman Melati Telpon. 08388331767
WhatsApp 08388331767 Gedung Taman Melati Margonda Jl. Margonda No.525 A, Pondok Cina, Kecamatan Beji,...
BCA Finance Tlpn/Wa:+6285188120691
Jl. Sunset Road No.88 B, Kuta, Kec. Kuta, Kabupaten Badung, Bali 80361
BCA KCU BANDAR LAMPUNG TELP/CS:083135765355
Whatsapp:083135765355 Jl. Yos Sudarso No.100, Bumi Waras, Kec. Bumi Waras, Kota Bandar Lampung, Lampung...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers