Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  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

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

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

  • Wiki Page: Dropping a Clustered Index Will Not Reorganize the Heap

    If a clustered index will be turned into a HEAP, no reorganization of the data will occur. This "myth" is sometimes popping up in forums or blogs. A view "behind the scenes" will describe how Microsoft SQL Server is handling this operation. Before the deep dive into the internals...
    on19 Sep 2013

  • Wiki Page: SQL Server Security

    This is first post about SQL Server Security, in this post we will speak about Sever Configuration: First you need clear plan about your installation; what services you want, and what you aren’t, if you need SSAS, SSRS, Filestream and so on. In SQL server you need service account to install services...
    on19 Sep 2013

  • Wiki Page: SSIS Control Flow

    The Control Flow is the component in SSIS which ensure task workflow is executed in orderly manner. Control Flow tasks are individual, isolated units of work. For example we can consider for loop container which perform looping, also can execute standalone SQL Scripts/Stored procedures, call into...
    on19 Sep 2013

  • Wiki Page: Understanding the Error 1105 in MS SQL Server Database

    You were taking a backup and suddenly the MS SQL Database application showed you error message which looks something like this “Error 1105” “Severity Level 17” and message which looks like this “Could not allocate space for objects ‘%.*ls’ in database ‘%.*ls’ because the ‘%.*ls’ filegroup is full”...
    on19 Sep 2013

  • Wiki Page: SharePoint 2010: Ten Points to Pay Attention to for a Good Infrastructure

    SharePoint 2010: Ten points to have a great infrastructure #1 Limit your SQL When you install SharePoint 2010 on a complete mode with a SQL SERVER 2008R2, there is an option on the properties of the server, that you can limit the RAM usage. If you don’t limit the usage, it will use 2.1 petabytes...
    on18 Sep 2013

  • Wiki Page: SharePoint 2010: Importing Data from a SQL Database into a SharePoint list

    When developing solutions for the SharePoint platform, there's often a requirement to import data from a SQL database into one or more SharePoint lists. This can easily be accomplished using PowerShell. By using PowerShell you have a lot of control over what data gets imported, and how it is formatted...
    on18 Sep 2013

  • Wiki Page: T-SQL: Display Horizontal Rows Vertically

    This article is an outcome of my answer to this question on MSDN forum. Consider this scenario : Table 1: DEPARTMENT EMPID ENAME SALARY A/C 1 TEST1 2000 SALES 2 TEST2 3000 Table...
    on17 Sep 2013

  • Wiki Page: SQL Server Query Language - Transact-SQL

    This article lists known TechNet articles that are devoted to various aspects of the Transact-SQL language. Table of Contents SQL Server in General PIVOT CLR Dates Related APPLY operator String Functions Meta-Data XML Miscellaneous Bulk Data (bulk insert / bcp / openrowset) See Also SQL Server...
    on17 Sep 2013

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

    This article lists known TechNet Wiki articles about SQL Server Analysis Services . Table of Contents See Also Please add content See Also SQL Server Query Language - Transact SQL SQL Server Developer Resources SQL Server 2012
    on17 Sep 2013

  • 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...
    on17 Sep 2013
Page 1 of 31 (766 items) 12345»
Can't find it? Write it!

Post an Article