Tagged Content List
  • Wiki Page: Sort Letters in a Phrase using T-SQL

    Table of Contents Problem definition Introduction Solution Limitations 1. Data Type 2. Data Length See Also Problem definition This article comes up from this MSDN forum post. The problem is how can we sort the letters in a phrase just using T-SQL? To clarify the question, for instance...
  • Wiki Page: SQL Server Glossary

    Term Definition .NET Framework An integral Windows component that supports building, deploying, and running the next generation of applications and Web services. It provides a highly productive, standards-based, multilanguage environment for integrating existing investments with...
  • Wiki Page: Create a User for SQL Server 2008 Express Edition

    How to set a user to access on a db: Open Management Studio Go on properties of the server ex: SRV-2008\SQLEXPRESS Select mixed mode (SQL Server and Windows Authentication). Click OK. Always in Studio Management, add a new connexion ( unroll security) In general, enter a name for the account and...
  • Wiki Page: Using Bulk Insert to import inconsistent data format (using pure T-SQL)

    Table of Contents Introduction The problem Our Case Study The solution: STEP 1: Identify the import's file format Finding the problematic columns and the consistent columns format STEP 2: insert the data into temporary table Step 3: parsing the data into the final table Summary Comments Resources...
  • Wiki Page: Shrink SQL Database During Restore

    Table of Contents Case Study: First option: using compressed folder & symbolic link Step 1: Create a compressed folder Step 2: Backup your database Step 3: Create symbolic link to the compressed folder Step 4: Restore your database using the symbolic link. Step 5: Shrink the Database Step 6: Detach...
  • 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...
  • Wiki Page: SSRS: Troubleshoot Issues and Errors with Reporting Services

    Table of Contents Troubleshooting General Installation and Upgrade Configuration and Operations Samples Report Builder 3.0 SharePoint Integration and the SSRS SharePoint Add-In Report Server Report Manager See Also External Links Troubleshooting SQL Server 'Denali' Reporting Services...
  • Wiki Page: Connectors for SSIS: Persistent Systems

    If you are looking at various Data source and Target connection options to SSIS, visit the following Web site: http://www.persistentsys.com/products/ssisoracleconn/ssisoracleconn.htm Our Oracle bulk load is over 100 times faster than the OLEDB provider. It currently has high speed connectivity...
  • Wiki Page: SSRS Troubleshooting: Report Builder does not work after you upgrade from SQL Server 2008 SP1 to SQL Server 2008 R2

    Background: The default click-once version of Report Builder that will be used with SQL Server 2008 Reporting Services is Report Builder 1.0. If the Custom Report Builder Launch URL was modified to use Report Builder 2.0, then Report Builder may no longer work following an upgrade to SQL Server...
  • 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...
  • Wiki Page: SSIS: Flat File Source - Datetime Column Format Issue & Solution

    Table of Contents 1.0 Introduction 2.0 Problem Definition 3.0 How does it work 4.0 Solution 1.0 Introduction Flat files as Source are widely used in SQL Server Integration Services Tool. This article will discuss about one common issue with Flat File Date time Columns. (Details can be found...
  • 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...
  • Wiki Page: BizTalk Server Installation and Configuration Checklist

    Table of Contents Introduction General information regarding updating this article General advices before Installation of BizTalk and SQL machine SQL Server Installation Install BizTalk After installation SQL BizTalk See Also Introduction This list is intended as a simple checklist to verify the...
Page 4 of 62 (1,550 items) «23456»