The sys.databases table in SQL Server contains information about all databases in the current SQL Server instance. The state_desc column in this table represents the current state of the database, which can have the following possible values: Note that not all states may be applicable to every database, and the state of a database can change depending on its current …
Hi there, I’m Steve Stedman, and I’m excited to share with you my SQL Server course focused on SQL Server Joins, available at http://SteveStedman.com/joins. As an experienced database professional, I’ve designed this course to help you better understand the various types of SQL joins, and how they can be used effectively in real-world applications. One of the most fundamental skills …
SQL School: Master SQL Server Joins with My Comprehensive Course Read more »
Microsoft SQL Server is a relational database management system (RDBMS) available in several editions to cater to different needs and requirements. Two of the commonly used editions are SQL Server Express and SQL Server Standard Edition. Here are some key differences between them: Cost: Database size limit: Scalability: Features: Use cases: High Availability and Disaster Recovery: In summary, SQL Server …
SQL Server Standard Edition vs. SQL Server Express Edition Read more »
There are a few ways to stop blocking in SQL Server: It’s important to note that these methods should be considered on a case-by-case basis and depend on the specific needs of your application. It’s always a good idea to test the changes in a test environment before implementing in production. https://stevestedman.com/block_class
If you’d like to: Then Register for this Training March 29th at 1:30-2:15pm PST via Zoom Steve will demonstrate tips, tricks and features of this power house tool. Each month he will cover a different topic. And this is your chance to ask any question on your mind (regarding Database Health Monitor). Can’t make it? No Sweat! You’ll be emailed …
Are you working on a SQL project that needs expert guidance to ensure its success? Stedman Solutions’ SQL Server Mentoring provides the support and expertise you need to overcome challenges and achieve your goals. Our team of experienced mentors is ready to help you navigate the complexities of SQL Server and deliver outstanding results on your current projects. Discover our …
Accelerate Your SQL Projects with Stedman Solutions’ Expert Mentoring Services Read more »
Running the DBCC CHECKDB command is a critical part of database administration, as it ensures that your SQL Server database is free from corruption and data consistency issues. The Database Health Monitor for SQL Server provides insights into the results of the DBCC CHECKDB command, enabling you to identify potential issues and take corrective action to ensure database health. The …
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_IS CXPACKET CXCONSUMER LCK_M_S PREEMPTIVE_OS_PIPEOPS SP_SERVER_DIAGNOSTICS_SLEEP MEMORY_ALLOCATION_EXT OLEDB RESOURCE_SEMAPHORE LCK_M_IX Our daily monitoring product scans your SQL Server hourly and …
Common Waits Reported by Daily Monitoring This Month Read more »
DBCC SHRINKDATABASE is a DBCC command in Microsoft SQL Server that can be used to reduce the size of a database by moving pages of data from the end of the file to the front, and then releasing the unused space at the end of the file. It can be useful for reclaiming space in a database that has grown …
Hello there! My name is Steve Stedman, and I want to tell you about my amazing product, the Database Health Monitor. As a professional database administrator, I understand how vital it is to have a reliable and efficient monitoring tool that can provide insights into the performance and health of a database. That’s why I created the Database Health Monitor, …