Welcome to MSDN Blogs Sign in | Join | Help

April 2006 - Posts

Saturday, April 29, 2006 3:04 AM

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 running in the server, including batches, stored procedures, user defined functions/aggregates/triggers, etc. You can use Visual Studio 2005 to debug against
Posted by Wang.Haitao | 3 Comments
Thursday, April 27, 2006 5:11 PM

Cursors and memory scalability in SQL Server 2005

Cursor implementation in SQL Server 2005 is redesigned for improved memory usage. This post takes a peek at the internals of the SQL Server 2005 cursor implementation. Most of the discussion below is geared towards server cursors as used by drivers like
Posted by GNAIR | 4 Comments
Monday, April 24, 2006 10:30 PM

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 data type, and he has two recent posts worth reading if you use XML in SQL Server 2005. The first explains how to modify a schema to work around some
Posted by brandon.berg | 1 Comments
Filed under: ,
Monday, April 24, 2006 10:09 PM

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 Schema. The short answer is that it can’t be done. The problem lies with the content model of the <channel> element, which consists of three elements which
Posted by brandon.berg | 1 Comments
Filed under: ,
Friday, April 21, 2006 7:59 PM

Infinite recompile message in the errorlog

SQL Server 2005 sometimes outputs an infinite recompile warning to the errorlog. This blog post explains what this warning is about and what to do if you see it in the errorlog. The new warning has the following format: A possible infinite recompile was
Posted by adbirka | 3 Comments
Monday, April 17, 2006 10:57 PM

Exception handling in SQLCLR

Naveen covered the TSQL exception handling in his posts. How does the TSQL exception handling mechanism interacts with SQLCLR exception handling mechanism? We will cover this topic in this post. When SQL server execute a user function/procedure/trigger
Posted by xiaoweij | 0 Comments
Friday, April 14, 2006 7:29 PM

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 music player that was storing his music library and playlists in a XML file and he wanted to do some extractions and transformations. Here’s how the
Posted by hanh | 1 Comments
Thursday, April 13, 2006 3:04 PM

An article on FOR XML in Microsoft SQL Server 2000 and 2005

I just posted an article What does server side FOR XML return? ( http://blogs.msdn.com/sqlprogrammability/articles/576095.aspx ) which gives some details of the design and performance characteristics of various FOR XML flavors. I also added links to XML
Posted by ekogan | 0 Comments
Saturday, April 08, 2006 6:01 PM

Strong named assemblies and AllowPartiallyTrustedCallers

Very often, you may wish to factor out your code into separate assemblies in your application. For example, you separate your type in one assembly because it gets used by multiple areas in your application. And you save your proc that uses that type in
Posted by RaviR | 0 Comments
Friday, April 07, 2006 8:46 PM

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 and some are not. Compile Errors - These errors can simply not be caught. This is true for any programming language. When compilation of a program generates
Posted by NaveenP | 1 Comments
Friday, April 07, 2006 12:21 AM

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 essentially same as the Windows API CompareStringW. It defines a weight for each recognized character, and then use the weights to compare characters. However,
Posted by Jun Fang | 1 Comments
Tuesday, April 04, 2006 12:06 AM

SQL Server Identity column FAQs

Q. How is identity values generated? Does SQL Server internally use lock as synchronization mechanism? A. Identity values are generated in-memory using light-weight synchronization, i.e. Spinlock (roughly speaking, Interlocked* function with yield). When
Posted by andrewz | 2 Comments
Monday, April 03, 2006 11:02 PM

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 resolution, default schema, implicit. A compile plan may refer to non-qualified schema object. It needs to record that fact an “implicit” schema is used (Name
Posted by andrewz | 0 Comments
Monday, April 03, 2006 10:42 PM

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, objects name resolution follows the same rule as types and XML schema collections. However, SQL Server name resolution and execution context used to have
Posted by andrewz | 1 Comments
Attachment(s): Name Resolution.doc
Monday, April 03, 2006 10:39 PM

Name resolution, default schema, implicit schema Part II

Last section clarified some background, let us continue with Name Resolution Algorithm for Types and XML Schema Collections [Algorithm] As implied by general syntax for referencing entities, types or XML schema collections cannot be referenced across
Posted by andrewz | 0 Comments
Monday, April 03, 2006 10:33 PM

Name resolution, default schema, implicit schema Part I

This series of blogs describe name resolution behavior of schema objects, types and XML schema collections, and how it interacts with default schema, compile plan implicit schema. The first part will lay some background so that we are at the same page.
Posted by andrewz | 2 Comments
Monday, April 03, 2006 9:08 PM

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 the server and an error action that determines the effect of the error on the statement, level, batch, transaction, connection and/or server. Server has
Posted by NaveenP | 2 Comments
 
Page view tracker