Welcome to MSDN Blogs Sign in | Join | Help

May 2006 - Posts

Friday, May 26, 2006 1:33 AM

Programmatically receiving profiler events (in real time) from SQL Server 2005

How to leverage the new .NET classes provided in the Microsoft.SqlServer.Management.Trace namespace to start and stop profiler traces and receive events in real time from SQL Server 2005
Posted by ivanpe | 3 Comments
Filed under:

Attachment(s): example.zip
Tuesday, May 23, 2006 10:33 PM

XML Data Type Limitations

I'd like to take some time today to explain some of the seemingly arbitrary limits placed on the XML data type, specifically those related to ID/IDREF validation, complex XML Schema types, the depth limit for XML data, and the enigmatic "XSD schema too
Posted by brandon.berg | 4 Comments
Filed under: ,
Sunday, May 14, 2006 8:12 PM

TSQL Basics I: Stored Procedures In An Intrepreted Language

This series of posts will discuss some TSQL semantics and language features that may confuse some users new to TSQL. Specially those users familiar with other popular imperative programming languages and familiar with the SQL query language, but not familiar
Posted by adamp | 0 Comments
Filed under:
Friday, May 12, 2006 9:03 PM

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 query plans involving these UDFs in SQL Server 2005. Armed with this knowledge, you may find that you can dramatically improvement your query performance for free.
Posted by TomerV | 3 Comments
Filed under:
Friday, May 12, 2006 8:40 PM

Predicate ordering is not guaranteed

A typical programmer may expect that the predicates are always evaluated in the order that they are specified, but this is not true in database systems. For example, for the following clause, where col11 = 5 and convert(int, col2) = 100 programmers may
Posted by Jun Fang | 1 Comments
Thursday, May 04, 2006 2:10 PM

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 improve performance of query execution. By caching the compiled and execution plans we don’t have compile query each time they are executed. This is a huge performance
Posted by KetanDu | 4 Comments
Filed under:

Attachment(s): memory_layout.vsd
Monday, May 01, 2006 10:40 PM

Plan Guides Are Your Best Friends

Plan guides are used to optimize the performace of a query without modifying it. They are intended for advanced users and help in situations where a query submitted through an application can not be changed. For more details on this feature please visit
Posted by NaveenP | 0 Comments
Monday, May 01, 2006 12:39 PM

Introducing Multiple Active Result Sets (MARS) (1)

MARS is a new programming interface introduced in SQL Server 2005. It enables multiple result sets to exist at the same time for a given connection. To say it in a simple way, you can make a connection to server and then submit multiple requests to server
Posted by pingwang | 0 Comments
 
Page view tracker