User Ronaldo

1 vote

Locking and blocking lifetime on UNION queries on MS SQL Server

answered Jan 20, 2022 at 13:32

1 vote

How to manipulate the output of a GROUP BY CUBE query changing the NULL values generated for the groups?

answered Mar 28, 2022 at 20:07

1 vote

Accepted

Is it possible to use replication between 2 different SQL Versions?

answered Mar 29, 2022 at 10:46

1 vote

Accepted

SQL database mail configuration to use a domain account that is not the SQL Service account

answered Jul 31, 2020 at 19:20

1 vote

Accepted

Primary Key Index on a non-filtered column has a very high total lock wait time

answered Jun 11, 2020 at 12:24

1 vote

Why a backup created on SQL Server 2016 is significantly larger than one created on SQL Server 2012?

answered Jun 11, 2020 at 21:53

1 vote

Accepted

How to stop all nodes on FCI SQL server?

answered Jun 26, 2020 at 22:59

1 vote

Accepted

Why does SQL Server start REDO phase from minLSN instead of last CHECKPOINT?

answered Apr 8, 2020 at 14:19

1 vote

How to update group no incremental by 1 based on every group from 1 to 3?

answered Sep 14, 2020 at 12:10

1 vote

Accepted

Backup database using logical backup device in T-SQL

answered Nov 19, 2020 at 14:49

1 vote

Accepted

Disable password policy for partially-contained database

answered Nov 23, 2020 at 13:28

1 vote

Query to Linked Server Ignores Configured Timeout Connection

answered Dec 10, 2020 at 20:11

1 vote

Error 297, Severity 19 trying to create new table as sysadmin

answered Feb 11, 2021 at 17:19

1 vote

Accepted

Extended Events Login audit - Reduce login noise

answered Mar 9, 2021 at 23:45

1 vote

During upgrade, database raised exception 9002, severity 17, state 1. Use the exception number to determine the cause

answered Jan 27, 2021 at 14:04

1 vote

Accepted

SQL Server Full-text search for keywords without prefix matching

answered Nov 26, 2019 at 17:12

1 vote

Accepted

IndexOptimize is successful, but sys.dm_db_index_physical_stats still shows huge fragmentation

answered Nov 28, 2019 at 18:08

1 vote

Granting Permission on Databases and Schemas

answered Feb 11, 2020 at 15:40

1 vote

Accepted

sql server in docker using 15gb of disk space

answered Jan 5, 2020 at 14:14

1 vote

Accepted

Performance impact of a group by function call

answered Jan 7, 2020 at 12:13

1 vote

Accepted

Copy database removed source - Cannot acces mdf file

answered Jan 17, 2020 at 12:20

1 vote

Why does SQL Server say it can't convert varchar to numeric?

answered May 25, 2020 at 14:08

1 vote

Accepted

Recursive Parent-Child Location Relationship Cache as View

answered May 19, 2020 at 22:05

1 vote

Design Sql Server physical configuration from existing VM

answered Apr 10, 2020 at 21:35

1 vote

Query on Linked Server in SQL Active-Passive

answered Apr 11, 2020 at 12:48

0 votes

Accepted

Should every job, SSIS project, SSRS have its own sql login

answered Apr 14, 2020 at 13:32

0 votes

Accepted

Truncation error creating clustered index on schema-bound view

answered Apr 17, 2020 at 1:04

0 votes

How to find the current Log Sequence Number (LSN) of a database that is in Restoring state?

answered Apr 17, 2020 at 15:37

0 votes

Need to Bring Back most Recent Departure Date from Sales table for Customers in Recipient table

answered Apr 29, 2020 at 15:23

0 votes

Are AD Groups the exact same as individual windows logins with explicit permissions?

answered Apr 20, 2020 at 15:29

Stack Exchange Network

147 Answers

Locking and blocking lifetime on UNION queries on MS SQL Server

How to manipulate the output of a GROUP BY CUBE query changing the NULL values generated for the groups?

Is it possible to use replication between 2 different SQL Versions?

SQL database mail configuration to use a domain account that is not the SQL Service account

Primary Key Index on a non-filtered column has a very high total lock wait time

Why a backup created on SQL Server 2016 is significantly larger than one created on SQL Server 2012?

How to stop all nodes on FCI SQL server?

Why does SQL Server start REDO phase from minLSN instead of last CHECKPOINT?

How to update group no incremental by 1 based on every group from 1 to 3?

Backup database using logical backup device in T-SQL

Disable password policy for partially-contained database

Query to Linked Server Ignores Configured Timeout Connection

Error 297, Severity 19 trying to create new table as sysadmin

Extended Events Login audit - Reduce login noise

During upgrade, database raised exception 9002, severity 17, state 1. Use the exception number to determine the cause

SQL Server Full-text search for keywords without prefix matching

IndexOptimize is successful, but sys.dm_db_index_physical_stats still shows huge fragmentation

Granting Permission on Databases and Schemas

sql server in docker using 15gb of disk space

Performance impact of a group by function call

Copy database removed source - Cannot acces mdf file

Why does SQL Server say it can't convert varchar to numeric?

Recursive Parent-Child Location Relationship Cache as View

Design Sql Server physical configuration from existing VM

Query on Linked Server in SQL Active-Passive

Should every job, SSIS project, SSRS have its own sql login

Truncation error creating clustered index on schema-bound view

How to find the current Log Sequence Number (LSN) of a database that is in Restoring state?

Need to Bring Back most Recent Departure Date from Sales table for Customers in Recipient table

Are AD Groups the exact same as individual windows logins with explicit permissions?