Question : We use some ‘aggregate’ views to select from multiple tables using a discriminator (note: these views are not […]
Tag: sql-server-2017
Struggling to create an efficient index for this query
Question : I am struggling to create an index for a query and unfortunately I cannot change the query at […]
Cancelling the rebuilding of a partition with compression
Question : Trying to enable compression on a large table in production but we are now out of time (been […]
How to lock a MSSQL (2017 Linux) account after N unsuccessful login attempts
Question : I have to configure account lock after N unsuccessful login attempts on MSSQL 2017 Linux. That is standalone […]
Create user with only SELECT and INSERT permissions
Question : I’m working on a project that requires a database user to have only SELECT and INSERT permissions for […]
Identify the line of a procedure of a spid/session
Question : In SQL Server 2017, how can I identify or pinpoint at which line of a stored procedure a […]
Upgrade SQL Server, not user databases
Question : I have one machine we’ve been fighting to do an in place upgrade of SQL Server from 2016 […]
Which areas need checking prior to decommissioning a windows account so that there are no issues?
Question : I am looking at decommissioning a service account (windows account). Before that I want to ensure that there […]
Why is statistics update slower on a clustered columnstore than on a rowstore?
Question : I’ve moved several large tables (each with >10^9 rows and a couple of dozens columns) from clustered rowstore […]
Why does a DELETE query run in one format much longer than in another?
Question : I have specific cleanup code that tries to remove some duplicates. This runs perfectly on many customer sites. […]