Browse by Tags

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....
  • Wiki Page: SharePoint Performance Best Practices: Limit SQL Server Memory Allocation

    Many times I have seen developers complaining about their SharePoint development environment performance. Since they have SharePoint standalone installation on their development Virtual Machine they always complain their machine is too slow. This is not only the case with development environment...
  • Wiki Page: SQL Server 2012 Developer Training Kit BOM

    Table of Contents Overview Day 1: Introduction and Database Engine Topics Module 1: Introduction to SQL Server 2012 Module 2: Introduction to SQL Server AlwaysOn Module 3: Exploring and Managing SQL Server 2012 Database Engine Improvements Module 4: SQL Server 2012 Database Server Programmability Day...
  • Wiki Page: SQL Server Samples Readme

    The SQL Server 2012 samples provide a variety of databases and files that you can use to learn about new and existing features. This article is the consolidated Readme for each sample in the SQL Server 2012 release. It provides prerequisite information, installation instructions, and links...
  • Wiki Page: Buscar Valores en una base de datos desde InfoPath 2010 programáticamente. (es-ES)

    Para realizar búsquedas en una base datos desde InfoPath en 3 pasos. 1. Crea la tabla en la base de datos donde tienes toda la información 2. Crea un formulario en InfoPath con los campos que necesita extraer de la base de datos. 3. Finalmente agregue el siguiente código en el botón buscar...
  • Wiki Page: Using TRY_CONVERT in SQL Server 2012

    Using TRY_CONVERT in SQL Server 2012 TRY_CONVERT returns the value as the specified data_type; if an error occurs, null is returned. However if you request a conversion that is explicitly not permitted, then TRY_CONVERT fails with an error. TRY_CONVERT conversion function is supported in SQL...
  • Wiki Page: How to convert Unicode Data to ASCII and back in SQL server

    Product Targeted MS SQL Server 2012 Summary In SQL server, few specific data handling scenarios require Unicode source data to be moved to non-Unicode destination format like ASCII format. During data conversion, it can be observed that the Unicode characters getting converted to ‘?...
  • Wiki Page: Perform Scalar Aggregates and Still get the Benefit of Batch Processing

    Scalar aggregates, (aggregates without a GROUP BY clause, like SELECT COUNT(*) from T ) are simple, but ironically they don't work with the CPU-saving batch mode of query execution with columnstore indexes in SQL Server 2012 RTM. Rest assured we're working already to make them run in batch...
  • Wiki Page: Troubleshoot Installation and Configuration Issues (Master Data Services in SQL Server 2012)

    When you install and configure Master Data Services (MDS) in SQL Server 2012, you might encounter any of the following issues. Fixing an MDS installation in a cluster Error when connecting to a remote database server Database creation fails when user account cannot be resolved Database...
  • Wiki Page: MVC 4.5 Areas and SQL Server 2012 Schemas Dichotomy

    Using Areas in MVC 4.5 can be hazardous to your health if you are starting out. My original Idea for a model in SQL 2012 was to create some schemas. In each schema name I had worked out a way to separate out some important business functionality in discrete business units like so: Finances, Inventory...
  • Wiki Page: SQL Server 2012 Log Shipping Yapılandırması (tr-TR)

  • Wiki Page: SharePoint 2010: Windows Server 8 üzerine SharePoint 2010'u SQL 2012 ile nasil yüklerim

    Table of Contents 1. Downloads Windows Server 8 2. Install Process: Server 8 3. Install Process: SQL 4. Install Process: SharePoint 1. Downloads Windows Server 8 ISO Windows Developer Preview with developper tools (64 bits) ISO Windows Developer Preview 64 bits Microsoft...
  • Wiki Page: SharePoint 2010: Hoe kunnen wij SharePoint 2010 met SQL 2012 op Windows 8 installeren? (nl-NL)

    Table of Contents Other Languages In dit artikel beschrijf ik hoe je SharePoint 2010 samen met SQL 2012 op Windows 8 kan installeren. 1. Downloads Windows Server 8 ISO Windows Developer Preview with developper tools (64 bits) ISO Windows Developer Preview 64 bits Microsoft...
Page 1 of 11 (263 items) 12345»
Can't find it? Write it!