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
831

CTEs (Common Table Expressions)

Craig_Freedman on Mar 23 2019 05:09 AM
First published on MSDN on Oct 18, 2007 CTEs or common table expressions, which are new in SQL Server 2005, provide an e...
719

GROUPING SETS in SQL Server 2008

Craig_Freedman on Mar 23 2019 05:08 AM
First published on MSDN on Oct 11, 2007 In my last two posts, I gave examples of aggregation WITH ROLLUP and CUBE.
388

Aggregation WITH CUBE

Craig_Freedman on Mar 23 2019 05:08 AM
First published on MSDN on Sep 27, 2007 In my last post, I wrote about how aggregation WITH ROLLUP works.
1,007

Aggregation WITH ROLLUP

Craig_Freedman on Mar 23 2019 05:08 AM
First published on MSDN on Sep 21, 2007 In this post, I'm going to discuss how aggregation WITH ROLLUP works.
666

Maintaining Unique Indexes

Craig_Freedman on Mar 23 2019 05:07 AM
First published on MSDN on Sep 06, 2007 Consider the following schema:CREATE TABLE T (PK INT PRIMARY KEY, A INT, B INT)C...
603

Optimized Non-clustered Index Maintenance in Per-Index Plans

Craig_Freedman on Mar 23 2019 05:07 AM
First published on MSDN on Aug 22, 2007 In my last post, I showed how SQL Server 2005 only updates non-clustered indexes...
421

Optimized Non-clustered Index Maintenance

Craig_Freedman on Mar 23 2019 05:07 AM
First published on MSDN on Aug 15, 2007 Insert, update, and delete plans consist of two parts.
285

More on TOP

Craig_Freedman on Mar 23 2019 05:07 AM
First published on MSDN on Aug 01, 2007 Last week I wrote about a special case of the TOP operator known as ROWCOUNT TOP...
360

ROWCOUNT Top

Craig_Freedman on Mar 23 2019 05:06 AM
First published on MSDN on Jul 25, 2007 If you've looked at any insert, update, or delete plans, including those used in...
443

The UNPIVOT Operator

Craig_Freedman on Mar 23 2019 05:06 AM
First published on MSDN on Jul 17, 2007 The UNPIVOT operator is the opposite of the PIVOT operator.
368

PIVOT Query Plans

Craig_Freedman on Mar 23 2019 05:05 AM
First published on MSDN on Jul 09, 2007 In my last post, I gave an overview of the PIVOT operator.
413

The PIVOT Operator

Craig_Freedman on Mar 23 2019 05:05 AM
First published on MSDN on Jul 03, 2007 In my next few posts, I'm going to look at how SQL Server implements the PIVOT a...
985

Query Failure with Read Uncommitted

Craig_Freedman on Mar 23 2019 05:03 AM
First published on MSDN on Jun 12, 2007 Over the past month or so, I've looked at pretty much every isolation level exce...
586

Read Committed and Bookmark Lookup

Craig_Freedman on Mar 23 2019 05:03 AM
First published on MSDN on Jun 07, 2007 In my last two posts, I discussed two scenarios - one involving updates and anot...
316

Read Committed and Large Objects

Craig_Freedman on Mar 23 2019 05:02 AM
First published on MSDN on May 31, 2007 In my last post, I explained that SQL Server holds read committed locks until th...
464

Read Committed and Updates

Craig_Freedman on Mar 23 2019 05:01 AM
First published on MSDN on May 22, 2007 Let's try an experiment.
16.8K

Serializable vs. Snapshot Isolation Level

Craig_Freedman on Mar 23 2019 05:01 AM
First published on MSDN on May 16, 2007 Both the serializable and snapshot isolation levels provide a read consistent vi...
352

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

SQL-Server-Team on Mar 23 2019 05:00 AM
First published on MSDN on May 14, 2007 Source PartitionedWhile the table is partitioned, we may want to change the way ...
2,175

Repeatable Read Isolation Level

Craig_Freedman on Mar 23 2019 04:59 AM
First published on MSDN on May 09, 2007 In my last two posts, I showed how queries running at read committed isolation l...
335

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

