By Posted on Posted in Performance No Comments

Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there is no private client information to expose here. For this month, here are the details. LCK_M_S LCK_M_U CXCONSUMER LCK_M_IX RESOURCE_SEMAPHORE CXPACKET LCK_M_IU SP_SERVER_DIAGNOSTICS_SLEEP PREEMPTIVE_OS_PIPEOPS OLEDB Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

By Posted on Posted in Mentoring No Comments Tagged with

Are you working on a SQL project and seeking expert guidance to ensure its success? Stedman Solutions’ SQL Server Mentoring is here to offer the support and expertise you need to overcome obstacles and achieve your objectives. Our team of seasoned mentors is prepared to help you navigate the intricacies of SQL Server and deliver outstanding outcomes on your current …

Boost Your SQL Projects Today with Stedman Solutions’ Expert Mentoring Services Read more »

By Posted on Posted in Performance No Comments

These stories come from a recording of a presentation by Steve Stedman and Derrick Bovenkamp. Steve: Now imagine with this picture, your fiber optic cable running through the middle of a fire and you’re doing a backup, or trying to load a database or something across the network, you’re probably not going to expect your connection to last very long. …

SQL Server Corruption: Stories About Causes of Corruption Read more »

By Posted on Posted in Classes, JOIN Types No Comments Tagged with , ,

As the instructor of the Join Types course, I’m thrilled to offer a comprehensive guide to SQL Server join types. Join types are essential for effectively querying data from multiple tables, and this course covers all the necessary join types, including INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN, as well as advanced topics like joins …

My Join Types Course  Read more »

By Posted on Posted in Performance No Comments

Recently when shrinking a SQL Server data file, I ran into the following error: File ID 3 of database ID 15 cannot be shrunk as it is either being shrunk by another process or is empty.DBCC execution completed. If DBCC printed error messages, contact your system administrator. Before I get any grief about how bad shrinking databases is, and a …

SQL Server DBCC Commands: Shrink Errors Read more »

By Posted on Posted in JOIN Types, TSQL No Comments Tagged with , ,

SQL Server provides several join types to combine data from two or more tables based on a common column or set of columns. Among these are the essential join types, including INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN. In addition, SQL Server also supports multiple inner joins or multiple outer joins, which can be used …

Multiple Joins – Poster  Read more »

By Posted on Posted in Performance No Comments

DBCC SHOWCONTIG is a has been announced to be deprecated for more than 10 years ago, meaning it may disappear in future versions of SQL Server. DBCC SHOWCONTIG is a DBCC command in Microsoft SQL Server that can be used to display information about the extent fragmentation of a table or index. Extent fragmentation occurs when the data pages of …

SQL Server DBCC Commands: DBCC SHOWCONTIG Read more »

By Posted on Posted in Managed Services No Comments Tagged with ,

Yes, our Managed Services is just that! Well almost. This service is the all-inclusive resort of SQL Services. Take look at what’s included. Agile Support (Core Support offered at both levels) Also Includes: High Availability Support (Core Support offered at both levels) Also Includes: Is this the kind of coverage you’re looking for?

By Posted on Posted in Performance No Comments

Today Microsoft released a new update for SQL Server. SQL Server 2019 CU20 for 2019 (15.0.4312.2 – April 2023) CU18 + GDR (15.0.4280.7 – February 2023) 2023-04-13 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None   SQL Server 2022 RTM Download links: NoneCU3 …

New SQL Update from Microsoft Read more »