Browse by Tags

If a clustered index will be turned into a HEAP, no reorganization of the data will occur. This "myth" is sometimes popping up in forums or blogs. A view "behind the scenes" will describe how Microsoft SQL Server is handling this operation. Before the deep dive into the internals...

Analytics for Twitter 2013 version 1.3 (Updated on November 15, 2013) is now available for download at http://husting.com/twitter-analytics-for-excel/ This version has been updated based on changes to twitter's api. This includes functionality for downloading user profile images and was built...

Select Maintenance Tasks ekranında “ Back up Database (Full)” seçeneğini seçerek sonraki (next ) ekrana geçiyoruz , Bu işlem ile birlikte Select Maintenance Task Order ekranında “Back up Database (Full)” seçerek sonraki ekrana geçiyoruz. Define Back Up Database ( Full) Task ekranında...

Bugün sanal ortamdaki stand-alone bir SQL Server 2008 sunucumuza SP2 yüklemesi yaparken yüklemenin normalden fazla uzaması beni şüphelendirdi. Hemen Windows Event loglarına baktım. Kurulum yaptığım andan itibaren alınan hata ve uyarıları inceledim. Aşağıdaki iki hata dikkatimi çekti: Hata-1:...

A little script for getting data from SQL Server with PowerShell in SharePoint 2010: $SqlConnection = New-Object System.Data.SqlClient.SqlConnection $SqlConnection . ConnectionString = "Server=SQLServer\SQLInstance;Database=DataBaseName;Integrated Security=True" $SqlConnection...

Note : Cet article est une traduction. Un petit script pour récupérer des données de SQL Server en PowerShell applicable à SharePoint 2010: $SqlConnection = New-Object System.Data.SqlClient.SqlConnection $SqlConnection . ConnectionString = "Server=SQLServer\SQLInstance;Database=DataBaseName;Integrated...

対象者 : SQL Server を利用することに馴染みがなく、SQL Server データベースを ASP.NET Web サイトに利用する方法を学習したい Web 開発者 ページ下の 外部リンク では、SQL Server と ASP.NET テクノロジーを利用するデータドリブンのアプリケーションについての情報やガイダンスを提供します。この情報では、既に ASP.NET についての知識があると仮定します。もし、ASP.NETについてまだ馴染みがなく、追加のプログラミングリソースや情報を探しているのであれば、 http://www.asp.net へ行くと良いでしょう。日本語であれば...

Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/934.how-to-use-asp-net-with-sql-server-en-us.aspx Público-alvon : desenvolvedores da Web que não estão familiarizados com o SQL Server, mas queiram aprender a usar um banco de dados SQL Server...

Destinatarios : Los desarrolladores web que no están familiarizados con SQL Server, que aún desean aprender a utilizar una base de datos SQL Server con ASP. NET . Los siguientes enlaces son enlaces externos y proporcionan información y orientación sobre cómo crear aplicaciones dinámicas controladas...

要更改的語言，請按一下此處 。 本說明將持續保持評估的狀態。您所做的任何更改將會被評估，然後 被 接受，修改，或復 原 。因為這是一個 wiki ，這些發行說明可能是由社區成員增補或修訂。要閱讀原著和官方發行說明文檔，請參閱 這裡 。 這份版本資訊文件將描述有關您安裝 SQL Server Code-Named “Denali” CTP3 ( 請按一下這裡下載 ) 之前應該閱讀的已知問題或疑難排解。此版本資訊文件僅於線上提供，安裝媒體中並不提供，且會定期更新。 如需入門及安裝 SQL Server Code-Named “Denali” 的相關資訊，請參閱 SQL Server...

We want to make information in the SQL Server product content easier to find. We want to make sure that the content is consistent, that there is the right amount of information in all areas, and that it is up-to-date. To do so, we have changed how the content is delivered and structured for Denali...

This page was created to help to provide links to key ReplTalk http://blogs.msdn.com/b/repltalk/ MSDN blog postings by the Microsoft SQL Server Replication Support Team. Transactional Replication Links for Getting Started with Transactional Replication Transactional Replication Workflow...

Table of Contents TechNet Wiki MSDN TechNet Blogs / Artigos Veja também Outras linguagens Deutsch (de-DE) Japanese (ja-JP) English (en-US) Español (es-ES) Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/984.sql-server-developer-resources-en-us...

Power View for Multidimensional Models is now available with SQL Server 2012 Service Pack 1, Cumulative Update 4. For more information, see Power View for Multidimensional Models on TechNet

This article has been moved to Office.com. See QuickStart: Learn DAX Basics in 30 Minutes .

This topic is now available on TechNet See, Create a Shared Report Data Source Connection

This topic is now available on TechNet See, Understanding Power View for Multidimensional Models

Award-Winning SQL Server Maintenance Solution for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. Backup: http://ola.hallengren.com/sql-server-backup.html Integrity...

Destinatarios : Los desarrolladores web que no están familiarizados con SQL Server, aún desea aprender a utilizar una base de datos SQL Server con sus sitios web PHP . Los siguientes enlaces son enlaces externos y proporcionan información y orientación sobre cómo...

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...

SQL11UPD05-TSCRIPT-05 This wiki is a transcript of a previously recorded video. Related content assets: Presentation: Introducing SQL Server 2012 Data Quality Services ( SQL11UPD05-DECK-03 ) Video: Introducing SQL Server 2012 Data Quality Services ( SQL11UPD05-REC-05 ) Introducing...

Overview In SQL Server Analysis Services (SSAS) , snowflake schema describes a popular data model for relational data warehouses. Similar to a star schema , a snowflake schema contains fact and dimension tables, with the fact table storing facts about business transactions and some columns...

Overview In SQL Server Analysis Services (SSAS) data warehousing and OLAP/UDM solutions, a fact is a single record, usually representing a business transaction, at the lowest level of granularity recorded in the database. Facts are composed of dimension keys and measures ; the dimension keys reference...

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...

언어를 변경하려면 여기를 클릭하십시오 . 이 릴리스 노트는 위키 문서이므로 커뮤니티 구성원들에 의해 추가 혹은 변경될 수 있습니다 . 릴리스 노트는 면밀하고 신중하게 점검됩니다 . 변경하신 사항은 곧바로 승인되거나 다듬어지며 , 경우에 따라 취소될 수도 있습니다 . 원본 공식 릴리스 노트를 보려면 여기 를 클릭하십시오 . 이 릴리스 정보 문서에서는 SQL Server 2008 R2 SP1을 설치하거나 문제를 해결하기 전에 읽어야 할 알려진 문제에 대해 설명합니다. SQL Server 2008 R2 서비스 팩 1( 다운로드하려면...