Browse by Tags

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...
  • Wiki Page: SharePoint 2010: SQL Script to Backup Project Server Databases

    Backing up a Project Server database can be easier by using a procedure that includes all the database that you want to include. I drop that backup files on a share drive that is isolated from the server. Be sure the Share has write permissions for the SQL Process: USE MASTER BACKUP...
  • Wiki Page: MBAM Hardware and Recovery DB requires TDE on c

    Customers have been experiencing some pain with installing the Hardware and Recovery DB. The Transparent Data Encryption feature of SQL Server 2008 must be enabled for the Hardware and Recovery DB to install successfully. The documentation to date is missing this requirement. While we're fixing...
  • Wiki Page: Wiki: Localizar campos nativos e customizados do EPM 2010 via SQL Server 2008 (pt-BR)

    Olá Comunidade Técnica. Esse artigo é recomendado e bem útil para desenvolvedores e consultores em todos os níveis. 1 - O banco recomendado pela Microsoft para realizar consultas no banco de dados do EPM 2010 é o ProjectServer_Reporting . 2 - Acesse o SQL Server 2008 e se conecte...
  • Wiki Page: Solucionando Problemas: Error Failed to open loopback connection ao executar SP_READERRORLOG (pt-BR)

    Table of Contents Introdução Sintoma Causa Solução Leituras adicionais Introdução Tenho um ambiente com SQL Server 2008 instalado em um Windows Server 2008 R2 Service Pack 1 em Cluster, ao executar ao procedure SP_READERRORLOG é exibida uma mensagem de erro Failed to open loopback connection...
  • Wiki Page: Solucionando Problemas: code 0x80071398 The operation failed because either the specified node is not the owner of the group (pt-BR)

    Table of Contents Problema Como Identificar Solução Problema Error code 0x80071398 The operation failed because either the specified node is not the owner of the group, or the node is not a possible owner of the group Ao tentar executar o failover de um recurso do cluster para outro nó...
  • Wiki Page: SQL : Split Delimited Column into Multiple Columns Without External Function

    Without making any external code or CLR, when we try to split a column into multiple column based on the delimeter present in that column, it can be achieved with XML methods present(SQL server 2005 or above). When number of dseired columns are less(say 2 or 3), it is quite easy with the help of character...
  • Wiki Page: Calendar Analytics for PowerPivot: Feature Requests & Changes

    This wiki article exists is to capture feature requests, design changes, and bug fix requests for Calendar Analytics. Please leave a comment with your feature or design change requests (or add them by using the Edit tab). For bugs, please check http://social.technet.microsoft.com/wiki...
  • Wiki Page: T-SQL Script Detach, Move, and Attach Database

    One of my tasks recently involved moving the physical files from a set of MSSQL databases from one partition to another. These databases were part of a Sharepoint Farm. There were a number of databases so I created the following script in order to detach, move and re-attach the databases. This...
  • Wiki Page: SQL VDI Backups Fail with Error 9001

    Problem The issue was with SQL backups failing in SQL 2008 server due to the SQL Server VSS writer as posted by the user in the forum . Explanation When backup is occurring through SQL VDI Backups , it requires 3 threads to perform the backups for a single database. The link below...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • Wiki Page: SQL Server 2008+: Merge (Unity is Strength - Strengthen your Performance by Merge)

    Table of Contents Problem Definition Solution MERGE Points to note Conclusion Problem Definition In SQL Server for each DML transaction (Insert, Update, Delete) we need to write separate statements which will be executed one by one in SQL Server execution engine. Let's give a basic...
  • Wiki Page: Mejores Practicas de SQL Server 2008 para SharePoint 2010 Parte I (es-ES)

    Las buenas practicas de SQL Server como motor de base de datos de SharePoint, se debe tomar en cuenta los siguientes puntos : Mejor Practica 1 Es muy importante limitar el uso de Memoria RAM por parte del motor de SQL SERVER , requisitos minimos hay que tomar en cuenta tambien que el Sistema...
  • Wiki Page: Mejores Prácticas de Sql Server 2008 para SharePoint 2010 Parte II (es-ES)

    Mejor Práctica 4 Si el diseño requiere una base de datos más grande que el estándar recomendado, siga estas instrucciones: Para las bases de datos que contienen muchos archivos de gran tamaño que se almacenan como objetos binarios grandes (BLOB), considere la posibilidad de usar el almacenamiento...
  • Wiki Page: Exam 70-452 - PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

    Table of Contents Overview Skills Measured Preparation Materials Community Related Forum Posts Overview Language(s): English, French, German, Japanese, Spanish, Chinese (Simplified) Audience(s): IT Professionals Technology: Microsoft SQL Server 2008 ...
  • Wiki Page: MCITP: Business Intelligence Developer 2008

    The Business Intelligence Developer 2008 certification is for IT professionals who design and plan business intelligence (BI) solutions by using Microsoft SQL Server 2008 BI tools. The qualified candidate for this exam typically has two to three years of experience in the following: Working with...
  • Wiki Page: MCITP: Database Developer 2008

    The Database Developer 2008 certification is for IT professionals who are working in an enterprise environment that has more than 500 personal computers and more than 100 servers and mostly create solutions for all types of enterprise issues. They should have experience with the following: Writing...
  • Wiki Page: MCITP: Database Administrator 2008

    The Database Administrator 2008 certification is for IT professionals who are working in an environment in which Microsoft SQL Server 2008 is used for database solutions. They should have experience with the following: Defining high-availability solutions Data distribution Automating administrative...
  • Wiki Page: Exam 70-450 - PRO: Designing, Optimizing, and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

    Table of Contents Overview Skills Measured Preparation Materials Community Related Forum Posts Overview Language(s): English, French, German, Japanese, Spanish, Chinese (Simplified) Audience(s): IT Professionals Technology: Microsoft SQL Server 2008 ...
  • 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...
  • Wiki Page: Veritabanı Adını Değiştirme - Change Database Name (tr-TR)

    Bir çok yerde ismi değiştirilecek veritabanı önce single_user mode alınıp ardından isim değişikliği yapacak T-SQL kodlar paylaşılıyor. Evet, ismi değiştirilecek veritabanı adını single_user mode alıp değiştirebilirsiniz hatta SQL Server ile ilgili bir çok kaynakta Master veritabanını seçtirerek ...
Page 1 of 5 (104 items) 12345
Can't find it? Write it!