Resources For IT Professionals
Get this Tag RSS feed
Tag Cloud
Wiki  > All Tags > SQL Server
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...
    on22 Sep 2013

  • 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 : ...
    on22 Sep 2013

  • 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...
    on22 Sep 2013

  • 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...
    on22 Sep 2013

  • 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...
    on22 Sep 2013

  • Wiki Page: Script to Create or Drop All Primary Keys

    I wrote a script to generate create or drop statements for all primary keys in a SQL Server database. It was originally published on my blog in 2009, but this is a better place to post it. The community has the ability to correct or enhance the script here. I did not test the script on a database that...
    on22 Sep 2013

  • Wiki Page: SQL Servers and Hyper-V with Dynamic Memory

    It`s official now - Microsoft SQL Server support Dynamic Memory: http://support.microsoft.com/kb/956893 Before we start to look at this from the Hyper-V perspective, let’s refresh our knowledge on SQL server and memory management. It`s probably the biggest topic when it comes to SQL server...
    on22 Sep 2013

  • Wiki Page: SSIS Connectors with IBM MQ Series (WebSphere MQ)

    IBM WebSphere MQ is a network communication technology launched by IBM in March 1992. It was previously known as MQSeries , which is a trademark that was rebranded by IBM in 2002 to join the suite of WebSphere products. WebSphere MQ is IBM's Message Oriented Middleware offering. It allows independent...
    on22 Sep 2013

  • Wiki Page: SSIS with Microsoft Office (2007)

    SSIS uses two different OleDB providers to connect to MS Office data sources such as MS Excel files and MS Access databases: The JET Provider and the new ACE provider. JET is used to access all Office versions up to 2007, and ACE is used for Office 2007. Bob Beauchemin provided us with a nice...
    on22 Sep 2013

  • Wiki Page: SQL Server Integration Services - List of TechNet Wiki Articles

    This article lists known TechNet Wiki articles about SQL Server Integration Services . Table of Contents See Also SSIS: Move a Folder from one Drive to Another Drive Using the File System Task SSIS: How to Add Missing Control Flow Items / Data Flow Items to the SSIS Toolbox SSIS...
    on21 Sep 2013

  • Wiki Page: SQL Server Reporting Services - List of TechNet Wiki Articles

    This article lists known TechNet Wiki articles about SQL Server Reporting Services . Table of Contents See Also SSRS (Matrix): How to Repeat Headers on Each Page and Keep Headers Fixed while Scrolling SSRS - RDL Compare SSRS: Multi-valued Parameter as Stored Procedure Input ...
    on21 Sep 2013

  • 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....
    on21 Sep 2013

  • 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...
    on21 Sep 2013
Page 1 of 62 (1,550 items) 12345»