Network profile

Mattia Nocerino

Reputation

454

454
293
133

2018
2019
2020
2021

Top tag

sql-server

Next privilege

500 Rep.

Access review queues

Badges

3

14

Newest

Notable Question

Next badge

0/1

Impact

1 post edited

2 helpful flags

74 votes cast

11 Questions

Votes Activity Newest Views

1

8

votes

1

answer

448

views

“Measure Type Dimensions” in “Accumulating Snapshot” fact table

database-design data-warehouse

Oct 14 '16 at 8:29 Community♦ 1

6

votes

2

answers

553

views

Statistics update with automatic sampling messes up density vector and histogram

sql-server sql-server-2016 statistics

Jul 11 '18 at 3:36 Joe Obbish 28.4k

1

4

votes

2

answers

1k

views

Move data from a table to another without losing data

sql-server sql-server-2016 partitioning migration best-practices

Jul 19 '18 at 15:44 Sting 2,485

3

votes

1

answer

129

views

Unable to use plan guide with sp_execute

sql-server sql-server-2017 plan-guides

Oct 18 '18 at 11:00 Mattia Nocerino 454

3

votes

1

answer

266

views

Can't find compiled parameters values in the plan cache

sql-server sql-server-2016 execution-plan parameter plan-cache

Jun 12 '18 at 14:13 Erik Darling 30.8k

2

votes

1

answer

362

views

Query using a filtered index but wrong estimated number of rows

sql-server-2016 index-tuning statistics filtered-index

Jun 6 '18 at 14:08 Mattia Nocerino 454

2

votes

1

answer

359

views

Multi server administration: Job that runs both on master and targets servers?

sql-server sql-server-2016 jobs multi-server-admin

Jul 5 '17 at 16:47 SqlWorldWide 10.5k

1

vote

1

answer

136

views

Trigger on indexed view

sql-server trigger sql-server-2017 materialized-view

Mar 3 at 8:54 Paul White♦ 58.5k

1

1

vote

2

answers

3k

views

SSMS crashes when attempting to create a database diagram

ssms crash windows-10

Feb 24 at 16:04 Jeffery Pyle 1

1

vote

1

answer

936

views

Why “Data File(s) Used Size (KB)” PerfMon counter doesn't exist?

sql-server sql-server-2016 perfmon

Oct 17 '17 at 10:44 Tom V 15.3k

0

votes

2

answers

28

views

Multiple disks vs single disk on virtualized environment

performance sql-server-2017 virtualisation

2d ago J.D. 8,983

Database Administrators Stack Exchange works best with JavaScript enabled