Question : I upgraded from 2008 R2 to a 2016 cluster [Microsoft SQL Server 2016 (SP1) (KB3182545) – 13.0.4001.0 (X64)]. […]
Is my index too expensive to maintain?
Question : I just indexed a view that returns 126 millions rows. There’s a process that uses this view to […]
how to grant permissions to all the synonyms inside a view?
Question : I have to grant permissions to a view. dbo.my_view, however, this view joins many tables, and other views […]
Trouble setting up mirroring on SQL Server 2016
Question : I’ve setup a test SQL Server 2016 server. I’ve installed 2 instances, restored a backup on the primary. […]
In 2-node cluster using failover with Dynamic Quorum, is Witness needed?
Question : I have a 2-node cluster on SQL Server 2016 Standard with failover clustering configured with Dynamic Quorum. There […]
String aggregation using STUFF
Question : Let’s say I have table #DOC like this: polNum boxNo batchNum 111111 null qwe1234 111111 ff/55 rto1235 111111 […]
sqlcmd returns Msg 701 when importing +10MB queries
Question : I have a powershell script that exports data from DBF files, saves them as .SQL files and then […]
Backup SQL Server 2016 Instance Logins
Question : I need to backup a Instance of SQL Server 2016, I already have nightly backups of desired databases […]
how to identify the transactions that are causing the transaction log to grow?
Question : I have a database of 20 GB which insists in having its transaction log over 7GB. when I […]
Specific format/formula when changing column datatype [duplicate]
Question : This question already has answers here: Is it possible to change the default style used by CAST/CONVERT when […]