|
|
-
|
|
After a small slip-up on the SQL Server Forums, I thought it best to remind myself (and others) of the importance of using Sargable predicates in WHERE clauses.
Definition: In relational databases, a condition (or predicate) in a query is said to be sargable if the DBMS engine can take advantage of......
|
|
-
|
|
Just a quick post on some of the resources I’ve been using to prepare for exam 70-454.
SQL Server 2008 Microsoft Certified Master (MCM) Readiness Videos
Although these readiness videos were designed to provide SQL Server 2008 Microsoft Certified Master candidates with an overview of what the......
|
|
-
|
|
Introduction This is the fifth and final post in a series of five on Using TVP’s and XML to Transport Relational Data. In this post we’ll take a look at some tips and tricks used to increase OpenXML and XQuery performance. Refresher The purpose behind this series of posts is to provide .Net Deve......
|
|
-
|
|
Introduction This is the fourth post in a series of five on Using TVP’s and XML to Transport Relational Data. In this post we’ll take a look at how Table-Valued Parameters (TVP’s) can be used to send multiple rows of data to a Transact-SQL statement or a routine, such as a stored procedure. We’l......
|
|
-
|
|
Introduction This is the third post in a series of five on Using TVP’s and XML to Transport Relational Data. In this post we’ll take a look at how to use XQuery within Transact-SQL to shred XML data. We’ll also look at how .Net Developers can use XQuery to reduce the number of SQL Server calls r......
|
|
-
|
|
Introduction This is the second post in a series of five on Using TVP’s and XML to Transport Relational Data. In this post we’ll look at how to use the OpenXML Rowset Provider to shred an XML document into a rowset which can then be used in Transact-SQL statements in which rowset providers such ......
|
|
-
|
|
Introduction I’ve been using XML as a means of sending multiple rows of data to SQL Server ever since OpenXML was released in SQL Server 2000. Although 2000 didn’t have an XML data type, the OpenXML Rowset Provider enabled SQL Server to shred a XML string into a rowset which could then be used in T......
|
|
-
|
|
While researching content on OPENXML vs. XQuery vs. Table-Valued Parameters, I stumbled across the SQL Server Forums; a place I used to spend quite a lot of time. I also visited a number of blogs created by friends and fellow SQL Server enthusiasts. At the time I was quite happy to lap-up the copiou......
|
|