SQL-Server-Team on Mar 23 2019 04:59 AM
First published on MSDN on May 08, 2007 Recall that in the previous posts on index build, we defined "aligned" as the ca...
416

Query Plans and Read Committed Isolation Level

Craig_Freedman on Mar 23 2019 04:59 AM
First published on MSDN on May 02, 2007 Last week I looked at how concurrent updates may cause a scan running at read co...
5,036

Read Committed Isolation Level

Craig_Freedman on Mar 23 2019 04:57 AM
First published on MSDN on Apr 25, 2007 SQL Server 2000 supports four different isolation levels: read uncommitted (or n...
421

Parallel Query Execution Presentation

Craig_Freedman on Mar 23 2019 04:54 AM
First published on MSDN on Apr 17, 2007 For those of you readers who've been wondering whatever happened to me, I've bee...
431

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

SQL-Server-Team on Mar 23 2019 04:53 AM
First published on MSDN on Apr 09, 2007 The star join optimization technique is an index based optimization designed for...
391

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

SQL-Server-Team on Mar 23 2019 04:49 AM
First published on MSDN on Jan 19, 2007 Aligned partitioned parallel index build In case of parallel build we scan and s...
367

Index Build strategy in SQL Server - Part 3: Offline Serial/Parallel Partitioning

SQL-Server-Team on Mar 23 2019 04:48 AM
First published on MSDN on Jan 16, 2007 There are two main categories of partitioned index build:Aligned (when base obje...
299

Index Build strategy in SQL Server - Part 2: Offline, Parallel, No Partitioning (Non stats plan (no histogram))

SQL-Server-Team on Mar 23 2019 04:44 AM
First published on MSDN on Dec 13, 2006 Build (serial) (write data to the in-build index) | X (Merge exchange) / | \ Sor...
347

Index Build strategy in SQL Server - Part 2: Offline, Parallel, No Partitioning

SQL-Server-Team on Mar 23 2019 04:44 AM
First published on MSDN on Dec 11, 2006 The type of parallel index build plan in SQL server depends on whether or not we...
865

Semi-join Transformation

Craig_Freedman on Mar 23 2019 04:44 AM
First published on MSDN on Dec 04, 2006 In several of my prior posts, I’ve given examples of semi-joins.
820

Introduction to Partitioned Tables

Craig_Freedman on Mar 23 2019 04:43 AM
First published on MSDN on Nov 27, 2006 In this post, I’m going to take a look at how query plans involving partitioned ...

Latest Comments

DavidEngelMS
in Update: Security hotfixes released for ODBC and OLE DB drivers for SQL Server on May 13 2024 03:26 PM
@Jay_Patel225 Make sure you have enabled Microsoft Update (Receive updates from other Microsoft products). For ODBC 17, ensure the following registry entries exist: LCID (REG_DWORD) HKLM\Software\Microsoft\Microsoft ODBC Driver 17 for SQL Server PatchLevel (REG_SZ) under HKLM\Software\Microsoft\Micr...
0 Likes
Jay_Patel225
in Update: Security hotfixes released for ODBC and OLE DB drivers for SQL Server on May 13 2024 02:32 PM
Hello @DavidEngelMS , Thank you for the informative article. We have noticed that half of the servers didn't receive an ODBC and OLE update through Microsoft Automatic Windows Update. We have double check the below path to make sure the ODBC or OLE Drivers are installed and properly registered in or...
0 Likes
sqlBender
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on May 09 2024 10:35 AM
all of that is great and well, but someone in your org decided to default the encryption level to MANDATORY when OPTIONAL would have been a smoother transition for orgs with hundreds of thousands of dollars in MS licenses per year.
1 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on May 09 2024 07:26 AM
@sqlBender We migrated SSMS 20 to version 5.x of the Microsoft.Data.SqlClient driver because support for additional encryptions (via the driver) was added in SQL Server 2022, and we needed to bring that same encryption functionality to SSMS. This offers customers improved security, which many compan...
0 Likes
sqlBender
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on May 08 2024 01:56 PM
we are using the shared central management server feature, and using SSMS 20 with the encryption set to mandatory as a default, we are not able to "connect" to the group without manually setting the encryption property to "Optional" and saving each connection. Where is this connection information sa...
0 Likes