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,406

Packed/Batched Transact-SQL (TSQL) RPC Invocation

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

Mystery of memory fraction in Showplan XML

SQL-Server-Team on Mar 23 2019 11:27 AM
First published on MSDN on Mar 11, 2010 If you examine Showplan XML, you may find an entry like on some operators .
40.2K

Understanding SQL server memory grant

SQL-Server-Team on Mar 23 2019 11:25 AM
First published on MSDN on Feb 16, 2010 This article describes how query memory grant works in Microsoft SQL Server.
1,514

More on Implicit Conversions

Craig_Freedman on Mar 23 2019 11:23 AM
First published on MSDN on Jan 20, 2010 Yesterday, a reader posted a question asking me to comment on SQL Server's algor...
17.4K

Understanding SQL Server Fast_Forward Server Cursors

SQL-Server-Team on Mar 23 2019 11:18 AM
First published on MSDN on Aug 12, 2009 SQL Server's server cursor model is a critical tool to many application writers.
624

Correction to my prior post on sys.dm_db_index_operational_stats

Craig_Freedman on Mar 23 2019 11:18 AM
First published on MSDN on Jul 29, 2009 In this post about the sys.
2,687

Maximum Row Size and Query Hints

Craig_Freedman on Mar 23 2019 11:17 AM
First published on MSDN on Jun 24, 2009 In my last post (yes, that was two months ago), I gave an example of how a query...
1,406

Implied Predicates and Query Hints

Craig_Freedman on Mar 23 2019 11:16 AM
First published on MSDN on Apr 28, 2009 In this post, I want to take a look at how two seemingly unrelated features of S...
4,581

OPTIMIZED Nested Loops Joins

Craig_Freedman on Mar 23 2019 11:14 AM
First published on MSDN on Mar 18, 2009 In my past two posts, I explained how SQL Server may add a sort to the outer sid...
765

Optimizing I/O Performance by Sorting – Part 2

Craig_Freedman on Mar 23 2019 11:13 AM
First published on MSDN on Mar 04, 2009 In my last post, I discussed how SQL Server can use sorts to transform random I/...
1,481

Optimizing I/O Performance by Sorting – Part 1

Craig_Freedman on Mar 23 2019 11:12 AM
First published on MSDN on Feb 25, 2009 In this post from last year, I discussed how random I/Os are slower than sequent...
4,359

What is the difference between sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats?

Craig_Freedman on Mar 23 2019 11:04 AM
First published on MSDN on Oct 30, 2008 SQL Server includes two DMVs - sys.
1,298

Random Prefetching

Craig_Freedman on Mar 23 2019 11:04 AM
First published on MSDN on Oct 07, 2008 In my last post, I explained the importance of asynchronous I/O and described ho...
1,516

Sequential Read Ahead

Craig_Freedman on Mar 23 2019 11:03 AM
First published on MSDN on Sep 23, 2008 Balancing CPU and I/O throughput is essential to achieve good overall performanc...
834

Distinct Aggregation Considered Harmful

SQL-Server-Team on Mar 23 2019 11:03 AM
First published on MSDN on Sep 22, 2008 Distinct aggregation (e.
732

Dynamic Partition Elimination Performance

Craig_Freedman on Mar 23 2019 11:01 AM
First published on MSDN on Aug 22, 2008 In this post on partitioned tables, I mentioned that SQL Server 2008 has a much ...
899

Partitioned Indexes in SQL Server 2008

Craig_Freedman on Mar 23 2019 11:00 AM
First published on MSDN on Aug 05, 2008 In my last post, I looked at how SQL Server 2008 handles scans on partitioned ta...
1,034

Partitioned Tables in SQL Server 2008

Craig_Freedman on Mar 23 2019 10:58 AM
First published on MSDN on Jul 15, 2008 In this post, I introduced how SQL Server 2005 implements query plans on partiti...
7,246

Subqueries in BETWEEN and CASE Statements

Craig_Freedman on Mar 23 2019 10:57 AM
First published on MSDN on Jun 27, 2008 Consider the following query:CREATE TABLE T1 (A INT, B1 INT, B2 INT)CREATE TABLE...
2,214

Implicit Conversions

Craig_Freedman on Mar 23 2019 05:22 AM
First published on MSDN on Jun 05, 2008 In my last couple of posts, I wrote about how explicit conversions can lead to e...
668

Query Processing Presentation

Craig_Freedman on Mar 23 2019 05:21 AM
First published on MSDN on May 15, 2008 Last week, I had the opportunity to talk to the New England SQL Server Users Gro...
675

Conversion and Arithmetic Errors

Craig_Freedman on Mar 23 2019 05:20 AM
First published on MSDN on Apr 28, 2008 Let's take a look at a simple query:CREATE TABLE T1 (A INT, B CHAR(8))INSERT T1 ...
2,627

Ranking Functions: RANK, DENSE_RANK, and NTILE

Craig_Freedman on Mar 23 2019 05:19 AM
First published on MSDN on Mar 31, 2008 In my previous post, I discussed the ROW_NUMBER ranking function which was intro...
988

Ranking Functions: ROW_NUMBER

Craig_Freedman on Mar 23 2019 05:16 AM
First published on MSDN on Mar 19, 2008 SQL Server 2005 introduced four new functions, ROW_NUMBER, RANK, DENSE_RANK, and...
2,557

Halloween Protection

Craig_Freedman on Mar 23 2019 05:14 AM
First published on MSDN on Feb 27, 2008 In a prior post, I introduced the notion that update plans consist of two parts:...
12K

Maintaining Unique Indexes with IGNORE_DUP_KEY

Craig_Freedman on Mar 23 2019 05:12 AM
First published on MSDN on Jan 30, 2008 A few months ago, I wrote a post describing how SQL Server maintains unique inde...
3,167

Partial Aggregation

Craig_Freedman on Mar 23 2019 05:11 AM
First published on MSDN on Jan 18, 2008 In some of my past posts, I've discussed how SQL Server implements aggregation i...
614

Recursive CTEs continued ...

Craig_Freedman on Mar 23 2019 05:10 AM
First published on MSDN on Nov 07, 2007 In this post, I will finish the discussion of recursive CTEs that I began in my ...
779

Recursive CTEs

Craig_Freedman on Mar 23 2019 05:09 AM
First published on MSDN on Oct 25, 2007 One of the most important uses of CTEs is to write recursive queries.

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