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

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

SQL Server 2005 allows creating of User Defined Aggregate in any of the .NET languages such as C# or...

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

Infinite recompile message in the errorlog

SQL Server 2005 sometimes outputs an infinite recompile warning to the errorlog. This blog post...

Author: adbirka Date: 04/21/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

<Previous