Sign in
|
Join
Home
Blogs
Ask
Just Learned
Interview Questions
Puzzles
Tutorials
Quiz
Modules (beta)
Getting Started with ASP.NET MVC - Part 6:
ASP.NET MVC and Entity Framework
First Time? You can support us by signing up. It takes only 5 seconds. Click
here
to sign up. If you already have an account, click here to
login
.
Loading
Jacob's Blog
Home
Contact
RSS for Posts
My technology blog on SQL Server, TSQL, XML, FILESTREAM and other areas of SQL Server.
Recent Blog Posts
XQuery Lab 65 – Restructuring an XML document using...
SQL Server book from Pinal Dave
XQuery Lab 64 – Reading values from an XML column
SQL Server–Partitioning FILESTREAM data with RANGE...
Getting started with SQL Server Wait Types
T-SQL Tuesday #016 - Summarizing data using GROUPING...
SQL Server – TSQL – Quiz 2011 is here, your chance...
Happy Birthday to TSQL Challenges and its younger sibling...
What is SQL Server Juneau?
What is SQL Server Crescent?
Most Viewed
XQuery Labs - A Collection of XQuery Sample Scripts
(43,615)
XML Workshops
(24,632)
SQL Server - How do I Insert an explicit value into...
(17,986)
XQuery Lab 58 - SELECT * FROM XML
(16,835)
Converting VARBINARY to VARCHAR using FOR XML
(16,547)
FOR XML EXPLICIT Tutorial – Part 4
(14,184)
My Latest Book: “The Art of XSD - SQL Server XML Schema...
(12,628)
SQL Server - Server-side paging with Row_number() function
(12,313)
FOR XML EXPLICIT Tutorial- Part 1
(11,478)
FOR XML Tutorials
(7,649)
Archive
December 2011 (1)
August 2011 (1)
July 2011 (1)
June 2011 (1)
March 2011 (3)
February 2011 (3)
January 2011 (2)
December 2010 (2)
November 2010 (4)
September 2010 (1)
August 2010 (5)
July 2010 (3)
June 2010 (9)
May 2010 (3)
April 2010 (5)
March 2010 (5)
February 2010 (4)
January 2010 (4)
December 2009 (3)
November 2009 (1)
October 2009 (4)
September 2009 (4)
August 2009 (14)
July 2009 (2)
June 2009 (15)
May 2009 (7)
April 2009 (1)
March 2009 (10)
February 2009 (8)
January 2009 (15)
December 2008 (1)
November 2008 (3)
October 2008 (14)
September 2008 (32)
August 2008 (30)
July 2008 (15)
June 2008 (6)
January 2008 (4)
December 2007 (6)
November 2007 (2)
October 2007 (1)
June 2007 (1)
January 2007 (1)
October 2006 (1)
July 2006 (1)
Having huge amounts of traffic can be a problem. Aside from the usual maintenance, you also need to check on the server load. Having a
virtual dedicated server hosting
can solve these problems.
February 2010 - Posts
XQuery Lab 52 – A More Intuitive way of reading an RDF document
After reading XQuery Lab 51 , my friend and database expert Brad Schulz send me a note showing another way of achieving the same results. The approach he suggested was much cleaner than my version. My code used the following expression in the WHERE clause...
by
Jacob Sebastian
on 02-25-2010 | 1,390 Views
Why does Excel 2007 prompt for repair when opening a document stored in SQL Server 2008 FILESTREAM Column?
This post looks closer into a common problem many people may have faced while storing Microsoft Office documents into the FILESTREAM column of a SQL Server database....
by
Jacob Sebastian
on 02-18-2010 | 3,463 Views
XQuery Lab 51 – Querying an RDF document using TSQL and XQuery
This installment of XQuery Labs presents a script that reads information from an RDF document using TSQL and XQuery....
by
Jacob Sebastian
on 02-16-2010 | 2,429 Views
How to generate CDATA and NAMESPACE Declarations using FOR XML EXPLICIT
I was asked this question in one of the SQL Server forums recently. The OP wanted to generate an XML document with CDATA sections and NAMESPACE declarations. SQL Server 2005 introduced WITH XMLNAMESPACES() which is very handy to generate namespace declarations...
by
Jacob Sebastian
on 02-06-2010 | 2,695 Views
Copyright © Beyondrelational.com