User Ronaldo

0 votes

Can't alter database roles on a restored database

answered May 24, 2020 at 18:48

0 votes

Accepted

Getting the exact and closest Search using CONTAINS/CONTAINSTABLE in SQL

answered May 30, 2020 at 13:51

0 votes

Accepted

Full-Text Search against serial numbers?

answered Jun 1, 2020 at 17:36

0 votes

Creating a database snapshot for every previous month

answered Mar 20, 2020 at 15:28

0 votes

Is there a way to determine what caused the last growth operation of my database (MDF file)?

answered Dec 5, 2019 at 19:59

0 votes

SQL Server Agent & sp_send_dbmail failing on permissions

answered Jan 13, 2021 at 19:11

0 votes

Accepted

An INSERT statement triggers the SQL Server Audit to write it down in the logs although INSERT is not listed as an Audit Action

answered Mar 17, 2021 at 20:31

0 votes

Recursive CTE to get Grandparent, parent, children

answered Mar 2, 2021 at 20:51

0 votes

Ola Hallengren scripts: after a job failure, how to skip the databases that worked and backup only the remaining ones?

answered Mar 4, 2021 at 16:41

0 votes

Accepted

Find closest match in two columns, one containing wildcards

answered Mar 6, 2021 at 12:54

0 votes

MS SQL Express - Find when a Query was run

answered Mar 8, 2021 at 13:22

0 votes

Cloning a SQL Server Virtual Machine with TDE

answered Jul 1, 2020 at 16:57

0 votes

SQL Server cluster node fail over details

answered Aug 18, 2020 at 20:20

0 votes

To generate a script to drop or map the orphan users in a SQL Server Instance

answered Jul 21, 2020 at 23:38

0 votes

SQL Server Query Store - why does it not always use the forced plan?

answered Apr 1, 2022 at 14:27

0 votes

How to "clone" entire MS SQL base to another host?

answered Aug 2, 2022 at 21:12

0 votes

Do linked servers stop working after migrating the system dbs to a new sever?

answered May 12, 2022 at 2:06

0 votes

Have to regenerate SQL Server Master Key after every server reboot

answered Dec 6, 2022 at 19:57

0 votes

Adding a Windows Server 2016 computer to a Windows Server 2022 Failover cluster

answered Oct 16 at 20:59

0 votes

Enforce password policy after creating a login

answered Jan 30 at 11:21

0 votes

How do I reattach a snapshot file?

answered Sep 16, 2022 at 17:36

0 votes

Tempdb log growth 3x as slow on new server, SP does not perform

answered Mar 19, 2021 at 17:40

0 votes

Failover Cluster Manager > Role > SQL Server (Node1 is owner) > Resources (SQL Server & SQL Agent)

answered Mar 29, 2021 at 19:52

0 votes

Can SQL Server log a password on a failed login attempt?

answered Nov 4, 2021 at 12:12

0 votes

Would re-seeding the InstanceID column of sys.jobhistory table create issues?

answered Jun 15, 2021 at 16:22

0 votes

Filegroups for a database in Restoring mode

answered Nov 15, 2021 at 18:20

0 votes

Query for when comparing to multiple child records

answered Dec 8, 2021 at 13:22

Stack Exchange Network

147 Answers

Can't alter database roles on a restored database

Getting the exact and closest Search using CONTAINS/CONTAINSTABLE in SQL

Full-Text Search against serial numbers?

Creating a database snapshot for every previous month

Is there a way to determine what caused the last growth operation of my database (MDF file)?

SQL Server Agent & sp_send_dbmail failing on permissions

An INSERT statement triggers the SQL Server Audit to write it down in the logs although INSERT is not listed as an Audit Action

Recursive CTE to get Grandparent, parent, children

Ola Hallengren scripts: after a job failure, how to skip the databases that worked and backup only the remaining ones?

Find closest match in two columns, one containing wildcards

MS SQL Express - Find when a Query was run

Cloning a SQL Server Virtual Machine with TDE

SQL Server cluster node fail over details

To generate a script to drop or map the orphan users in a SQL Server Instance

SQL Server Query Store - why does it not always use the forced plan?

How to "clone" entire MS SQL base to another host?

Do linked servers stop working after migrating the system dbs to a new sever?

Have to regenerate SQL Server Master Key after every server reboot

Adding a Windows Server 2016 computer to a Windows Server 2022 Failover cluster

Enforce password policy after creating a login

How do I reattach a snapshot file?

Tempdb log growth 3x as slow on new server, SP does not perform

Failover Cluster Manager > Role > SQL Server (Node1 is owner) > Resources (SQL Server & SQL Agent)

Can SQL Server log a password on a failed login attempt?

Would re-seeding the InstanceID column of sys.jobhistory table create issues?

Filegroups for a database in Restoring mode

Query for when comparing to multiple child records