John Welch shares a script for checking MAXDOP, a SQL Server setting that controls how many processors may be used for parallel plan execution.
Category: SQL Server (4)
In a new blog, Brooke Philpott discusses how the SQL Server trace collection engine evolved over time and what the future holds.
Itzik Ben-Gan discusses missing T-SQL features like the DISTINCT FROM predicate, the NULL treatment clause, and controlling how NULLs are ordered.
Steve Wright shares the SentryOne formula—a balance of accuracy and simplicity—for calculating the ROI of SQL Server Monitoring.
Aaron Bertrand continues his series on large table compression with results from row and page compression, and a process involving scheduler manipulation.
Kevin Kline recaps his webinar covering some of the most common architectural choices that impact performance for SQL Server database applications.
In this blog, Kevin Kline shares the top 10 most common SQL Server mistakes made by DBAs, and resources to help avoid them.
Jonathan Kehayias shows a simple fix to C# code that can improve performance and throughput of workloads using table-valued parameters.
In this blog, Kevin Kline recaps a recent webinar on “Rightsizing your Cloud Consumption on AWS” and answers attendees’ top questions.
Itzik Ben-Gan continues his mind-bending series on NULL complexities in T-SQL, treating a variety of constructs, including the MERGE statement.
Kevin Kline and Louis Davidson answer your top questions on data modeling and database design for developers. Check out the webinar to learn more.
Aaron Bertrand continues his series on investigating compression a 1TB table, honing in on clustered columnstore and partitioning.
Glenn Berry describes different types of Azure VMs and explains which might be better suited to your SQL Server workload.
How can DBAs and data architects improve performance for vendor locked systems that won’t allow them to fully ply their craft? Jason Hall shares where to start.
Itzik Ben-Gan kicks off a new series of Transact-SQL blog posts treating NULL handling in SQL Server.
