To find out when your SQL Server was last booted or re-started, we can run any below queries – SELECT sqlserver_start_time FROM sys.dm_os_sys_info; SELECT login_time FROM sys.dm_exec_sessions WHERE session_id = 1; SELECT start_time from sys.traces where is_default = 1; SELECT crdate FROM sysdatabases WHERE name=’tempdb’; SELECT create_date FROM sys.databases WHERE …
An indexed view is a view with a unique clustered index created on it. It is also called Materialized View. If a query contains references to columns that are present both in an indexed view and base tables, and the query optimizer determines that using the indexed view provides the …
What is PostgresSQL? PostgreSQL was created by a computer science professor Michael Stonebraker and his team. It’s a one of the popular open-source database. PostgreSQL is a powerful, open source object-relational database management system, the most advanced open source database system. PostgreSQL was developed based on POSTGRES 4.2 at Berkeley Computer Science Department, …
Why do we have Right Join in SQL, if we can use Left Join to get same result as of Right Join by just changing the position of tables? Most of the people has concern on Right Outer Join. Why it is needed. This is useless, blab blab… The answer …
While running the Report Manager Website if we are getting the webpage with following error “The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) …
Once You get error: The permissions granted to user ‘Domain\User’ are insufficient for performing this operation. (rsAccessDenied) Solution: Go to > Start Menu > start Internet Explorer as “Run as Administrator” Open Your Report Server URL Go to Site Settings Security->New Role Assignment In the Report Manager website, click Folder …
