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

  • Wiki Page: T-SQL: Send Replication Alert along with query to find exact command

    Table of Contents Introduction Script Script for usp_dba_sendcdosysmail Script for usp_dba_ReplAlert Note Introduction There are predefined alerts that can be used to send alert related with replication failure however that alert requires further investigation to identify root cause. Following...
    on27 Feb 2019

  • Wiki Page: SQL Server: What is fragmentation?

    Table of Contents What is fragmentation? How to detect fragmentation ? How to eliminate fragmentation ? 1. Alter index reorganize Query T-SQL : 2. Alter index rebuild Query T-SQL : Defragmentation of an index (Reorganize) What is fragmentation? A fragmented table is a table where some of its...
    on21 Feb 2019

  • Wiki Page: SSAS: Unified Dimensional Model

    Table of Contents Definition Components Community Resources See Also Other Languages Brazilian Portuguese (pt-BR) German (de-DE) Definition The Unified Dimensional Model (UDM) is the model for data in a SQL Server Analysis Services (SSAS) database. The UDM is unified because it combines data...
    on21 Feb 2019

  • Wiki Page: PowerPivot: Install the PowerPivot Add-In for Excel

    PowerPivot for Excel is a free download that significantly expands the data analysis capabilities of Excel. PowerPivot is made up of the Excel free add-in and the SharePoint server component. Video tutorial by Michele Hart , Technical Writer for Microsoft SQL Server. View all the PowerPivot...
    on20 Feb 2019

  • Wiki Page: BizTalk Server: Recommendations for Installing, Sizing, Deploying, and Maintaining a Solution

    Table of Contents Introduction Who Should Read This Guide Document Structure Initial Planning / determining which edition of BizTalk Server is appropriate for meeting your goals Determine the business goals of the BizTalk Server solution Mission Statement Business Requirements Create an architecture...
    on17 Feb 2019

  • Wiki Page: How to Embed SQL Server Express in an Application

    Table of Contents To Do List (Stub) Topics discussed in this article Which Edition of SQL Server Express to Use How to Register for SQL Server Express Redistribution Rights How to Detect Previous Installations of SQL Server How to Embed SQL Server Express Installation Using the Web Platform Installer...
    on11 Feb 2019

  • Wiki Page: How to Use ASP.NET with SQL Server

    Intended audience : Web developers new to SQL Server, who wish to learn how to use a SQL Server database with their ASP.NET web sites . The links below are external links and provide information and guidance on creating dynamic, data driven applications using SQL Server and ASP.NET technologies. This...
    on11 Feb 2019

  • Wiki Page: T-SQL: Negative Effects of SSMS Query Designer

    Table of Contents Introduction Illegibility Wrong JOIN Condition Suggestions Wrong JOIN Order WHERE Conditions in JOIN Unwelcome Changes Conclusion See Also Additional Resources Download Links Introduction Microsoft Query Designer is a visual tool which exists in SQL Server Management Studio...
    on11 Feb 2019

  • Wiki Page: T-SQL: Delete All Rows From a Table Except Top(N) Rows

    Table of Contents Introduction Problem Solutions Huge Table Truncate Table Delete in Chunks Small Table Conclusion See Also Introduction How to delete all rows from a table except the Top (N) rows, for example, leaving only the top (1000) rows? This article is the right answer to such questions...
    on11 Feb 2019

  • Wiki Page: T-SQL: How the Order of Elements in the ORDER BY Clause Implemented in the Output Result

    Table of Contents Introduction Case Study Solution Example 1 Example 2 Conclusion See Also Introduction This article shows that how the order of the elements in the ORDER BY clause in an SQL query can affect the output result sort. We will see how changing the order of these elements...
    on11 Feb 2019

  • Wiki Page: T-SQL: Troubleshooting When a Column Alias Created in the SELECT Clause Cannot be Used in the ORDER BY Clause

    Table of Contents Introduction Problem Solutions Solution One – Duplicate Computation Column Solution Two – Using CROSS APPLY Conclusion See Also DOWNLOAD the CODE All Codes used in this article is downloadable from this URL . Introduction...
    on11 Feb 2019

  • 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...
    on11 Feb 2019

  • Wiki Page: Azure SQL Database - Create And Connect SQL Database In The Azure Portal

    Table of Contents Introduction SQL database Create a SQL database Database name Subscription Resource group Select source Server Pricing Tier Collation Create a server-level firewall rule Setup Firewall Rule SQL Database Login in Azure Portal Output 1 Output 2 Reference Summary See Also Introduction...
    on5 Feb 2019
Page 19 of 123 (3,075 items) «1718192021»