資料技術News

SQL Server Database Engine BlogSQL Server Query Processing TeamSQL Programmability & API DevelopmentMicrosoft SQL Server Support Blog

• Our new Azure SQL Database blog site is live

, 2019/03/29 05:08:08

• Identify log write limits on Azure SQL Managed Instance using QPI library

, 2019/03/11 15:12:34

• Running Azure CosmosDB queries from SQL Server using ODBC driver

, 2019/03/11 11:45:01

• Monitor local storage usage on General Purpose Azure SQL Managed Instance

, 2019/03/08 16:30:55

• Sending resource alerts on Managed Instance using db_mail

, 2019/03/06 15:10:52

• Analyzing wait statistics on Managed Instance

, 2019/03/05 14:56:13

• Reduced recompilations for workloads using temporary tables across multiple scopes

, 2019/03/04 21:55:21

• Measuring file io performance on Managed Instance using QPI

, 2019/03/04 18:39:37

• We are moving!

, 2019/03/04 18:21:47

• Azure Stream Analytics now supports Azure SQL Database as reference data input

, 2019/02/05 00:35:13

• Mystery of memory fraction in Showplan XML

, 2010/03/12 02:34:00

• Understanding SQL server memory grant

, 2010/02/16 18:53:00

• Understanding SQL Server Fast_Forward Server Cursors

, 2009/08/13 04:38:00

• Distinct Aggregation Considered Harmful

, 2008/09/23 00:47:00

• Store Statistics XML in database tables using SQL Traces for further analysis.

, 2007/06/01 20:51:00

• Index Build strategy in SQL Server - Part 4-2: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)

, 2007/05/14 08:15:00

• Index Build strategy in SQL Server - Part 4-1: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)

, 2007/05/08 22:56:00

• How to Check Whether the Final Query Plan is Optimized for Star Join Queries?

, 2007/04/09 22:52:00

• Hash Warning SQL Profiler Event

, 2007/02/02 06:18:00

• Index Build strategy in SQL Server - Part 3: Offline Serial/Parallel Partitioning (Aligned partitioned parallel index build)

, 2007/01/20 04:20:00

• Interesting issue with Filtered indexes.

, 2009/06/29 23:56:00

• Why did the size of my indexes expand when I rebuilt my indexes?

, 2009/05/18 21:57:00

• SQL Server 2005 / 2008 table partitioning : Important things to consider when switching-out partitions.

, 2009/04/11 00:43:00

• Avoid using JDK Date APIs to handle timezone sensitive date and time

, 2009/03/27 01:30:00

• Zeroing in on blocking on seemingly unrelated tables

, 2009/02/02 21:20:00

• Using SQL Server 2008 Management Data Warehouse for database monitoring in my application

, 2009/01/29 19:19:00

• OPTIMIZE FOR UNKNOWN – a little known SQL Server 2008 feature

, 2008/11/27 01:35:00

• SQL Server 2008 : new binary – hex string conversion functionality can dramatically improve related query performance by orders of magnitude.

, 2008/11/01 00:49:00

• How to create an autonomous transaction in SQL Server 2008

, 2008/08/23 00:54:00

• UPDATE with OUTPUT clause – Triggers – and SQLMoreResults

, 2008/07/12 00:51:00

• Azure Analysis Services – How to use a different user account in reporting and development tools

, 2017/01/26 02:19:55

• Azure Analysis Services – How to switch to a different user account in reporting tools

, 2017/01/25 12:08:03

• Azure Analysis Services processing/refresh sample AMO code

, 2017/01/25 11:57:46

• SSAS processing performance gain by using OLE DB provider for Oracle instead of using .NET provider for Oracle

, 2017/01/25 11:51:51

• Azure Analysis Services Preview shows workspace databases not being deleted

, 2017/01/25 07:00:01

• Azure Analysis Services Preview -How to add security group

, 2017/01/25 06:47:28

• Azure Analysis Services connection error “The connection string is not valid”

, 2017/01/25 06:01:25

• Client unable to establish connection.. error when you configure ‘max server memory’ to a low value

, 2016/08/25 00:28:19

• You are not able to start more than 4 SSAS tabular model instances with default configuration settings

, 2016/07/28 03:49:30

• Excel 2016 PivotTable timeout error on SSAS data source after 1 minute

, 2016/06/11 00:35:50