Error message - view server state permission was denied - when connecting to SQL Server 2014 using SQL Server 2012 Management Studio9yr ⋅ marcello-miorelli-22336 ⋅ se/dba
Operator used tempdb to spill data during execution with spill level 28yr ⋅ marcello-miorelli-22336 ⋅ se/dba
varchar and nvarchar in tuning a stored procedure - how to improve performance in this scenario?8yr ⋅ marcello-miorelli-22336 ⋅ se/dba
left outer join - sort operations in the query plan - any ways of tuning this simple query?7yr ⋅ marcello-miorelli-22336 ⋅ se/dba
SSAS - what could be a good starting point for memory settings?9yr ⋅ marcello-miorelli-22336 ⋅ se/dba
calculating the total number of rows in a table - fails when it is a heap - is there any fix?9yr ⋅ marcello-miorelli-22336 ⋅ se/dba
SSRS 2014 - query running fine on management studio - report timing out - how to troubleshoot?8yr ⋅ marcello-miorelli-22336 ⋅ se/dba
The connection is broken and recovery is not possible - sql server error9yr ⋅ marcello-miorelli-22336 ⋅ se/dba
How to identify database users and their owned schemas before dropping server logins?9yr ⋅ marcello-miorelli-22336 ⋅ se/dba
Extended Events XML query to show relevant info about deadlocks - SQL Server 20149yr ⋅ marcello-miorelli-22336 ⋅ se/dba
how to find the T-SQL of a sleeping session that is blocking some other process?9yr ⋅ marcello-miorelli-22336 ⋅ se/dba
How to verify a SSAS Backup and how to perform Integrity Checks in SSAS?10yr ⋅ marcello-miorelli-22336 ⋅ se/dba
SSAS ErrorCode=3239575554 Either the user does not have permissions to alter the 'SERVER' object9yr ⋅ marcello-miorelli-22336 ⋅ se/dba
