Creating Encryption Key Backup for SSRS 2008R2 - r for taking backup of key -f for file location -i is the instance name of the Reporting Services Are you sure you want to extract the key from the report server? Yes (Y)/ No (N) : Y SECURE THE FILE IN A SAFE LOCATION The … Continue reading Creating Encryption Key Backup for SSRS 2008R2
Create
Create Indexed Views in SQL Server; SQL Equivalent of Oracle Materialized Views.
SQL Server supports creating indexes on a view. It is the same concept as Materialized Views in Oracle. The main difference in the syntax in normal views and indexed views is the clause "with schemabinding" CREATE VIEW [dbo].[ViewName] with schemabinding AS SELECT id, activityID, userID, value, date FROM dbo.TableName WHERE (field = 'activityID') Now you … Continue reading Create Indexed Views in SQL Server; SQL Equivalent of Oracle Materialized Views.
Create Indexed Views SQL Server 2005 and 2008
SQL Server supports creating indexes on a view. It is the same concept as Materialized Views in Oracle. The main difference in the syntax in normal views and indexed views is the clausa "with schemabinding" Now go ahead amd create the index on the view you just created.
Create login SQL Server 2008
1. Go to Login > Properties > Create New Login
SimpleSQLDBA | Shadab Mohammad 