Is there any way to know the current activity of each process in my SQL Server without use the current activity in the enterprise manager ?
Is there any undocumented table that can i query for know the issue ?
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.