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
830

Query Execution Timeouts in SQL Server (Part 2 of 2)

SQL-Server-Team on Mar 23 2019 04:43 AM
First published on MSDN on Nov 22, 2006 Checklist for time out errors Memory pressure: In most cases timeouts are caused...
319

Index Build strategy in SQL Server - Part 1: offline, serial, no partitioning

SQL-Server-Team on Mar 23 2019 04:43 AM
First published on MSDN on Nov 20, 2006 Builder (write data to the in-build index) | Sort (order by index key) | Scan (r...
1,080

Parallel Hash Join

Craig_Freedman on Mar 23 2019 04:42 AM
First published on MSDN on Nov 16, 2006 SQL Server uses one of two different strategies to parallelize a hash join.
2,096

Query Execution Timeouts in SQL Server (Part 1 of 2)

SQL-Server-Team on Mar 23 2019 04:42 AM
First published on MSDN on Nov 14, 2006 This short article provides a checklist for query execution time out errors in Y...
275

Index Build strategy in SQL Server - Introduction (II)

SQL-Server-Team on Mar 23 2019 04:42 AM
First published on MSDN on Nov 09, 2006 - Building Partitioned Index vs.
1,092

Parallel Nested Loops Join

Craig_Freedman on Mar 23 2019 04:42 AM
First published on MSDN on Nov 08, 2006 SQL Server parallelizes a nested loops join by distributing the outer rows (i.
379

Index Build strategy in SQL Server - Introduction (I)

SQL-Server-Team on Mar 23 2019 04:41 AM
First published on MSDN on Nov 08, 2006 Index Build strategy in SQL Server may vary depending on users needs.
1,046

Parallel Scan

Craig_Freedman on Mar 23 2019 04:41 AM
First published on MSDN on Nov 02, 2006 In this post, I’m going to take a look at how SQL Server parallelizes scans.
5,322

Intro to Query Execution Bitmap Filters

SQL-Server-Team on Mar 23 2019 04:40 AM
First published on MSDN on Oct 27, 2006 One of the least understood Query Execution operators is the Bitmap.
2,113

The Parallelism Operator (aka Exchange)

Craig_Freedman on Mar 23 2019 04:40 AM
First published on MSDN on Oct 25, 2006 As I noted in my Introduction to Parallel Query Execution post, the parallelism ...
1,201

Index Union

Craig_Freedman on Mar 23 2019 04:39 AM
First published on MSDN on Oct 18, 2006 I was planning to continue writing about parallelism this week (and I will conti...
656

What's this cost?

SQL-Server-Team on Mar 23 2019 04:39 AM
First published on MSDN on Oct 11, 2006 Oftentimes when people include actual execution plan (Ctrl-M, see previous posts...
11.1K

Introduction to Parallel Query Execution

SQL-Server-Team on Mar 23 2019 04:39 AM
First published on MSDN on Nov 06, 2006 SQL Server has the ability to execute queries using multiple CPUs simultaneously...
932

Introduction to Parallel Query Execution

Craig_Freedman on Mar 23 2019 04:38 AM
First published on MSDN on Oct 11, 2006 SQL Server has the ability to execute queries using multiple CPUs simultaneously...
1,633

Viewing and Interpreting XML Showplans

SQL-Server-Team on Mar 23 2019 04:38 AM
First published on MSDN on Oct 06, 2006 As mentioned in our previous blog posting, SQL Server 2005 supports Showplan gen...
1,070

Decorrelating Subqueries

Craig_Freedman on Mar 23 2019 04:38 AM
First published on MSDN on Oct 04, 2006 In my previous post, we saw some examples where the optimizer is able to take a ...
1,427

Introduction to Showplan

SQL-Server-Team on Mar 23 2019 04:37 AM
First published on MSDN on Sep 29, 2006 Showplan is a feature in SQL Server to display and read query plans.
1,821

Scalar Subqueries

Craig_Freedman on Mar 23 2019 04:36 AM
First published on MSDN on Sep 27, 2006 A scalar subquery is a subquery that returns a single row.
4,523

Hash Aggregate

Craig_Freedman on Mar 23 2019 04:36 AM
First published on MSDN on Sep 20, 2006 In my prior two posts, I wrote about the stream aggregate operator.
1,304

Stream Aggregate

Craig_Freedman on Mar 23 2019 04:35 AM
First published on MSDN on Sep 13, 2006 There are two physical operators that SQL Server uses to compute general purpose...
398

Aggregation

Craig_Freedman on Mar 23 2019 04:35 AM
First published on MSDN on Sep 06, 2006 Aggregation refers to the collapse of a larger set of rows into a smaller set of...
445

Subqueries: ANDs and ORs

Craig_Freedman on Mar 23 2019 04:34 AM
First published on MSDN on Aug 30, 2006 In my “Introduction to Joins” post, I gave an example of how we can use a semi-j...
11K

Subqueries in CASE Expressions

Craig_Freedman on Mar 23 2019 04:34 AM
First published on MSDN on Aug 23, 2006 In this post, I’m going to take a look at how SQL Server handles subqueries in C...
517

Summary of Join Properties

Craig_Freedman on Mar 23 2019 04:34 AM
First published on MSDN on Aug 16, 2006 The following table summarizes the characteristics of the three physical join op...
3,351

Hash Join

Craig_Freedman on Mar 23 2019 04:34 AM
First published on MSDN on Aug 10, 2006 When it comes to physical join operators, hash join does the heavy lifting.
962

Merge Join

Craig_Freedman on Mar 23 2019 04:33 AM
First published on MSDN on Aug 03, 2006 In this post, I’ll describe the second physical join operator: merge join (MJ).
4,008

Nested Loops Join

Craig_Freedman on Mar 23 2019 04:33 AM
First published on MSDN on Jul 26, 2006 SQL Server supports three physical join operators: nested loops join, merge join...
484

Introduction to Joins

Craig_Freedman on Mar 23 2019 04:32 AM
First published on MSDN on Jul 19, 2006 Joins are one of the most important operations performed by a relational databas...
1,048

Index Examples and Tradeoffs

Craig_Freedman on Mar 23 2019 04:31 AM
First published on MSDN on Jul 13, 2006 The optimizer must choose an appropriate “access path” to read data from each ta...
4,783

Seek Predicates

Craig_Freedman on Mar 23 2019 04:31 AM
First published on MSDN on Jul 07, 2006 Before SQL Server can perform an index seek, it must determine whether the keys ...

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