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: Presentation Transcript: Introducing SQL Server 2012 AlwaysOn Readable Secondary Replicas

    SQL11UPD01-TSCRIPT-05 This wiki is a transcript of a previously recorded video. Related content assets: Presentation: Introducing SQL Server 2012 AlwaysOn Readable Secondary Replicas ( SQL11UPD01-DECK-03 ) Video: Introducing SQL Server 2012 AlwaysOn Readable Secondary Replicas ( SQL11UPD01...
    on7 Sep 2013

  • 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

  • Wiki Page: Finding Floor and Fraction of the Decimal Number

    Today I presented a solution for a very common request - given a decimal number, find its floor (I am using this Wikipedia definition ) as well as its fraction. This is the solution as appeared in that referenced thread: DECLARE @amount MONEY; SET @amount = 812.85; ...
    on4 Sep 2013

  • Wiki Page: Patindex Case Sensitive Search

    This article is a result of a quick research of the problem of using PATINDEX to search case insensitive column using case sensitive search. The BOL does not show examples of how to implement particular collation with the PATINDEX function. A relevant thread in MSDN Transact-SQL forum showed the syntax...
    on4 Sep 2013

  • Wiki Page: Database Size Limitations in All Versions and Editions of SQL Server

    This article is a stub and it is related to this MSDN thread According to this thread, the data file size limitation is not exposed through the query and most likely is hardcoded into the SQL Server assembly code. We can find data file limitations in BOL and we can create our own table to...
    on4 Sep 2013

  • Wiki Page: How SQL Server Determines Type of the Constant

    Table of Contents Problem Definition Explanation Conclusion See Also Problem Definition There was an interesting question asked recently in Transact-SQL forum "Basic doubt in Round function" . The problem was stated as following: SELECT ROUND(744, -3) produced...
    on4 Sep 2013

  • Wiki Page: SET ANSI_PADDING Setting and Its Importance

    Table of Contents Problem Description Investigation Resolution Script to correct problem in the whole database Default Database Settings See Also Other Languages Problem Description Recently I got an interesting escalation to solve for the client. Our VFP based application was getting the following...
    on4 Sep 2013

  • Wiki Page: SQL Server Resource Re-Balancing in Failover Cluster

    The poster asked how to automatically adjust SQL Server's max server memory setting following a cluster fail-over - see here . I provided the following script with suggestions for how it could be tailored for their environment. USE [ master ] GO /****** Object: StoredProcedure [dbo...
    on4 Sep 2013

  • Wiki Page: RegEx Class

    Slightly boring class for doing some regex... I've stored my notes on my pWord program which I also use for tracking passwords and it will always be open source. www.sourceforge.net/projects/pword . Please feel free to ignore my IE10 formatting woes using the WYSIWYG!. using System;...
    on4 Sep 2013

  • Wiki Page: Thinking in Sets

    Thinking in Sets is a great book by Joe Celko . This book tells us about concepts, how we need to think when we are working with databases. Columns are not fields, rows are not records and tables are not files, hence SQL is declarative, not procedural. There is no sequential access or ordering...
    on4 Sep 2013

  • Wiki Page: Structured Query Language

    By a “set” we mean any collection M into a whole of definite, distinct objects m (which are called the “elements” of M) of our perception or of our thought. —G eorge C antor , in “G eorg C antor ” by J oseph W. D auben (P rinceton U niversity P ress , 1990) Standard SQL is based...
    on4 Sep 2013

  • Wiki Page: SSRS Report

    Table of Contents Overview Power View Other Reporting Options See Also Overview SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend...
    on3 Sep 2013

  • Wiki Page: SQL Server: Transaction Log is Full

    Table of Contents Overview Recovery Model Additional Resources Reference See Also Overview If the transaction log is full, users cannot update the databases and you cannot fully restore the database in the event of a system failure. You must clear the transaction log either by performing a...
    on3 Sep 2013
Page 4 of 31 (766 items) «23456»
Can't find it? Write it!

Post an Article