Tagged Content List
  • Wiki Page: Demo Transcript: Configuring SQL Server 2012 AlwaysOn Failover Clustering

    SQL11UPD01-TSCRIPT-08 This wiki is a transcript of a previously recorded video. Related content assets: Demo: Configuring SQL Server 2012 AlwaysOn Failover Clustering ( SQL11UPD01-DEMO-04 ) Video: Configuring SQL Server 2012 AlwaysOn Failover Clustering ( SQL11UPD01-REC-08 ) Configuring...
  • Wiki Page: How to Compare Two Tables Definition / Metadata in Different Databases

    This article is about the example on T-SQL Script to compare two tables definition / metadata in different databases . The T-SQL Script [used to compare two tables definition / metadata in different databases] in this article can be used from SQL Server 2012 and above version because I have used...
  • Wiki Page: SQL Server 2012

    Microsoft® SQL Server™ is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. In this wiki, you will find articles related to SQL Server 2012 by Features, Server Component or Management tools. You can find the full SQL Server Help documentation...
  • Wiki Page: How to Check the Syntax of Dynamic SQL Before Execution

    This article is about the system function sys.dm_exec_describe_first_result_set that can be used to check the syntax of dynamic SQL before execution. This system function sys.dm_exec_describe_first_result_set was introduced in SQL Server 2012. Create sample table and insert sample data : ...
  • Wiki Page: How to Put a Sequence in a Column Already filled

    Suppose we would like to create a sequence in a table already filled with data. I found out this solution to be pretty easy: CREATE TABLE SEQ (COK NVARCHAR( 10 )) insert into seq values ( 'York' ),( 'Boston' ),( 'Chicago' ) select * from seq --step 1 , I create a table...
  • Wiki Page: SQL Server Columnstore Index FAQ

    The SQL Server xVelocity memory-optimized columnstore index stores data by columns instead of by rows, similar to a column-oriented DBMS. The columnstore index speeds up data warehouse query processing in SQL Server 2012 through the current version, in many cases by a factor of 10 to 100. We'll...
  • Wiki Page: SQL Server Columnstore Performance Tuning

    Table of Contents Introduction Fundamentals of Columnstore Index-Based Performance DOs and DON'Ts for using Columnstores Effectively Maximizing Performance and Working Around Columnstore Limitations Ensuring Use of the Fast Batch Mode of Query Execution Physical Database Design, Loading, and Index...
  • Wiki Page: How To Find Various Day, Current Week, Two Week, Month, Quarter, Half Year and Year In SQL Server

    Table of Contents Date Computation Finding Current Date Finding Start Date and End Date of the Week Finding End Date of the Week Finding Start Date and End Date of the Two Weeks See Also Date Computation I was working on one of the financial projects on one of my own custom implementation for SQL...
  • Wiki Page: Microsoft SQL Server 2012 New Functions

    EOMONTH We had a problem whenever we wanted to identify the end date of a month. There was no built in function. But now that problem is solved in SQL Server 2012. The function EOMONTH returns the date of the month. SELECT EOMONTH (‘05/02/2012’) ‘EOM Processing Date Output: 2012-02-29...
  • Wiki Page: SharePoint 2013: Maximizing SQL Server 2012 Performance ( Free WhitePaper)

    Hello Everyone, For the past few weeks I was writing a Whitepaper about maximizing SQL 2012 Performance for SharePoint 2013. It’s been reviewed by 4 great guys , and after being exclusive to SharePoint-Community.net for one week, I release it to the public! Read the abstract or download the Whitepaper...
  • Wiki Page: Microsoft Learning Training and Certification - SQL Server 2012

    MSL Training Portal: http://www.microsoft.com/learning/en/us/training/sql-server.aspx Courses: The SQL Server 2012 courses are designed to enable database professionals to take full advantage of SQL Server 2012 and if they choose to validate their skills with certification...
  • Wiki Page: AD RMS (Windows Server 2008 R2) and SQL Server 2012 Install Steps

    Adding AD RMS on Windows Server 2008 R2 with a SQL Server 2012 backend is supported, but a hotfix (KB2619256) must be installed. The problem is that the hotfix will only install after some of the AD RMS components are installed. To get around this "Catch 22" situation, you can install using...
  • Wiki Page: SharePoint - Best Practices de performance : Limiter l'allocation mémoire de SQL Server (fr-FR)

    J'ai vu p lusieurs fois des développeurs se plaindre des performances de leur environnement de développement SharePoint. Comme ils ont une installation "standalone" de SharePoint sur leur machine virtuelle de développement, ils se plaignent toujours que leur machine est trop lente....
Page 1 of 21 (525 items) 12345»