Resources For IT Professionals
Get this Tag RSS feed
Tag Cloud
Wiki  > All Tags > SQL Server
Tagged Content List

  • Wiki Page: SQL Server 2008+: Group By with Wings

    This article includes information about a feature from SQL Server 2008 (and up) - Group by extensions. Table of Contents Problem Definition Solution Grouping Sets Cube: Conclusion References Problem Definition In SQL Server 2005 and earlier versions, we would have faced the situation...
    on7 Sep 2013

  • Wiki Page: How to Store Different Languages Data in the Same Database and Analyse them Effectively

    Reference # http://social.msdn.microsoft.com/Forums/sqlserver/en-US/d6da2336-5208-4d1c-9406-dcccbb003dca/collation Today we got an interesting question from the user, where he is trying to store multiple collations consisting of multiple languages in the same database and he needs to manage it...
    on7 Sep 2013

  • Wiki Page: Introduction to Database Design Video

    This video is a one hour presentation that helps people quickly understand the fundamentals of relational tables and the normalization design process. The presentation explains the normalization design process. It then walks through an example of using the process to design a set of tables for an order...
    on6 Sep 2013

  • Wiki Page: SQL Server Reporting Services

    Overview Microsoft SQL Server Reporting Services (SSRS) provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise. Reporting Services provides a...
    on6 Sep 2013

  • Wiki Page: SSRS: How to Repeat Headers on Each Page

    This article shows an example of how to repeat headers on each page of SSRS report . Consider this code block is my dataset query from AdventureWorks database: SELECT TOP 100 BusinessEntityID,JobTitle,Gender FROM [HumanResources].[Employee] Drag and drop Table from Toolbox...
    on5 Sep 2013

  • Wiki Page: SSIS: How to Add Missing Control Flow Items / Data Flow Items to the SSIS Toolbox

    This article is about adding missing Control Flow Items / Data Flow Items to the SSIS Toolbox, which is one of the FAQs in MSDN SSIS forum - http://social.msdn.microsoft.com/Forums/en-US/07c2c57d-c133-47bf-80f4-a61b4d905b78/bids-2008-r2-where-is-toolbox-control-flow-items In SSIS, Tools - >...
    on5 Sep 2013

  • Wiki Page: SSRS: Multiple Ways to Split a String into Multiple Lines

    This post is about how to split a string inside textbox or field into multiple lines . Below are the options to split a string into multiple lines : i.) using VBCRLF ii.) using chr(10) iii.) using <br> HTML tag Consider for example that I have a string "Microsoft Reporting...
    on5 Sep 2013

  • Wiki Page: SSRS: How to Repeat Headers for Each Group

    This article is going to share the information on i) how to repeat headers for each group ii.) how to overcome this error: "An error occurred during local report processing . The definition of the report '/Report ' is invalid . The tablix 'Tablix' has a detailed member...
    on5 Sep 2013

  • Wiki Page: SSRS: How to set Column Visibility Property for Many Columns Based on Parameter's Value

    This article is about setting Column Visibility property for many columns based on Parameter value. We can set Column Visibility property for Tablix/Matrix columns by selecting the column and then right-click - > Column Visibility - > Show or hide based on expression and then enter our custom...
    on5 Sep 2013

  • Wiki Page: SSRS: How to Group Same Row Data with One Column Having Varying Data

    This article is the outcome of my answer to this question in the SSRS forum. Consider this sample data DECLARE @sample_data table ( [ Year ] varchar (5), Emp_id varchar (30), Name varchar (30), Accomplishments varchar (30) ) insert @sample_data...
    on5 Sep 2013

  • Wiki Page: SSIS: Move a Folder from one Drive to Another Drive Using the File System Task

    When I tried to answer the question in this thread - http://social.msdn.microsoft.com/Forums/sqlserver/en-US/cec6c11f-ec2c-48e2-9c14-199c640ebb05/move-folder-using-file-system-task , I came to know about the fact that using File system Task by setting the option Operation = Move Directory , we can...
    on5 Sep 2013

  • Wiki Page: How to shrink your SCVMM database (Transactional Log)

    (Generally speaking, this is not a ‘SCVMM-problem’. It`s linked to SQL, and the way the SQL server act when it comes to I/O, Memory, Data, - and log files.) Ok, you have had your SCVMM server running for a while now, all roles and services installed on a single server. Remember that the SCVMM...
    on5 Sep 2013

  • Wiki Page: SQL Server Versions

    Name Version Number Release Date Code Name SQL Server 2012 SP1 11.0.3128.00 28 Dec 2012 Denali SQL Server 2012 11.0.2100.60 1 April 2012 Denali SQL Server 2008 R2 10.50.1600.1 3rd May 2010 Kilimanjaro SQL Server 2008 10.00.1600...
    on4 Sep 2013
Page 7 of 62 (1,550 items) «56789»