Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  SQL Server 2005
Tagged Content List

  • Wiki Page: How To Find Various Day, Current Week, Two Week, Month, Quarter, Half Year and Year In SQL Server

    Table of Contents Date Computation Finding Current Date Finding Start Date and End Date of the Week Finding End Date of the Week Finding Start Date and End Date of the Two Weeks See Also Date Computation I was working on one of the financial projects on one of my own custom implementation for SQL...
    on22 Sep 2013

  • Wiki Page: Service broker + trigger based data auditing

    I was assigned task to build our own Data Audit mechanism in SQL Server 2005 last year. There were number of articles and scripts on the internet about asynchronous auditing with service broker. I decided to get the best out of those articles and scripts and create my own trigger + service broker...
    on22 Sep 2013

  • Wiki Page: SQL Server - sqlcmd.exe

    The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt, in Query Editor in SQLCMD mode, in a Windows script file or in an operating system (Cmd.exe) job step of a SQL Server Agent job. This utility uses OLE DB to execute Transact-SQL batches...
    on22 Sep 2013

  • Wiki Page: Multiple Versions of MySQL 2005 and MySQL 2008 Redistributable on Windows 7 Ultimate Machines in a Domain Environment

    The Corporate Sales and Marketing team was trying out some Microsoft Visual Studio's trialware. Troubleshooting MySQL 2005 and MySQL 2008 redistributable in a Domain environment. The Graphics Design Team and Market Team, somehow got involved to ensure that everything met Market and Sales...
    on17 Sep 2013

  • Wiki Page: Servidor não aceita conexão do SQL e perde configuração dos compartilhamentos (pt-BR)

    Nota: [artigo originalmente publica em: http://www.thiagocardoso.org/2011/06/servidor-nao-aceita-conexao-do-sql-e.html ] Table of Contents Escopo Chamado do usuário Diagnóstico primeiro nível Diagnóstico segundo nível Ações no servidor pelo segundo nível Retorno para o Nível 1 e Usuários Retorno...
    on17 Sep 2013

  • Wiki Page: How to Create Query Shortcuts in SQL Server Management Studio

    You can create shortcuts for frequently used queries in Management Studio, some of the shortcuts are predefined, like pressing "Ctrl + 1" will execute "sp_who". You can create shortcuts for your own queries or change the existing shortcuts. To create a new shortcut, go...
    on17 Sep 2013

  • Wiki Page: Rebuild and Re-index Database Gradually

    I had a problem in our live environment - the database was fragmented - badly. A solution had to be written to defragment the database, whilst providing the least downtime - and the script below was born. I create a function that will defrag the top X (in this case 20) indexes and created a SQL...
    on17 Sep 2013

  • Wiki Page: Comment trouver divers jour, semaine en cours, deux semaines, mois, Quater, semestre et année dans SQL Server

    Table des matières D ay Semaine actuelle Date de début et Date de fin Deux semaines début et Date de fin Début de mois et Date de fin Date de fin et de début de trimestre Semestre début et Date de fin Début de l'année et la Date de fin Calcul de date Je travaillais...
    on17 Sep 2013

  • Wiki Page: Duplicate1:Querying SQL Server Metadata Information

    Returning metadata information about SQL Server objects is a common task. For example, you may want to list all of the tables in a database, or find the stored procedures that reference a certain table or column. This kind of information is available through catalog views and functions, but it can...
    on5 Sep 2013

  • Wiki Page: Duplicate:Querying SQL Server Metadata Information

    Returning metadata information about SQL Server objects is a common task. For example, you may want to list all of the tables in a database, or find the stored procedures that reference a certain table or column. This kind of information is available through catalog views and functions, but it can...
    on5 Sep 2013

  • Wiki Page: Database Engine Fixed Server and Fixed Database Roles

    Fixed server roles and fixed database roles are assigned specific permissions by SQL Server. The permissions of the fixed roles cannot be changed. Fixed server and fixed database roles are provided for convenience and backward compatibility. Beginning with SQL Server 2005, a more granular permission...
    on1 Sep 2013

  • Wiki Page: Star Schema

    Overview In SQL Server Analysis Services (SSAS) , a star schema describes a common data model for relational data warehouses. In a star schema, there are two types of tables: fact tables and dimension tables. In general, a relational data warehouse is a historical repository of a business's...
    on31 Jul 2013

  • Wiki Page: Data Source View

    Overview In SQL Server Analysis Services (SSAS), a data source view is a diagram of one or more relational data sources for the SSAS database. Developers use components from the data source view to construct the SSAS database's objects (e.g. dimensions and measure groups ). SSAS uses the data...
    on30 Jul 2013

  • Wiki Page: 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...
    on30 Jul 2013

  • Wiki Page: How to Troubleshoot Connecting to the SQL Server Database Engine

    This is an exhaustive list of troubleshooting techniques to use when you cannot connect to the SQL Server Database Engine. These steps are not in the order of the most likely problems which you probably already tried. These steps are in order of the most basic problems to more complex problems. These...
    on15 Jul 2013

  • Wiki Page: Accessing SQL Server Databases from PHP

    The Microsoft Drivers for PHP for SQL Server are Microsoft-supported extensions of PHP 5 that provide data access to all editions of SQL Server, beginning with SQL Server 2005. The Microsoft Drivers for PHP for SQL Server include two PHP extensions for accessing data in SQL Server: a procedural interface...
    on9 Jul 2013

  • Wiki Page: Measure Group

    Overview Measures are the numeric values of the facts (transactions) that users analyze in an OLAP database. In SQL Server Analysis Services (SSAS) , measures that come from the same source table in the OLAP database's data source are grouped together in a container called a measure group...
    on22 Jun 2013

  • Wiki Page: Time Dimension

    Table of Contents Overview Population Script OLAP Development Overview Population Script OLAP Development
    on22 Jun 2013

  • Wiki Page: Perspective

    Overview In a SQL Server Analysis Services (SQL) database, a perspective is a limited view of a cube . Perspectives enhance a user's experience by limiting the cube's visible objects to those objects relevant to the user's work. For example, a business that sells products through brick...
    on22 Jun 2013

  • Wiki Page: Dimension

    Overview A dimension is a key component of a SQL Server Analysis Services (SSAS) database. In the Unified Dimensional Model that is the data model of an Analysis Services database, dimensions describe the data, and users browse, filter, and aggregate data by manipulating dimensions. Understanding...
    on11 Jun 2013

  • Wiki Page: SQL Server Analysis Services (SSAS) (pt-BR)

    Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/1175.sql-server-analysis-services-ssas.aspx Table of Contents Visão geral Análise serviços Wiki artigos 101 Modelagem Dimensional Segurança Desempenho Administração...
    on6 Jun 2013

  • Wiki Page: Reporting Services Samples on CodePlex (SQL Server Reporting Services SSRS)

    Table of Contents Troubleshooting AdventureWorks sample reports Embedded Reporting The CodePlex home page for all SQL Server Reporting Services (SSRS) samples is SQL Server Reporting Services Product Samples . All of the samples are in one download package. If you are interested only in the...
    on28 May 2013

  • Wiki Page: Cube

    Overview In a SQL Server Analysis Services (SSAS) database, a cube is the container for the objects and data that users query: dimensions , measure groups , KPIs , and perspectives . A cube is analogous to a schema in a relational database: it brings together the metadata, data, and code related...
    on25 May 2013

  • Wiki Page: SQL Server Express: Troubleshoot Installation

    This article contains information on common problems that occur during the installation of SQL Server Express, why they occur and how to resolve them. If you have encountered and resolved a problem that is not listed, or have information to contribute to the resolutions already listed, please edit...
    on14 May 2013

  • Wiki Page: Grain (OLAP)

    Overview In SQL Server Analysis Services (SSAS) , the grain or granularity of a fact defines the level of detail recorded in the fact; it is determined by the dimension keys of the fact. If a fact references the key attribute of a dimension, then it records data at the most descriptive level of...
    on8 May 2013
Page 1 of 3 (65 items) 123
Can't find it? Write it!

Post an Article