The error “Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause” appears when a query uses ...

MSDN's SQL 2005 tool kit updated to 2008, 2012, 2014, 2016, 2017, 2019 and 2022 for detecting metadata in SQL Server, SSIS, SSRS and SSAS. This project is an update on the project released on MSDN ...

The primary key column is often set to auto-increment when constructing a SQL Server database. To achieve this, the IDENTITY property is enabled on the primary key column. The starting value and ...

A unique index ensures that all values in the indexed column(s) are unique. SQL Server automatically creates a unique index when defining a primary key constraint on a column. A clustered index ...

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...

Microsoft SQL Server continue to evolve greatly in terms of functionality. But the SQL engine also takes benefit from new features that are more discrete. One of them is a new index option called ...

Wini is a Delhi based writer, having 2 years of writing experience. During her writing stints, she has been associated with digital marketing agencies and technical firms. She has written content ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...