2,279 Articles

Creating a Windows Server 2008 R2 Failover Cluster

Last Updated On : Wednesday, May 27, 2015The first step in creating a Windows Server 2008 R2 failover cluster to host a SQL Server 2012 failover cluster is to install the Failover Clustering feature. You can do this through the Server Manager console, as shown in Figure 8-5, or by using the following Windows PowerShell […]

Miscellaneous Statements

Last Updated On : Thursday, October 19, 2017Miscellaneous Statements: In this post we will discuss the miscellaneous statements or DBCC statements, their functions, and the permissions required to run them are as follows: DBCC dllname (FREE) Unloads a specific extended stored procedure DLL from memory. The user must be a member of the sysadmin fixed […]

Row-Level Compression

Last Updated On : Tuesday, May 26, 2015Row-level compression works by using more efficient storage formats for fixed-length data. Row-level compression uses the following strategies to save space: 1) Storing fixed-length numeric data types and CHAR data types as though they were variable-length data types. 2)Not storing NULL or 0 values. 3)Reducing metadata required to […]

Deploying and Configuring SharePoint Integration

Last Updated On : Tuesday, May 26, 2015You can deploy Analysis Services and Reporting Services as shared services in a SharePoint farm. Deploying Analysis Services and Reporting Services enables you to use features such as PowerPivot for Microsoft SharePoint and Power View, a Reporting Services interactive report designer. To deploy Reporting Services, Power View, and […]