User Marcello Miorelli - Database Administrators Stack Exchange

Marcello Miorelli

Member for 10 years, 8 months
Last seen this week

Twitter
GitHub
linkedin.com/in/mmiorelli
London, United Kingdom

222 Answers

Score Activity Newest

16 votes

Accepted

query performance gains by removing operator hash match inner join

answered Sep 23, 2015 at 23:25

9 votes

Accepted

How to configure SQL Server Port on multiple instances?

answered Jul 22, 2015 at 13:55

8 votes

Accepted

script to show all the permissions for a table

answered Jan 4, 2016 at 14:48

8 votes

Warning for missing statistics in execution plan

answered Oct 6, 2016 at 17:08

8 votes

Accepted

Query processor could not produce a query plan because of the hints defined in this query

answered Nov 15, 2018 at 17:37

7 votes

Accepted

is it possible to alter the primary key of a table (from non clustered to clustered) in the subscriber only and not break the replication?

answered Oct 24, 2016 at 13:47

5 votes

List all permissions for a given role?

answered Nov 14, 2016 at 13:05

5 votes

Accepted

The Distributor has not been installed correctly. Could not enable database for publishing

answered Aug 4, 2017 at 16:41

5 votes

Accepted

administrator permissions on a SSAS database

answered May 18, 2018 at 8:15

5 votes

Accepted

what are memory fractions and how to get rid of them (or the sort operator) in the example below?

answered Sep 18, 2018 at 17:18

5 votes

Accepted

Tempdb log file was growing continuously on SQL Server 2008 R2-SP2. Could a pending insert statement which uses temporary table be a cause?

answered Apr 14, 2016 at 10:48

5 votes

Long running delete query

answered Jul 18, 2016 at 13:15

5 votes

Accepted

Execute Stored Procedure with Account that has only read access

answered Jun 1, 2016 at 16:50

5 votes

Accepted

Trace flag is running, but not message when deadlock happens

answered Sep 7, 2015 at 15:21

5 votes

Accepted

Linked Server from SQL Server to SSAS not working - what is missing?

answered Nov 11, 2014 at 15:33

4 votes

Accepted

Delete duplicates with specific columns as identifier

answered Nov 24, 2014 at 10:20

4 votes

Accepted

SQL Server : how to disable connections to a linked server?

answered Feb 18, 2015 at 11:51

4 votes

Accepted

How to install SSIS on SQL Server 2014?

answered Jul 27, 2015 at 13:19

4 votes

Accepted

what are all possible filters to add to a server-side trace?

answered Aug 8, 2016 at 11:39

4 votes

Accepted

How does SSMS get a list of files in a backup?

answered Apr 20, 2016 at 16:47

4 votes

Is there a way to generate table create script in TSQL?

answered Jan 4, 2016 at 11:41

4 votes

Accepted

How to find out the oldest full backup still existing on disk?

answered Feb 25, 2019 at 18:33

4 votes

How to get the SQL Server Activity Monitor's output using T-SQL?

answered Feb 23, 2017 at 16:14

4 votes

How to add 1 milliseconds to a datetime string?

answered Jul 23, 2019 at 18:06

3 votes

Accepted

What is better - having 10 databases for 10 organisations or 1 table for 10 organisation with org_id?

answered Apr 3, 2019 at 15:25

3 votes

The database principal owns a schema in the database, and cannot be dropped message

answered Jan 5, 2020 at 15:09

3 votes

How can I install the SQL Server PowerShell module on an offline machine?

answered Apr 14, 2020 at 15:55

3 votes

Accepted

Why does xp_logininfo truncates AD user account names? How to overcome this?

answered Jun 13, 2017 at 13:55

3 votes

Find Index size in sql server

answered Feb 20, 2017 at 11:47

3 votes

Scipt User roles and permissions

answered Sep 20, 2016 at 16:43

1

2 3 4 5

…