Question : I am trying to refresh all my views using code I found on the web: DECLARE @ViewName VARCHAR(256) […]
Category: SQL Server
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 […]
Tempdb size strategy
Question : I’ve recently started my role as a DBA and my initial task has been to take ownership and […]
FCI with Alwayson Availability Group (Asymmetric Storage)
Question : I am trying to setup a demo environment where I have a windows cluster with 3 nodes. Node […]
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. […]
Create a user on database A with a procedure from database B (with EXECUTE AS)
Question : I have 2 logins : LoginA: role dbcreator + CONNECT ANY DATABASE LoginB: role sysadmin I have 2 […]
SQL Server CLR procedures and SQLCLR_QUANTUM_PUNISHMENT
Question : I have a CLR stored procedure running on SQL Server 2014. This stored procedure gathers some data (generally […]
backup history using availability groups
Question : When using availability groups it is hard to get backup history in situation of failover to secondary node. […]
Suggestion for enforcing unique constraint in a table where soft delete is implemented [duplicate]
Question : This question already has answers here: How to implement a ‘default’ flag that can only be set on […]
What are valid connection strings for SSMS login box?
Question : What are valid connection strings for SSMS login box? Every once in a while I will have to […]