DBCC FREEPROCCACHE is a DBCC command in Microsoft SQL Server that can be used to clear the procedure cache, which is a region of memory that stores the execution plans for stored procedures, triggers, and ad hoc Transact-SQL batches. Clearing the procedure cache can be useful for troubleshooting performance issues or testing the effects of changes to the database schema …
SQL Server is a powerful relational database management system used by businesses and organizations of all sizes. One of the most important operations in SQL Server is joining tables, which involves combining data from two or more tables based on a common column or set of columns. To help SQL Server users better understand the different join types and their …
Cross DB Ownership Chaining is a feature of SQL Server that allows one database to access objects in another database, even if the two databases are owned by different users. This feature is useful in certain scenarios, such as when you need to create a stored procedure that accesses objects in multiple databases. However, Cross DB Ownership Chaining can also …
Securing SQL Server: Cross DB Ownership Chaining Read more »
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 …