Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  Naomi
Tagged Content List

  • 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: 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: SQL Server Developer Resources

    This page provides a listing of available resources for developers who are working with SQL Server. Table of Contents TechNet Wiki MSDN TechNet Blogs See Also Other Languages Español (es-ES) Deutsch (de-DE) Português (pt-BR) Japanese (ja-JP) TechNet Wiki Introduction to Development with...
    on17 Sep 2013

  • Wiki Page: Fixing Missing Data Based on Prior Row Information

    One of the commonly asked problems in the Transact-SQL forum is how to provide missing information based on the information in the first prior row that has data (or alternatively in the next row (by date)). One of the examples where this problem was discussed is this thread . In this thread...
    on16 Sep 2013

  • Wiki Page: T-SQL Useful Links

    This article will share collection of links in regards to various aspects in Transact-SQL language I acquired over the years and saved in links.txt file. Many of these links come very handy answering various questions in SQL Server related forums. Table of Contents Select Top N Rows per Group Performance...
    on15 Sep 2013

  • Wiki Page: Wiki: Technical Editing

    Table of Contents List of Checks for Every TechNet Wiki Article 1. Tags 2. Content 3. Layout 4. HTML 5. Improvements See Also This is a list of typical things that you can do right now, to get started helping out at TechNet Wiki. List of Checks for Every TechNet Wiki Article Please add the checks...
    on13 Sep 2013

  • Wiki Page: TechNet Guru Contributions

    Table of Contents What this Competition is About? List of Existing (past and present) Competitions Winners See Also What this Competition is About? Starting from May 2013 , TechNet Wiki is looking for and celebrating the best of the best! Is that you? Do you consider yourself an expert...
    on12 Sep 2013

  • Wiki Page: SQL Server PIVOT

    Table of Contents Problem Definition Common Problem Other Blogs See also Problem Definition Recently in this thread I helped to solve a relatively simple problem. I will quote my solution and then I will explain the main problem people often encounter with PIVOT solutions ; WITH...
    on12 Sep 2013

  • Wiki Page: T-SQL: Dynamic Pivot on Multiple Columns

    Table of Contents How to make a dynamic PIVOT on multiple columns See also Other Languages How to make a dynamic PIVOT on multiple columns The problem of transposing rows into columns is one of the most common problems discussed in MSDN Transact-SQL forum . Many times the problem of creating...
    on12 Sep 2013

  • Wiki Page: Wiki: Troubleshooting Portal

    This page is a community-driven list of troubleshooting portals and articles covered on the TechNet Wiki and the top associated articles for each technology. This list is not intended to include all the articles about each product, and this list only includes TechNet Wiki articles . The links are organized...
    on12 Sep 2013

  • Wiki Page: T-SQL: Applying APPLY Operator

    This article originates from the following MSDN Transact SQL Forum's question: Complex logic to be implemented in SQL - Please help! and I hope I made a pun with its title. In my solution to the problem presented by the thread's originator I am going to show how to use OUTER APPLY...
    on11 Sep 2013

  • Wiki Page: T-SQL: Date-Related Queries

    In this article I plan to add various interesting date related queries. This article will expand when new problems will present themselves in the Transact-SQL forum. Table of Contents Finding Day Number from the Beginning of the Year Finding Beginning and Ending of the Previous Month See Also ...
    on11 Sep 2013

  • Wiki Page: T-SQL: Gaps and Islands Problem

    This article will consider a simple classical Gaps & Islands problem asked recently in Transact-SQL Forum at MSDN with non original title "Query Help" . Table of Contents Problem Definition Solution See Also Problem Definition The thread originator was kind enough...
    on11 Sep 2013

  • Wiki Page: New Forums Design: Suggestions, Impressions, Ideas

    The forums underwent a complete re-design on June 19, 2013 and there are many things that can be done to improve them or make them usable. There is a special dedicated forum where we can discuss our ideas. Table of Contents Community Suggestions Implemented Requests Updates and Hotfixes See Also...
    on9 Sep 2013

  • Wiki Page: T-SQL: How to Find Rows with Bad Characters

    One of the commonly asked questions in Transact SQL Forum on MSDN is how to filter rows containing bad characters. Also, often times these bad characters are not known, say, in one of the recent posts the question was to filter all the rows where characters were greater than ASCII 127. The...
    on7 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: T-SQL: Group by Time Interval

    Table of Contents Simple Problem Definition Solution Complex Problem Definition and Solution See Also Simple Problem Definition A question was posted today in Transact-SQL forum " Counts by Time Interval " The thread originator wanted to know how to find how many jobs were completed...
    on3 Sep 2013

  • Wiki Page: TechNet Wiki Community Council: Areas of Focus

    Table of Contents August 2013 Areas of Focus Other Topics Previous Months June-July 2013 Areas of Focus April - May 2013 Areas of Focus See Also Other Languages As of the year 2013, the TechNet Wiki Community Council has 11 members (4 internal Microsoft employees and 7 community members). There...
    on29 Aug 2013

  • Wiki Page: C#: Nullable Types and ?? Operator

    Table of Contents Nullable types vs Non-nullable types What about Setting a Default Value when a certain variable is null? Nullable types vs Nullable fields Nullable types vs Non-nullable types While developing C# projects it is common to perform null comparison operation in order to avoid...
    on29 Aug 2013
Page 1 of 2 (34 items) 12
Can't find it? Write it!

Post an Article