Hi, Steve Stedman here, and I want to share with you a poster that I have created that provides a visual representation of the different join types in SQL Server. The poster is available at https://stedman.us/largePoster, and it is a print-on-demand product that can be ordered in a variety of sizes to suit your needs. The poster is designed to be …
Learn about our current sale on SQL Assessments A SQL assessment is necessary for business growth for several reasons, here are five: A SQL assessment can help an organization ensure that its database infrastructure is prepared for growth and can scale to meet future needs. Addressing any potential issues a head of time can save the organization time and resources …
5 Reasons Why This Service is Essential for Business Growth Read more »
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 »
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 »
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 »
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 …
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 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 …
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 …
In the last year I have seen far too much ransomware. I have seen some people lose their databases with no way of getting them back, and I have seen others who have been able to get everything. Some have paid the ransom, and some have not. Even some who have paid the ransom did not got their data back. …