Stack Exchange

marcello miorelli

London, United Kingdom

https://www.linkedin.com/in/mmiorelli

SQL Server DBA

You are exactly where you should be.

Join me on LinkedIn at https://www.linkedin.com/in/mmiorelli

top accounts reputation activity subscriptions
Top Questions
83 votes

How to add the Debug button to SSMS v18?

sql-server ssms asked Oct 30, 2018 at 14:18
dba.stackexchange.com

47 votes

How to find out why the status of a spid is suspended? What resources the spid is waiting for?

sql sql-server optimization query-optimization sql-tuning asked Feb 26, 2014 at 10:34
stackoverflow.com

38 votes

replace multiple values at the same time - in order to convert a string to a number

sql sql-server sql-server-2008 asked Apr 22, 2014 at 11:35
stackoverflow.com

38 votes

Blue icon with question mark - what does it mean?

sql-server sql-server-2016 asked Jun 19, 2017 at 16:20
dba.stackexchange.com

35 votes

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

sql-server sql-server-2014 backup restore security asked Feb 15, 2017 at 12:26
dba.stackexchange.com

34 votes

How were bullets fired through the propeller in the Focke Wulf 190?

aircraft-design military aviation-history asked Sep 1, 2016 at 15:05
aviation.stackexchange.com

32 votes

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

sql-server optimization execution-plan performance performance-tuning query-performance asked Sep 6, 2018 at 15:33
dba.stackexchange.com

25 votes

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

sql-server performance memory execution-plan sort-operator query-performance asked Oct 20, 2016 at 16:59
dba.stackexchange.com

21 votes

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

sql-server sql-server-2016 authentication kerberos certificate asked May 17, 2017 at 8:29
dba.stackexchange.com

19 votes

Unable to create a Filtered Index on a Computed Column

sql-server index sql-server-2014 computed-column filtered-index asked Sep 28, 2015 at 15:37
dba.stackexchange.com

1 2 3 4 5 … 9

Top Answers
59
How to find out why the status of a spid is suspended? What resources the spid is waiting for?
stackoverflow.com

47
How do I see active SQL Server connections?
stackoverflow.com

17
How to find out what is locking my tables?
stackoverflow.com

17
How to print GETDATE() in SQL Server with milliseconds in time?
stackoverflow.com

16
query performance gains by removing operator hash match inner join
dba.stackexchange.com

15
How to calculate the heading correction with a circular flight computer?
aviation.stackexchange.com

10
How to give a user access to sys.master_files in SQL Server?
stackoverflow.com

9
How to configure SQL Server Port on multiple instances?
dba.stackexchange.com

8
script to show all the permissions for a table
dba.stackexchange.com

8
Warning for missing statistics in execution plan
dba.stackexchange.com

8
Query processor could not produce a query plan because of the hints defined in this query
dba.stackexchange.com

7
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?
dba.stackexchange.com

5
Check if table exists in SQL Server
stackoverflow.com

5
Linked Server from SQL Server to SSAS not working - what is missing?
dba.stackexchange.com

5
SSRS Update Data Sources always reports "The password is not valid. Please retype the password."
stackoverflow.com

5
How to get the current session's dateformat
stackoverflow.com

5
Trace flag is running, but not message when deadlock happens
dba.stackexchange.com

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

5
Execute Stored Procedure with Account that has only read access
dba.stackexchange.com

5
Long running delete query
dba.stackexchange.com

5
List all permissions for a given role?
dba.stackexchange.com

5
The Distributor has not been installed correctly. Could not enable database for publishing
dba.stackexchange.com

5
administrator permissions on a SSAS database
dba.stackexchange.com

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