By Posted on Posted in Performance No Comments

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 CXPACKET OLEDB LCK_M_IS ASYNC_NETWORK_IO XE_LIVE_TARGET_TVF SP_SERVER_DIAGNOSTICS_SLEEP LCK_M_SCH_M LCK_M_IX LCK_M_SCH_S Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

By Posted on Posted in JOIN Types No Comments Tagged with , , ,

In SQL, a LEFT OUTER JOIN is a type of JOIN operation that combines data from two tables, based on a JOIN condition. This type of JOIN is called an outer JOIN because it includes not only the matching rows from the tables, but also the rows from the left (or first) table that do not have a matching row …

Left Outer Join (Left Join) Read more »

By Posted on Posted in Performance No Comments Tagged with , ,

One of the key tasks of a database administrator is to ensure that the SQL Server database is running efficiently and effectively. One way to do this is by using performance tuning techniques, which can help identify and resolve any performance bottlenecks or issues in the database. One performance tuning tip for SQL Server is to use the sys.dm_exec_query_stats dynamic …

SQL Performance – Finding total elapsed time Read more »

By Posted on Posted in SQL Server No Comments Tagged with

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 an existing table, without having to drop and re-create the table. To use the sp_rename stored procedure, you need to specify the current name of the table and the new name you want to give …

Renaming a Table in SQL Server Read more »

By Posted on Posted in JOIN Types No Comments Tagged with , ,

A LEFT OUTER JOIN with exclusion is a type of JOIN operation in SQL that combines data from two tables, based on a JOIN condition, and excludes the rows that match the JOIN condition. This type of JOIN is called an outer JOIN with exclusion because it includes the rows from the left (or first) table that do not have …

Left Outer JOIN with Exclusion Read more »

By Posted on Posted in Classes, CTE No Comments Tagged with , ,

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, UPDATE, or DELETE statement. It is defined using the WITH keyword, and can be thought of as a temporary view or inline table-valued function. One of the primary advantages of using a common table expression …

Common Table Expressions Read more »

By Posted on Posted in JOIN Types No Comments Tagged with , ,

A SQL Server inner join is a type of join that combines records from two or more tables in a database based on the values of the joined columns from each table. Inner joins only return rows that have matching values in the joined columns. In contrast, an outer join will return all rows from one table, and any matching …

Inner Join vs. Outer Join Read more »

By Posted on Posted in Performance No Comments

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 Server Mentoring is a training / consulting option for those who just need a little help or direction. This is a cost-effective approach for those who need just a little help. Some call it coaching, …

SQL Server Mentoring – Do you need some occasional help? Read more »

By Posted on Posted in Managed Services No Comments Tagged with ,

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! Our Managed Services are so comprehensive you would think we’re on your payroll. So you can focus on what the business really needs. Below is what our Managed Services can provide you! Our monthly managed services is …

Focus on what’s best – leave us the rest Read more »

By Posted on Posted in SQL Server No Comments Tagged with , ,

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 or more columns. There are two main types of indexes in SQL Server: clustered and nonclustered indexes. A clustered index A nonclustered index The main difference between a clustered and a nonclustered index is how …

SQL Server and Clustered vs. NonClustered Indexes Read more »