Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

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

  • Wiki Page: 善用 SQL Server Management Studio 選項設定DB作業環境 (zh-TW)

    我們每天與 SQL Server 資料庫為伍，絕對不能跟 Management Studio 不熟，就像我們一般日常做程式開發時一樣，開發工具的「選項」設定多少都會調整一下方便我們工作。但是工作環境切換到 Management Studio 之後我卻發現許多人不知道要善用 Management Studio 的 [選項] 設定，今天我就來分享一些我常用的 [選項] 設定值 (非預設值)。 [環境] / [鍵盤] → 將常用的 DB 管理作業(預儲程序)設定成快速鍵 如下圖所示，我之前有寫過一支 在 SQL Server 2005 中取得所有欄位定義的方法(含備註欄位...
    on3 Oct 2011

  • Wiki Page: 如何變更 SQL Server 預設的資料檔路徑與備份檔路徑 (zh-TW)

    當你安裝好 SQL Server 2005/2008 之後，通常相關檔案的預設安裝路徑都會在 C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL 目錄下，而該目錄下有兩個很重要的目錄，分別是 DATA (資料檔儲存目錄) 與 Backup (備份檔儲存目錄)，如果你希望將這些重要檔案儲存在其他磁碟機時，直接透過 SQL Server Management Studio (SSMS) 就可以修改 DATA (資料檔儲存目錄) 的預設路徑，不過卻無法透過 SSMS 修改預設備份檔的路徑。 我個人的開發環境 C 磁碟機已經只剩下 1GB 了，所以每次在開資料庫的時候...
    on3 Oct 2011

  • Wiki Page: Report Builder Error: Failed to Preview Report, Item not found (RB3)

    Table of Contents Background: Work Around: Applies to: See Also External Links Background: When you try to preview a report inside Report Builder 3.0 you may see an error message similar to "Failed to preview report. The item [path to server] cannot be found. See the attached image for the...
    on1 Oct 2011

  • Wiki Page: How to Move the Site Database in System Center Configuration Manager 2007

    INTRODUCTION This article describes how to move the Site Database in Microsoft System Center Configuration Manager 2007 from a computer that is running Microsoft SQL Server 2005 to another drive on the same computer, or to another computer that is running SQL Server 2005. MORE INFORMATION In...
    on1 Sep 2011

  • Wiki Page: SQL Azure and SQL Server

    test test test test
    on16 Aug 2011

  • Wiki Page: SQL Azure: Test Article

    test test test
    on16 Aug 2011

  • Wiki Page: Sync Framework: SQL Server to SQL Azure synchronization number 2

    Testing URL
    on4 Aug 2011

  • Wiki Page: SQL 2k8 - Mirror Media - (pt-BR)

    Jordano Mazzoni Twitter: @jordanomazzoni Site: http://jmazzoni.wordpress.com/ Canal: http://www.youtube.com/JmazzoniAJU Acompanhe o restante da série no site ou seguindo-me no twitter..!!! Grande abraço Jordano Mazzoni
    on11 Jul 2011

  • Wiki Page: SQL 2k8 - Maintenance Plan Console - (pt-BR)

    Jordano Mazzoni Twitter: @jordanomazzoni Site: http://jmazzoni.wordpress.com/ Canal: http://www.youtube.com/JmazzoniAJU Acompanhe o restante da série no site ou seguindo-me no twitter..!!! Grande abraço Jordano Mazzoni
    on11 Jul 2011

  • Wiki Page: SQL 2k8 - Maintanence Plan Basico - (pt-BR)

    Jordano Mazzoni Twitter: @jordanomazzoni Site: http://jmazzoni.wordpress.com/ Canal: http://www.youtube.com/JmazzoniAJU Acompanhe o restante da série no site ou seguindo-me no twitter..!!! Grande abraço Jordano Mazzoni
    on11 Jul 2011

  • Wiki Page: 如何比對兩個表格中的資料是否相等 (zh-TW)

    微軟在SQL Server 2005 有出一個 tablediff 公用程式 ，可以用來比較兩份資料表的資料是否一致，如果不一致的時候會幫你產生更新的 SQL 檔，幫你再目的地的表格執行INSERT,UPDATE或DELETE以進行同步動作，因為這是一支DOS介面的程式，您可以在命令提示字元之下，或是在批次檔中寫好相關的指令、參數，然後每天定時執行即可。 這工具有個缺點，就是在進行比對的過程中預設來說不會對 text、ntext、image、varchar(max)、nvarchar(max) 和 varbinary(max) 進行比對與更新，這點還蠻討厭的，因為應該有蠻多表格中可能包含這些欄位的...
    on6 Jul 2011

  • Wiki Page: SSIS with SAP Connectors

    SAP AG ( Systeme, Anwendungen und Produkte in der Datenverarbeitung ("Systems, Applications And Products in Data Processing"), based in Walldorf-Germany, is the largest business application and Enterprise Resource Planning (ERP) solution software provider in terms of revenue. SAP's...
    on4 May 2011

  • Wiki Page: Como Criar o CUBO OLAP do Project Server 2007 – SQL Server 2000, SQL Server 2005 e SQL Server 2008 (pt-BR)

    Vendo nosso relatório de acessos e as origens dos mesmos, percebi que tem MUITA gente com problema para criar o cubo. Então vai aí os únicos 3 links que você vai precisar para criar o cubo no SQL Server, nas três versões, sem problemas: Como Criar o CUBO...
    on21 Mar 2011

  • Wiki Page: SSIS with Unstructured and Semi-Structured Excel, CSV Data

    Data captured in Excel and CSV reports, which are meant to be read by the human eye instead of by an automated process, represents a challenge to those who need to load it into the SSIS pipeline. These data sources typically include factual data and metadata, which gives context to the facts. Below...
    on21 Dec 2010

  • Wiki Page: SSIS with Sybase Connectors

    Connectors for Sybase ASE By Name Data Access API Supported Sybase Versions 64 bit Metadata support Provider Notes FAQ DataDirect Connect64 for SSIS Ole DB 11.x, 12.x, and 15.0 ...
    on21 Dec 2010

  • Wiki Page: SSIS - Microsoft SQL Server Connectors

    Microsoft SQL Server Connectors By Name Data Access API Supported SQL Versions 64 bit Metadata support FAQ Microsoft SqlClient Data Provider .NET ALL yes table/view/parameter...
    on21 Dec 2010
Page 31 of 31 (766 items) «2728293031
Can't find it? Write it!

Post an Article