SQL Programmability & API Development Team Blog
All posts are AS IS, without any further guarantees or warranties.
Assembly redirection and CLR Integration
Assembly redirection is not supported in SQL CLR. Assembly redirection can be done using publisher,...
Author: sqlclr Date: 06/17/2006
T-SQL text hashing in SQL Servers 2000 and 2005
Recently several users of SQL Server ran into interesting issues related to hashing of T-SQL text by...
Author: adbirka Date: 06/15/2006
Satellite assemblies in SQL Server 2005
This is a sample on how to register satellite assemblies in SQL Server 2005. Based on the...
Author: sqlclr Date: 06/13/2006
TSQL Basics II - Parameter Passing Semantics
TSQL uses a copy-in/copy-out semantics to pass parameters to stored procedures and functions. This...
Author: adamp Date: 06/09/2006
Creating a CLR user define aggregate (part 2). Use multiple columns in the aggregation function
I part 1 we created a nice user defined aggregate. Now we are going to make it more sophisticated...
Author: nikitas Date: 06/06/2006
Diagnosing CLR Execution in SQL Server
In this section, i am going to introduce some basic diagnostic tools. You may already be familiar...
Author: RaviR Date: 06/03/2006
Programmatically receiving profiler events (in real time) from SQL Server 2005
The SQL Server engine provides two basic types of tracing: profiler (or real time) tracing and file...
Author: IvanPe Date: 05/25/2006
XML Data Type Limitations
I'd like to take some time today to explain some of the seemingly arbitrary limits placed on the XML...
Author: MSDN Archive Date: 05/23/2006
TSQL Basics I: Stored Procedures In An Intrepreted Language
This series of posts will discuss some TSQL semantics and language features that mayconfuse some...
Author: adamp Date: 05/14/2006
Improving query plans with the SCHEMABINDING option on T-SQL UDFs
This blog describes how the SCHEMABINDING option specified during creation of T-SQL UDFs may affect...
Author: TomerV Date: 05/12/2006
Predicate ordering is not guaranteed
A typical programmer may expect that the predicates are always evaluated in the order that they are...
Author: Jun Fang Date: 05/12/2006
What are the different cached objects in the plan cache?
Procedure cache which is also called as plan cache is primarily a cache of the query plans to...
Author: KetanDu Date: 05/04/2006
Plan Guides Are Your Best Friends
Plan guides are used to optimize the performace of a query without modifying it. They are intended...
Author: NaveenP Date: 05/01/2006
Introducing Multiple Active Result Sets (MARS) (1)
MARS is a new programming interface introduced in SQL Server 2005. It enables multiple result sets...
Author: pingwang Date: 05/01/2006
Overview of T-SQL and CLR debugging in SQL Server 2005
SQL Server 2005 ships with a new debugging engine that supports debugging of any T-SQL and CLR code...
Author: Wang.Haitao Date: 04/28/2006
Cursors and memory scalability in SQL Server 2005
Cursor implementation in SQL Server 2005 is redesigned for improved memory usage. This post takes a...
Author: GNAIR Date: 04/27/2006
Check Out Denis Ruckebusch's Blog
I'm adding a link in the sidebar to Denis Ruckebusch's blog. Denis is one of our testers for the XML...
Author: MSDN Archive Date: 04/24/2006
Dealing with the Limitations of XSD Content Models
There was recently a question on an internal mailing list about how to model RSS 2.0 with XML...
Author: MSDN Archive Date: 04/24/2006
Exception handling in SQLCLR
Naveen covered the TSQL exception handling in his posts. How does the TSQL exception handling...
Author: xiaoweij Date: 04/17/2006
XML processing with XQuery (part 1)
A few weeks ago, one of my friends came to me with the following problem. He was using a software...
Author: hanh Date: 04/14/2006
An article on FOR XML in Microsoft SQL Server 2000 and 2005
I just posted an article What does server side FOR XML return?...
Author: ekogan Date: 04/13/2006
What does server side FOR XML return?
XML publishing functionality exposed as “FOR XML” in Microsoft SQL Server 2000 evolved quite a bit...
Author: ekogan Date: 04/13/2006
Strong named assemblies and AllowPartiallyTrustedCallers
Very often, you may wish to factor out your code into separate assemblies in your application. For...
Author: RaviR Date: 04/08/2006
Server Side Error Handling - Part 3 (Why do I still see error messages from inside tsql try-block?)
There are cases when you see error messages relayed from inside the try-block. Some are intuitive...
Author: NaveenP Date: 04/07/2006
Sorting undefined characters in Unicode and/or Windows collation
When comparing two Unicode strings in non-binary collations, SQL Server uses a library that is...
Author: Jun Fang Date: 04/06/2006
SQL Server Identity column FAQs
Q. How is identity values generated? Does SQL Server internally use lock as synchronization...
Author: andrewz Date: 04/03/2006
Name resolution, default schema, implicit schema Part IV
This post will talk about implicit schema used in compile plan and conclude the topic of Name...
Author: andrewz Date: 04/03/2006
Name resolution, default schema, implicit schema Part III
It is time to cover name resolution algorithm in SQL 2005 for objects. [Algorithm] In a nutshell,...
Author: andrewz Date: 04/03/2006
Name resolution, default schema, implicit schema Part II
Last section clarified some background, let us continue with Name Resolution Algorithm for Types and...
Author: andrewz Date: 04/03/2006
Name resolution, default schema, implicit schema Part I
This series of blogs describe name resolution behavior of schema objects, types and XML schema...
Author: andrewz Date: 04/03/2006
Server Side Error Handling - Part 2 (Errors and Error Messages)
Each error in the server has two parts - an error message that describes the error that happened in...
Author: NaveenP Date: 04/03/2006
Server Side Error Handling - Part 1 (Migrating from @@error to tsql try-catch)
Tsql try-catch was added to improve server side error handling in sql server 2005. This feature...
Author: NaveenP Date: 03/30/2006
Host Policy level Permission Sets and their permissions
While there is guidance on how to use the various permission sets - SAFE, EXTERNAL_ACCESS, UNSAFE ,...
Author: RaviR Date: 03/30/2006
Multiplication and Division with Numerics
It can be surprising to see certain results when doing numeric arithmetic: declare @num1...
Author: mathh Date: 03/29/2006
Newsequentialid (Histrory/Benefits and Implementation)
In general, we made significant improvements in SQL Server scalability during Yukon. One of the...
Author: dragant Date: 03/23/2006