cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Server Blog
Options
2,404

Packed/Batched Transact-SQL (TSQL) RPC Invocation

BobDorr on Oct 26 2023 07:50 AM
Discusses TSQL Packed/Batched RPCs.
5,480

I/O optimizations for tempdb in SQL Server and Azure SQL

bobward on Aug 08 2023 08:24 AM
Tempdb optimizes log flushes and disk writes in Microsoft SQL.
3,062

Trace Flag 8904 - Disable Inline Database Log Flushes

BobDorr on Dec 12 2022 08:20 AM
Do you need to disable inline database log flush activity?
5,648

New In SQL Server 2022 and Azure SQL: XEvent Performance Metrics

MitchellSternke on Nov 28 2022 01:21 PM
Starting in SQL Server 2022 you can view the performance impact of your XEvent sessions.
7,796

HOW IT WORKS: SQL Server Scheduler Affinity

BobDorr on Feb 05 2022 09:25 AM
SQL Server affinity capabilities discussed.
1,667

How It Works: XEvent String Comparison Performance Tip

BobDorr on Feb 05 2022 08:52 AM
Improving performance when using XEvent string comparison predicates.
4,115

SQL Server and Microsoft Purview work better together

MarisaMathews on Oct 21 2021 06:03 AM
Learn how to register and scan your SQL server in Microsoft Purview then dive in on features.
2,198

The “Balanced Data Distributor” for SSIS

SQL-Server-Team on Mar 23 2019 12:12 PM
First published on MSDN on May 25, 2011 The “Balanced Data Distributor” for SSISLen Wyatt, SQL Server Performance TeamTh...
4,344

Using SSIS to get data out of Oracle: A big surprise!

SQL-Server-Team on Mar 23 2019 11:18 AM
First published on MSDN on Aug 14, 2009 Since late last year, Microsoft has made the Attunity connectors to Oracle datab...
473

An ETL World Record Revealed (Finally)

SQL-Server-Team on Mar 23 2019 11:13 AM
First published on MSDN on Mar 03, 2009 We suppose a more appropriate title would have been: Better Late Than Never.
291

SQL Server is Movin' On Up!

SQL-Server-Team on Mar 23 2019 11:06 AM
First published on MSDN on Nov 10, 2008 At last week's WinHEC in Los Angeles, SQL GM Quentin Clark joined Windows Server...
1,000

TPC-E – Raising the Bar in OLTP Performance

SQL-Server-Team on Mar 23 2019 11:04 AM
First published on MSDN on Oct 23, 2008 Glenn Paulley, Director of Engineering at Sybase iAnywhere, posted a commentary ...
1,436

ETL World Record!

SQL-Server-Team on Mar 23 2019 05:14 AM
First published on MSDN on Feb 27, 2008 Today at the launch of SQL Server 2008, you may have seen the references to worl...
682

Spool operators in query plan...

SQL-Server-Team on Mar 23 2019 05:07 AM
First published on MSDN on Aug 30, 2007 I came across a question in the relationalserver.
530

What's swimming in your bufferpool?

SQL-Server-Team on Mar 23 2019 05:01 AM
First published on MSDN on May 18, 2007 When doing a performance investigation a useful thing to do is look at what data...
1,986

Adjust buffer size in SSIS data flow task

SQL-Server-Team on Mar 23 2019 05:00 AM
First published on MSDN on May 11, 2007 The data flow task in SSIS (SQL Server Integration Services) sends data in serie...
9,153

Implement Parallel Execution in SSIS

SQL-Server-Team on Mar 23 2019 05:00 AM
First published on MSDN on May 11, 2007 SQL Server Integration Services (SSIS) allows parallel execution in two differen...
414

Something about SSIS Performance Counters

SQL-Server-Team on Mar 23 2019 04:58 AM
First published on MSDN on May 01, 2007 SQL Server Integration Services provide a set of performance counters.
6,167

Set BLOBTempStoragePath and BufferTempStoragePath to Fast Drives

SQL-Server-Team on Mar 23 2019 04:58 AM
First published on MSDN on May 01, 2007 BLOBTempStoragePath and BufferTempStoragePath are two properties on Data Flow Ta...
530

Set up OLE DB source to read from View efficiently

SQL-Server-Team on Mar 23 2019 04:57 AM
First published on MSDN on Apr 29, 2007 IntroductionOLE DB source adapter is one of the most commonly used components in...
2,204

Getting Optimal Performance with Integration Services Lookups

SQL-Server-Team on Mar 23 2019 04:56 AM
First published on MSDN on Apr 24, 2007 Introduction Most users see good performance from SSIS packages using out-of-the...
333

What’s so temporary about tempdb?

SQL-Server-Team on Mar 23 2019 04:54 AM
First published on MSDN on Apr 13, 2007 Other than #temptables, @localvariables and many other objects being stored in t...
536

Microbenchmarking

SQL-Server-Team on Mar 23 2019 04:54 AM
First published on MSDN on Apr 09, 2007 Microbenchmarking is the art of testing your machine's basic configuration like ...
377

Two handy papers on common database performance considerations

SQL-Server-Team on Mar 23 2019 04:52 AM
First published on MSDN on Mar 23, 2007 Len posted recently the link to the new Analysis Services performance guide.
510

High Volume Update Performance

SQL-Server-Team on Mar 23 2019 04:51 AM
First published on MSDN on Feb 16, 2007 SQL Server does a great job of optimizing processing across a wide range of runt...

Latest Comments

mbourgon_optum
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 23 2024 07:24 AM
Yeah, double+ agree on the whole "without AG awareness, both are pretty useless". Sounds amazing, but practically I can't use it. Dammit.
0 Likes
skusen
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 22 2024 08:27 AM
@SivertSolem I built out a bunch of automation around this using functions from dbatools. As far as automatic like this, I don't know of anything that exists.
1 Likes
AnabilSaha
in SQL Server Licensing: High Availability and Disaster Recovery benefits on Apr 20 2024 11:36 AM
Hello Mr Banerjee. It's a really very helpful video. I have a real time scenario can you please suggest me what is your view on that ?In my current production server an architecture was decided that is going to have 2 vms for db server where 1 will be primary and 2nd will be secondary. But suddenly ...
0 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 11:54 AM
@DavidYorkshire Following up on your statement that WSUS isn't consistently for updates, with the example that new versions of Windows OS have been available through WSUS for years. Correct. You can update from Windows 8 -> 8.1 ->10 -> 11, or Windows Server 2016 -> 2019 -> 2022 and presumably -> 202...
0 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 07:13 AM
@sgtmango333 We don't overwrite settings with any upgrade (minor or major). You have to import settings from a previous version to update them. We understand there is additional effort related to connection settings with SSMS 20 - that is why we shared information about the release in advance and no...
0 Likes