SQL Server

How to list all SQL Server indexes?

How to list all SQL Server indexes? It can be very useful to display all database indexes to have an idea at a glance at how this SQL Server database is optimized with indexes, whether CLUSTERED or NON CLUSTERED. This query offers you a synthetic list of indexes. If shows

SQL Server

How to split a long SQL Server text into lines?

How to split a long SQL Server text into lines? The string to split can have a comma or a semicolon delimiter. Using an SQL Server query, you can cut a string compounded of text delimited by commas, semicolons, tabulations, dash, underscore, or even dots. It can basically be any

SQL Server

Display SQL Server version with sql query

How to display the SQL Server version exact number with a simple SQL Server query? Using SQL Server Management Studio, to get the exact version of the SQL Server installation, it’s possible by using simple T-SQL queries.   For example, it’s very helpful to know the exact version of SQL

SQL Server Errors

Invalid object name SQL Server CTE Error

How to execute multiple SELECT queries on the same CTE? As a reminder, a CTE is a temporary object that only exists between its creation and the first time it’s used. It means it’s deleted right after the first query ran against the CTE. Indeed when querying the second time