TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Microsoft Edge
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Skype for Business
See all products »
Resources
Channel 9 Video
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Windows Update
Trials
Windows Server 2016
System Center 2016
Windows 10 Enterprise
SQL Server 2016
See all trials »
Related Sites
Microsoft Download Center
Microsoft Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Expert-led, virtual classes
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
Microsoft Official Courses On-Demand
Certifications
Certification overview
Special offers
MCSE Cloud Platform and Infrastructure
MCSE: Mobility
MCSE: Data Management and Analytics
MCSE Productivity
Other resources
Microsoft Events
Exam Replay
Born To Learn blog
Find technical communities in your area
Azure training
Official Practice Tests
Support options
For business
For developers
For IT professionals
For technical support
Support offerings
More support
Microsoft Premier Online
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Home
Library
Wiki
Learn
Gallery
Downloads
Support
Forums
Blogs
Resources For IT Professionals
United States (English)
Россия (Pусский)
中国（简体中文）
Brasil (Português)
Skip to locale bar
Get this Tag RSS feed
Translate this page
Powered by
Microsoft® Translator
Popular Tags
Active Directory
AD
AD DS
adfs
ASP.NET
azure
BizTalk
BizTalk Server
BizTalk Server 2010
C#
Candidate for deletion
certification
cloud
core docs
de-DE
EAA
Ed Price
Ed's Stub Pages
en-US
ESA
es-ES
Excel
Exchange
Exchange 2010
fa-IR
Fernando Lugao Veltem
FIM
FIM 2010
FIM Resources
FIM-HELP
forefront
forums
fr-FR
Gokan Ozcifci
has code
has comment
has comments
has image
has Images
has Other Languages
has See Also
Has Table
Has TOC
Horizon_Net
How To
Hyper-V
id-ID
IIS
Italian Wiki Articles
it-IT
ja-JP
Jordano Mazzoni
Link Collection
Luciano Lima
Luigi Bruno
Lync Server 2010
MIISILMFIM MACAULAY
Multi Language Wiki Articles
needs work
operations manager
Pirated Content
Portal
Português Brasil
PowerShell
pt-BR
security
SharePoint
SharePoint 2010
SharePoint 2013
SharePoint Pirate
Small Basic
solucionando problemas
SQL Server
SQL Server 2012
stub
System Center
System Center 2012
TechNet Guru
TechNet Wiki
TechNet Wiki Featured Article
tonyso
Translated into Japanese
troubleshooting
tr-TR
vídeo
Video
Virtualization
VMM
Wiki
Windows
Windows 7
Windows 8
Windows Azure
Windows Server
Windows Server 2003
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
yottun8
اکتیو دایرکتوری
Browse by Tags
>
TechNet Articles
>
All Tags
>
SQL Server 2008
Tagged Content List
Wiki Page:
How To Find Various Day, Current Week, Two Week, Month, Quarter, Half Year and Year In SQL Server
Yagmoth555
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...
on
22 Sep 2013
Wiki Page:
SharePoint 2010: SQL Script to Backup Project Server Databases
Richard Mueller
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...
on
18 Sep 2013
Wiki Page:
MBAM Hardware and Recovery DB requires TDE on c
Richard Mueller
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...
on
17 Sep 2013
Wiki Page:
Wiki: Localizar campos nativos e customizados do EPM 2010 via SQL Server 2008 (pt-BR)
Richard Mueller
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...
on
17 Sep 2013
Wiki Page:
Solucionando Problemas: Error Failed to open loopback connection ao executar SP_READERRORLOG (pt-BR)
Richard Mueller
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...
on
17 Sep 2013
Wiki Page:
Solucionando Problemas: code 0x80071398 The operation failed because either the specified node is not the owner of the group (pt-BR)
Richard Mueller
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ó...
on
17 Sep 2013
Wiki Page:
SQL : Split Delimited Column into Multiple Columns Without External Function
Richard Mueller
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...
on
17 Sep 2013
Wiki Page:
Calendar Analytics for PowerPivot: Feature Requests & Changes
Richard Mueller
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...
on
17 Sep 2013
Wiki Page:
T-SQL Script Detach, Move, and Attach Database
Richard Mueller
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...
on
17 Sep 2013
Wiki Page:
SQL VDI Backups Fail with Error 9001
Richard Mueller
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...
on
17 Sep 2013
Wiki Page:
How to Create Query Shortcuts in SQL Server Management Studio
Richard Mueller
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...
on
17 Sep 2013
Wiki Page:
Rebuild and Re-index Database Gradually
Richard Mueller
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...
on
17 Sep 2013
Wiki Page:
Comment trouver divers jour, semaine en cours, deux semaines, mois, Quater, semestre et année dans SQL Server
Richard Mueller
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...
on
17 Sep 2013
Wiki Page:
SQL Server 2008+: Group By with Wings
Ed Price - MSFT
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...
on
7 Sep 2013
Wiki Page:
Database Engine Fixed Server and Fixed Database Roles
Maheshkumar S Tiwari
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...
on
1 Sep 2013
Wiki Page:
SQL Server 2008+: Merge (Unity is Strength - Strengthen your Performance by Merge)
Balaji M Kundalam
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...
on
31 Aug 2013
Wiki Page:
Mejores Practicas de SQL Server 2008 para SharePoint 2010 Parte I (es-ES)
Ademir Soleto
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...
on
30 Aug 2013
Wiki Page:
Mejores Prácticas de Sql Server 2008 para SharePoint 2010 Parte II (es-ES)
Ademir Soleto
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...
on
30 Aug 2013
Wiki Page:
Exam 70-452 - PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008
Ed Price - MSFT
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 ...
on
7 Aug 2013
Wiki Page:
MCITP: Business Intelligence Developer 2008
Ed Price - MSFT
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...
on
7 Aug 2013
Wiki Page:
MCITP: Database Developer 2008
Ed Price - MSFT
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...
on
7 Aug 2013
Wiki Page:
MCITP: Database Administrator 2008
Ed Price - MSFT
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...
on
7 Aug 2013
Wiki Page:
Exam 70-450 - PRO: Designing, Optimizing, and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008
Ed Price - MSFT
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 ...
on
7 Aug 2013
Wiki Page:
Star Schema
Richard Mueller
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...
on
31 Jul 2013
Wiki Page:
Veritabanı Adını Değiştirme - Change Database Name (tr-TR)
Gokan Ozcifci
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 ...
on
31 Jul 2013
Page 1 of 5 (104 items)
1
2
3
4
5
Can't find it? Write it!
Post an Article