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 2012
Tagged Content List
Wiki Page:
Demo Transcript: Configuring SQL Server 2012 AlwaysOn Failover Clustering
Naomi N
SQL11UPD01-TSCRIPT-08 This wiki is a transcript of a previously recorded video. Related content assets: Demo: Configuring SQL Server 2012 AlwaysOn Failover Clustering ( SQL11UPD01-DEMO-04 ) Video: Configuring SQL Server 2012 AlwaysOn Failover Clustering ( SQL11UPD01-REC-08 ) Configuring...
on
22 Sep 2013
Wiki Page:
How to Compare Two Tables Definition / Metadata in Different Databases
Naomi N
This article is about the example on T-SQL Script to compare two tables definition / metadata in different databases . The T-SQL Script [used to compare two tables definition / metadata in different databases] in this article can be used from SQL Server 2012 and above version because I have used...
on
22 Sep 2013
Wiki Page:
SQL Server 2012
Yagmoth555
Microsoft® SQL Server™ is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. In this wiki, you will find articles related to SQL Server 2012 by Features, Server Component or Management tools. You can find the full SQL Server Help documentation...
on
22 Sep 2013
Wiki Page:
How to Check the Syntax of Dynamic SQL Before Execution
Naomi N
This article is about the system function sys.dm_exec_describe_first_result_set that can be used to check the syntax of dynamic SQL before execution. This system function sys.dm_exec_describe_first_result_set was introduced in SQL Server 2012. Create sample table and insert sample data : ...
on
22 Sep 2013
Wiki Page:
How to Put a Sequence in a Column Already filled
Yagmoth555
Suppose we would like to create a sequence in a table already filled with data. I found out this solution to be pretty easy: CREATE TABLE SEQ (COK NVARCHAR( 10 )) insert into seq values ( 'York' ),( 'Boston' ),( 'Chicago' ) select * from seq --step 1 , I create a table...
on
22 Sep 2013
Wiki Page:
SQL Server Columnstore Index FAQ
Yagmoth555
The SQL Server xVelocity memory-optimized columnstore index stores data by columns instead of by rows, similar to a column-oriented DBMS. The columnstore index speeds up data warehouse query processing in SQL Server 2012 through the current version, in many cases by a factor of 10 to 100. We'll...
on
22 Sep 2013
Wiki Page:
SQL Server Columnstore Performance Tuning
Yagmoth555
Table of Contents Introduction Fundamentals of Columnstore Index-Based Performance DOs and DON'Ts for using Columnstores Effectively Maximizing Performance and Working Around Columnstore Limitations Ensuring Use of the Fast Batch Mode of Query Execution Physical Database Design, Loading, and Index...
on
22 Sep 2013
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:
Microsoft SQL Server 2012 New Functions
Yagmoth555
EOMONTH We had a problem whenever we wanted to identify the end date of a month. There was no built in function. But now that problem is solved in SQL Server 2012. The function EOMONTH returns the date of the month. SELECT EOMONTH (‘05/02/2012’) ‘EOM Processing Date Output: 2012-02-29...
on
22 Sep 2013
Wiki Page:
SharePoint 2013: Maximizing SQL Server 2012 Performance ( Free WhitePaper)
Yagmoth555
Hello Everyone, For the past few weeks I was writing a Whitepaper about maximizing SQL 2012 Performance for SharePoint 2013. It’s been reviewed by 4 great guys , and after being exclusive to SharePoint-Community.net for one week, I release it to the public! Read the abstract or download the Whitepaper...
on
22 Sep 2013
Wiki Page:
Microsoft Learning Training and Certification - SQL Server 2012
Yagmoth555
MSL Training Portal: http://www.microsoft.com/learning/en/us/training/sql-server.aspx Courses: The SQL Server 2012 courses are designed to enable database professionals to take full advantage of SQL Server 2012 and if they choose to validate their skills with certification...
on
22 Sep 2013
Wiki Page:
AD RMS (Windows Server 2008 R2) and SQL Server 2012 Install Steps
Yagmoth555
Adding AD RMS on Windows Server 2008 R2 with a SQL Server 2012 backend is supported, but a hotfix (KB2619256) must be installed. The problem is that the hotfix will only install after some of the AD RMS components are installed. To get around this "Catch 22" situation, you can install using...
on
22 Sep 2013
Wiki Page:
SharePoint - Best Practices de performance : Limiter l'allocation mémoire de SQL Server (fr-FR)
Benoit Jester
J'ai vu p lusieurs fois des développeurs se plaindre des performances de leur environnement de développement SharePoint. Comme ils ont une installation "standalone" de SharePoint sur leur machine virtuelle de développement, ils se plaignent toujours que leur machine est trop lente....
on
21 Sep 2013
Wiki Page:
SharePoint Performance Best Practices: Limit SQL Server Memory Allocation
Benoit Jester
Many times I have seen developers complaining about their SharePoint development environment performance. Since they have SharePoint standalone installation on their development Virtual Machine they always complain their machine is too slow. This is not only the case with development environment...
on
21 Sep 2013
Wiki Page:
SQL Server 2012 Developer Training Kit BOM
Yagmoth555
Table of Contents Overview Day 1: Introduction and Database Engine Topics Module 1: Introduction to SQL Server 2012 Module 2: Introduction to SQL Server AlwaysOn Module 3: Exploring and Managing SQL Server 2012 Database Engine Improvements Module 4: SQL Server 2012 Database Server Programmability Day...
on
20 Sep 2013
Wiki Page:
SQL Server Samples Readme
Yagmoth555
The SQL Server 2012 samples provide a variety of databases and files that you can use to learn about new and existing features. This article is the consolidated Readme for each sample in the SQL Server 2012 release. It provides prerequisite information, installation instructions, and links...
on
20 Sep 2013
Wiki Page:
Buscar Valores en una base de datos desde InfoPath 2010 programáticamente. (es-ES)
Ademir Soleto
Para realizar búsquedas en una base datos desde InfoPath en 3 pasos. 1. Crea la tabla en la base de datos donde tienes toda la información 2. Crea un formulario en InfoPath con los campos que necesita extraer de la base de datos. 3. Finalmente agregue el siguiente código en el botón buscar...
on
18 Sep 2013
Wiki Page:
Using TRY_CONVERT in SQL Server 2012
Naomi N
Using TRY_CONVERT in SQL Server 2012 TRY_CONVERT returns the value as the specified data_type; if an error occurs, null is returned. However if you request a conversion that is explicitly not permitted, then TRY_CONVERT fails with an error. TRY_CONVERT conversion function is supported in SQL...
on
17 Sep 2013
Wiki Page:
How to convert Unicode Data to ASCII and back in SQL server
Yagmoth555
Product Targeted MS SQL Server 2012 Summary In SQL server, few specific data handling scenarios require Unicode source data to be moved to non-Unicode destination format like ASCII format. During data conversion, it can be observed that the Unicode characters getting converted to ‘?...
on
17 Sep 2013
Wiki Page:
Perform Scalar Aggregates and Still get the Benefit of Batch Processing
Yagmoth555
Scalar aggregates, (aggregates without a GROUP BY clause, like SELECT COUNT(*) from T ) are simple, but ironically they don't work with the CPU-saving batch mode of query execution with columnstore indexes in SQL Server 2012 RTM. Rest assured we're working already to make them run in batch...
on
17 Sep 2013
Wiki Page:
Troubleshoot Installation and Configuration Issues (Master Data Services in SQL Server 2012)
Yagmoth555
When you install and configure Master Data Services (MDS) in SQL Server 2012, you might encounter any of the following issues. Fixing an MDS installation in a cluster Error when connecting to a remote database server Database creation fails when user account cannot be resolved Database...
on
17 Sep 2013
Wiki Page:
MVC 4.5 Areas and SQL Server 2012 Schemas Dichotomy
Yagmoth555
Using Areas in MVC 4.5 can be hazardous to your health if you are starting out. My original Idea for a model in SQL 2012 was to create some schemas. In each schema name I had worked out a way to separate out some important business functionality in discrete business units like so: Finances, Inventory...
on
17 Sep 2013
Wiki Page:
SQL Server 2012 Log Shipping Yapılandırması (tr-TR)
Richard Mueller
on
17 Sep 2013
Wiki Page:
SharePoint 2010: Windows Server 8 üzerine SharePoint 2010'u SQL 2012 ile nasil yüklerim
Richard Mueller
Table of Contents 1. Downloads Windows Server 8 2. Install Process: Server 8 3. Install Process: SQL 4. Install Process: SharePoint 1. Downloads Windows Server 8 ISO Windows Developer Preview with developper tools (64 bits) ISO Windows Developer Preview 64 bits Microsoft...
on
17 Sep 2013
Wiki Page:
SharePoint 2010: Hoe kunnen wij SharePoint 2010 met SQL 2012 op Windows 8 installeren? (nl-NL)
Richard Mueller
Table of Contents Other Languages In dit artikel beschrijf ik hoe je SharePoint 2010 samen met SQL 2012 op Windows 8 kan installeren. 1. Downloads Windows Server 8 ISO Windows Developer Preview with developper tools (64 bits) ISO Windows Developer Preview 64 bits Microsoft...
on
17 Sep 2013
Page 1 of 11 (263 items)
1
2
3
4
5
»
Can't find it? Write it!
Post an Article