Skip to main content

Get free technical eBooks on SQL Server 2017 from Microsoft

Build your Microsoft SQL Server expertise with technical deep dives for your database journey. Free PDF eBooks from Microsoft SQL Server eBook series Get the technical resources and documentation you need to explore SQL Server 2017 – a comprehensive, mission-critical database for demanding workloads. With this series of technical eBooks on SQL Server, you’ll learn […]

Tonight: SQL Server User Group Sydney – The Roadmap for SQL Server

Sydney SQL Server User Group meets tonight from 5:30pm at Microsoft Reactor. Tonight’s Speaker: Victor Isakov (MCA, MCM, MCT, MVP) More details here. Tonight will cover: With support for Linux and Containers SQL Server 2017 opened up a new world of possibilities for Microsoft. SQL Server 2019 will bring to market a new modern data […]

How to fix: User, group, or role ‘*’ already exists in the current database. (Microsoft SQL Server, Error: 15023)

How to fix: User, group, or role ‘*’ already exists in the current database. (Microsoft SQL Server, Error: 15023)

 If you’ve restored a database onto another server, you may get the following error message when adding user logins to the database: Create failed for User ‘TMS’. (Microsoft.SqlServer.Smo) User, group, or role ‘TMS’ already exists in the current database. (Microsoft SQL Server, Error: 15023)   To fix this there are two different methods depending on […]

SQL Server Table Function Performance

Rob Farley has a great post on when is a SQL function not a function? Read the two below functions – they return the same thing, but one is more effecient than the other. If you can’t see why, head over to Rob’s post that shows the execution plans for a great explaination. CREATE FUNCTION dbo.FetchSales_inline(@salespersonid […]

ANSWER: UPDATE failed because the following SET options have incorrect settings: ‘ANSI_NULLS, QUOTED_IDENTIFIER’

I came across an interesting problem last night – a stored procedure that had been created years ago was suddenly coming up with this error message: UPDATE failed because the following SET options have incorrect settings: ‘ANSI_NULLS, QUOTED_IDENTIFIER’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or […]