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
421

6.0 Best Programming Practices

sshekar on Mar 23 2019 04:47 AM
First published on MSDN on Jan 13, 2007
792

5.0 Retrieving Query Plans from Plan Cache DMV’s

sshekar on Mar 23 2019 04:47 AM
First published on MSDN on Jan 12, 2007 P.
770

4.0 Query Parameterization

sshekar on Mar 23 2019 04:47 AM
First published on MSDN on Jan 11, 2007
607

3.0 How Cache Lookups Work

sshekar on Mar 23 2019 04:46 AM
First published on MSDN on Jan 10, 2007
5,706

2.0 Sql_Handle and Plan_Handle Explained

sshekar on Mar 23 2019 04:46 AM
First published on MSDN on Jan 09, 2007
2,404

1.0 Structure of the Plan Cache and Types of Cached Objects

sshekar on Mar 23 2019 04:46 AM
First published on MSDN on Jan 09, 2007
801

Plan Cache Concepts Explained

sshekar on Mar 23 2019 04:46 AM
First published on MSDN on Jan 08, 2007 Since the release of SQL Server 2005 there have been several questions around ho...
2,927

Case-insensitive Search Operations

SQL-Server-Team on Mar 23 2019 04:45 AM
First published on MSDN on Jan 04, 2007 Many applications have a functional requirement for the underlying database to h...
884

Knowing about 'Forwarded Records' can help diagnose hard to find performance issues.

SQL-Server-Team on Mar 23 2019 04:43 AM
First published on MSDN on Dec 01, 2006 Imagine a customer using an ISV application that stores certain product informat...
443

Resolving Login Errors with Duplicated Databases

SQL-Server-Team on Mar 23 2019 04:39 AM
First published on MSDN on Oct 17, 2006 Many ISVs and ISV customers often have a need to duplicate their database server...
343

XML: Typed and Untyped

SQL-Server-Team on Mar 23 2019 04:36 AM
First published on MSDN on Sep 26, 2006 Occasionally we hear from people who are surprised to find that their XML data u...
492

Introducing Multiple Active Result Sets (MARS) (2)

SQL-Server-Team on Mar 23 2019 04:28 AM
First published on MSDN on Jun 23, 2006 MARS is a powerful tool, but you may shoot yourself by the foot if you don't use...
892

Impersonation in SQL CLR

SQL-Server-Team on Mar 23 2019 04:26 AM
First published on MSDN on Jun 17, 2006 When the user code will try to access a resource outside of the SQL server it wi...
378

Assembly redirection and CLR Integration

SQL-Server-Team on Mar 23 2019 04:26 AM
First published on MSDN on Jun 17, 2006 Assembly redirection is not supported in SQL CLR.
306

TSQL Basics II - Parameter Passing Semantics

SQL-Server-Team on Mar 23 2019 04:24 AM
First published on MSDN on Jun 09, 2006 TSQL uses a copy-in/copy-out semantics to pass parameters to stored procedures a...
346

Creating a CLR user define aggregate (part 2). Use multiple columns in the aggregation function

SQL-Server-Team on Mar 23 2019 04:23 AM
First published on MSDN on Jun 06, 2006 I part 1 we created a nice user defined aggregate.
298

Creating a CLR user define aggregate (part 1). Simple CLR aggregate

SQL-Server-Team on Mar 23 2019 04:23 AM
First published on MSDN on Jun 06, 2006 SQL Server 2005 allows creating of User Defined Aggregate in any of the .
418

Diagnosing CLR Execution in SQL Server

SQL-Server-Team on Mar 23 2019 04:23 AM
First published on MSDN on Jun 03, 2006 In this section, i am going to introduce some basic diagnostic tools.
3,349

XML Data Type Limitations

SQL-Server-Team on Mar 23 2019 04:22 AM
First published on MSDN on May 23, 2006 I'd like to take some time today to explain some of the seemingly arbitrary limi...
429

TSQL Basics I: Stored Procedures In An Intrepreted Language

SQL-Server-Team on Mar 23 2019 04:21 AM
First published on MSDN on May 14, 2006 This series of posts will discuss some TSQL semantics and language features that...
1,606

Improving query plans with the SCHEMABINDING option on T-SQL UDFs

SQL-Server-Team on Mar 23 2019 04:21 AM
First published on MSDN on May 12, 2006 This blog describes how the SCHEMABINDING option specified during creation of T-...
1,001

Predicate ordering is not guaranteed

SQL-Server-Team on Mar 23 2019 04:21 AM
First published on MSDN on May 12, 2006 A typical programmer may expect that the predicates are always evaluated in the ...
834

What are the different cached objects in the plan cache?

SQL-Server-Team on Mar 23 2019 04:21 AM
First published on MSDN on May 04, 2006 Procedure cache which is also called as plan cache is primarily a cache of the q...
284

Plan Guides Are Your Best Friends

SQL-Server-Team on Mar 23 2019 04:20 AM
First published on MSDN on May 01, 2006 Plan guides are used to optimize the performace of a query without modifying it.
409

Introducing Multiple Active Result Sets (MARS) (1)

SQL-Server-Team on Mar 23 2019 04:20 AM
First published on MSDN on May 01, 2006 MARS is a new programming interface introduced in SQL Server 2005.
1,110

Overview of T-SQL and CLR debugging in SQL Server 2005

SQL-Server-Team on Mar 23 2019 04:19 AM
First published on MSDN on Apr 28, 2006 SQL Server 2005 ships with a new debugging engine that supports debugging of any...
545

Cursors and memory scalability in SQL Server 2005

SQL-Server-Team on Mar 23 2019 04:19 AM
First published on MSDN on Apr 27, 2006 Cursor implementation in SQL Server 2005 is redesigned for improved memory usage...
568

Dealing with the Limitations of XSD Content Models

SQL-Server-Team on Mar 23 2019 04:19 AM
First published on MSDN on Apr 24, 2006 There was recently a question on an internal mailing list about how to model RSS...
1,891

Exception handling in SQLCLR

SQL-Server-Team on Mar 23 2019 04:18 AM
First published on MSDN on Apr 17, 2006 Naveen covered the TSQL exception handling in his posts.
308

XML processing with XQuery (part 1)

SQL-Server-Team on Mar 23 2019 04:18 AM
First published on MSDN on Apr 14, 2006 A few weeks ago, one of my friends came to me with the following problem.

Latest Comments

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
sgtmango333
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 06:48 AM
I understand the intent, but that makes life a difficult for those using a Central Management Server with hundreds of instances. That means that every one on my team must now connnect to every server and update this setting just to maintain functionality after installing version 20. So next question...
0 Likes
SivertSolem
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 17 2024 04:16 AM
@TarynPratt wrote:At this point, patching SQL Server on Azure VMs through Azure Update Manager or Automated Patching via the SQL IaaS extension is not aware if the SQL Server is a part of an Always On availability group. It is important to keep this in mind when scheduling your updates with an autom...
1 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 16 2024 06:15 PM
@sgtmango333 I missed your question, apologies. It is not possible to set the default value for the Encryption property to optional. With SSMS 20 we upgraded to MDS 5.x, which sets Encryption to Mandatory (true) by default. We intentionally decided to stay with the default, to encourage folks toward...
1 Likes