Renaming a Table in SQL Server
To rename a table in SQL Server, you can use the sp_rename system stored procedure. This stored procedure allows you to change the name of… Read More »Renaming a Table in SQL Server
SteveStedman
Left Outer JOIN with Exclusion
A left outer join with exclusion is a variation of the standard left outer join used to find rows from the left table that do… Read More »Left Outer JOIN with Exclusion
Common Table Expressions
A common table expression, also known as a CTE, is a temporary named result set in SQL that can be used within a SELECT, INSERT,… Read More »Common Table Expressions
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