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 …
Ensuring Your SQL Server’s Resilience: Free Backup, Recovery, and Business Continuity Self-Assessment In the realm of database management, the terms “backup,” “recovery,” and “business continuity” are more than just buzzwords; they are critical components of a robust SQL Server strategy that safeguards against data loss and downtime. At Stedman Solutions, LLC, we understand the complexities and challenges involved in ensuring …
Assessing SQL Server Backup and Recovery Readiness: A Must-Do for IT Managers and DBAs In today’s digital-first environment, ensuring the resilience and reliability of your SQL Server databases is not just recommended; it’s imperative. At Stedman Solutions, we understand the critical role that backups, recovery, and business continuity play in maintaining your organization’s health. That’s why we’ve developed a comprehensive …
SQL Server Backup and Recovery Readiness Assessment Read more »
Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in SQL Server. Whether you’re a seasoned SQL professional or just starting out on your database journey, this is the perfect time to dive deeper into the power …
Are you ready to deepen your understanding of SQL Join Types? Join us for an exclusive, live webcast that promises to elevate your SQL skills. This is your chance to be one of just 20 attendees at this special event. Webcast Overview: Start with the basics of the SELECT statement—the cornerstone of SQL querying—and swiftly move to a comprehensive exploration …
Exclusive Invitation: Master SQL Join Types with a Free Webcast Read more »
We are thrilled to announce the launch of our latest course at Stedman’s SQL School, entirely focused on SQL Server Replication! Available starting today, this course offers an in-depth exploration of all things related to SQL Server Replication, ensuring that database professionals like you can maximize data synchronization and integration across your networked databases. Dive deep into Snapshot Replication, Merge …
Launching Today: Comprehensive SQL Server Replication Course – Enroll Now! Read more »
Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in SQL Server. Whether you’re a seasoned SQL professional or just starting out on your database journey, this is the perfect time to dive deeper into the power …
Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …
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. PREEMPTIVE_OS_PIPEOPS SP_SERVER_DIAGNOSTICS_SLEEP CXPACKET ASYNC_NETWORK_IO PREEMPTIVE_OS_GETPROCADDRESS LCK_M_SCH_S LCK_M_S MEMORY_ALLOCATION_EXT CXCONSUMER LCK_M_IX Our daily monitoring product scans your SQL Server hourly and …
Common Waits Reported by Daily Monitoring This Month Read more »
Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in SQL Server. Whether you’re a seasoned SQL professional or just starting out on your database journey, this is the perfect time to dive deeper into the power …