Inner Join versus Outer Join
Inner Join versus Outer Join, A SQL Server inner join is a type of join that combines records from two or more tables in a… Read More »Inner Join versus Outer Join
SQL Server Mentoring – Do you need some occasional help?
Sometimes we all need a little help without a long term commitment. That why we created our SQL Server Mentoring service at Stedman Solutions. SQL… Read More »SQL Server Mentoring – Do you need some occasional help?
Focus on what’s best – leave us the rest
If you’re growing your business, you don’t have time to manage your databases. Let us manage your SQL Server so you can seize the day!… Read More »Focus on what’s best – leave us the rest
SQL Server and Clustered vs. NonClustered Indexes
In SQL Server, an index is a data structure that allows you to quickly retrieve data from a table based on the values of one… Read More »SQL Server and Clustered vs. NonClustered Indexes
How to Find Missing Indexes
In SQL Server, missing indexes are indexes that the query optimizer has determined would improve query performance, but do not exist in the database. Identifying… Read More »How to Find Missing Indexes
Finding the version of SQL Server being used
To find the version of SQL Server that is being used, you can use the @@VERSION system function. This function returns a string that contains… Read More »Finding the version of SQL Server being used
Common DBA Interview Questions
There are many different DBA (database administrator) interview questions that employers may ask to assess a candidate’s knowledge and skills. Some of the most common… Read More »Common DBA Interview Questions
Sleep Better Knowing We’ve Got You Covered
If you have a SQL Server with backups and vulnerability issues or running on an older version of SQL, I can guess to say you… Read More »Sleep Better Knowing We’ve Got You Covered
SQL Server Errors 823, 824, or 825
Errors 823, 834, and 825 are all related to I/O errors in SQL Server. These errors occur when SQL Server is unable to read or… Read More »SQL Server Errors 823, 824, or 825
SQL Server Isolation Levels and What They Mean
In SQL Server, the isolation level is a property that determines how transactions are isolated from each other, and how they access and modify data… Read More »SQL Server Isolation Levels and What They Mean