User Marcello Miorelli

83 votes

2 answers

166k views

How to add the Debug button to SSMS v18?

asked Oct 30, 2018 at 14:18

38 votes

4 answers

80k views

Blue icon with question mark - what does it mean?

asked Jun 19, 2017 at 16:20

35 votes

2 answers

7k views

DBA first day in a new job - check backups and security - How? what else should be checked?

asked Feb 15, 2017 at 12:26

32 votes

1 answer

39k views

Warning about memory "Excessive Grant" in the query plan - how to find out what is causing it?

asked Sep 6, 2018 at 15:33

25 votes

1 answer

28k views

Operator used tempdb to spill data during execution with spill level 2

asked Oct 20, 2016 at 16:59

21 votes

2 answers

76k views

The certificate chain was issued by an authority that is not trusted

asked May 17, 2017 at 8:29

19 votes

5 answers

6k views

Unable to create a Filtered Index on a Computed Column

asked Sep 28, 2015 at 15:37

18 votes

3 answers

56k views

Error message - view server state permission was denied - when connecting to SQL Server 2014 using SQL Server 2012 Management Studio

asked Oct 19, 2015 at 11:18

16 votes

4 answers

82k views

how to query SSISDB to find out the errors in the packages?

asked Oct 21, 2015 at 12:05

15 votes

3 answers

61k views

what AD groups logins my user belongs to?

asked Jan 7, 2016 at 13:57

15 votes

3 answers

4k views

Why is my EXISTS query doing an index scan instead of an index seek?

asked Mar 18, 2016 at 19:27

14 votes

2 answers

8k views

space usage on sys.allocation_units and sp_spaceused

asked Dec 4, 2014 at 16:32

13 votes

3 answers

24k views

Replication Monitor Information using T-SQL

asked Jan 9, 2015 at 12:41

13 votes

2 answers

11k views

A possible infinite recompile was detected for SQLHANDLE

asked Sep 7, 2015 at 11:50

11 votes

4 answers

75k views

script to show all the permissions for a table

asked Sep 14, 2015 at 18:11

11 votes

3 answers

24k views

how to test if XML = '' in sql server?

asked Aug 18, 2016 at 9:58

10 votes

4 answers

42k views

Logon failed for login due to trigger execution

asked Sep 28, 2018 at 12:17

10 votes

2 answers

65k views

query performance gains by removing operator hash match inner join

asked Sep 16, 2015 at 17:32

9 votes

2 answers

11k views

Listing SQL Server instance startup parameters

asked Sep 7, 2015 at 15:19

9 votes

2 answers

22k views

sql server max memory includes SSIS?

asked Jul 27, 2015 at 23:30

9 votes

1 answer

256 views

how come a table variable is improving the performance of a query in this circumstance?

asked Apr 11, 2016 at 17:11

9 votes

2 answers

18k views

The metadata could not be determined because statement invokes an extended stored procedure

asked Jul 3, 2017 at 14:06

9 votes

6 answers

13k views

How do I format the output from OBJECT_DEFINITION so that it looks the same as sp_helptext?

asked Nov 20, 2017 at 12:00

9 votes

3 answers

20k views

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

asked Apr 14, 2020 at 15:55

8 votes

3 answers

14k views

How to script statistics in Sql Server? (using T-SQL)

asked Sep 30, 2016 at 13:55

8 votes

2 answers

21k views

Could not obtain exclusive lock on database 'model' - who is using it?

asked Sep 5, 2018 at 11:53

8 votes

2 answers

250 views

is there a work around for when you want to put an OR inside a filtered index?

asked Sep 28, 2015 at 20:20

8 votes

4 answers

36k views

The connection is broken and recovery is not possible - sql server error

asked Jul 27, 2015 at 10:39

7 votes

1 answer

7k views

SSAS - what could be a good starting point for memory settings?

asked Sep 17, 2015 at 11:27

7 votes

2 answers

306 views

When running a script with several commands, how to find out where we're at?

asked Sep 22, 2015 at 13:30

Stack Exchange Network

363 Questions

How to add the Debug button to SSMS v18?

Blue icon with question mark - what does it mean?

DBA first day in a new job - check backups and security - How? what else should be checked?

Warning about memory "Excessive Grant" in the query plan - how to find out what is causing it?

Operator used tempdb to spill data during execution with spill level 2

The certificate chain was issued by an authority that is not trusted

Unable to create a Filtered Index on a Computed Column

Error message - view server state permission was denied - when connecting to SQL Server 2014 using SQL Server 2012 Management Studio

how to query SSISDB to find out the errors in the packages?

what AD groups logins my user belongs to?

Why is my EXISTS query doing an index scan instead of an index seek?

space usage on sys.allocation_units and sp_spaceused

Replication Monitor Information using T-SQL

A possible infinite recompile was detected for SQLHANDLE

script to show all the permissions for a table

how to test if XML = '' in sql server?

Logon failed for login due to trigger execution

query performance gains by removing operator hash match inner join

Listing SQL Server instance startup parameters

sql server max memory includes SSIS?

how come a table variable is improving the performance of a query in this circumstance?

The metadata could not be determined because statement invokes an extended stored procedure

How do I format the output from OBJECT_DEFINITION so that it looks the same as sp_helptext?

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

How to script statistics in Sql Server? (using T-SQL)

Could not obtain exclusive lock on database 'model' - who is using it?

is there a work around for when you want to put an OR inside a filtered index?

The connection is broken and recovery is not possible - sql server error

SSAS - what could be a good starting point for memory settings?

When running a script with several commands, how to find out where we're at?