XML Workshop XV - Accessing FOR XML results with ADO.NET
The next installment of Jacob Sebastian's great series on XML looks at how a .NET application might consume XML data returned from SQL Server.
2008-03-12
5,632 reads
The next installment of Jacob Sebastian's great series on XML looks at how a .NET application might consume XML data returned from SQL Server.
2008-03-12
5,632 reads
Continuing on with his comprehensive series on XML, Jacob Sebastian shows us how to generate a tree of parent-child data using XML.
2008-02-13
7,780 reads
Finding missing data in a sequence of numbers or dates is a common request of DBAs. Regular author Jacob Sebastian brings us a new article that shows just how you can do this.
2008-02-06
8,642 reads
Continuing on with his series on SQL Server 2005 Compact Edition, regular author Jacob Sebastian takes a look at how Visual Studio fits into your SQL CE project.
2008-01-23
3,145 reads
Part 3 of his series looking at SQL Server Compact Edition, then embedded version of SQL Server. This time we look at the new version that's in beta.
2007-12-27
2,151 reads
Continuing on with his highly popular XML series, Jacob Sebastian looks at variable content and stylesheets in your SQL content.
2007-12-19
3,805 reads
Building SSIS packages and deploying them to production can be a challenge as connection strings and directory structures change. Longtime SQL Server guru Jacob Sebastian brings us a technique for building packages to make this easier.
2007-12-12
11,172 reads
Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.
2007-12-05
7,077 reads
The eleventh installment of the XML Workshop continues looking at namespaces. This time Jacob Sebastian examines default namespaces and how they impact your XML processing.
2007-11-21
4,451 reads
Real world solutions are key and having different techniques can sometimes help you code quicker. Longtime author Jacob Sebastian shows us how to solve a few problems with different techniques.
2007-11-14
6,175 reads
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
By Brian Kelley
Just as it's important to take care of our physical health (and I'm guilty...
By Zikato
In SQL Server, using the KILL command to terminate a session results in an...
My agency has been using the combo of on-premises SQL Server for the back...
Development Environment I am learning how to use pyodbc and accessing database in SQL...
We are seeing multiple frequent deadlocks occurring with the following extract of code, which...
I want to enable two trace flags, 4199 and 4137, for a single query. How should I do this:
-- A SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, 4137); -- B SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, QUERYTRACEON 4137); -- C SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199), (QUERYTRACEON 4137);See possible answers