|
|
-
|
|
Checkout the fifth part of my XML support and SQL Server article series here.
In this article, I discussed the basic XML query methods for XML data manipulation. I also gave an brief introduction to the XQuery language, and demonstrated how to use the quer...
|
|
-
|
|
From time to time, I see the following question posted on various SQL Server forums by different users asking why the msdb database on their SQL Server instance is too big. As we all know, msdb is a system database that supports SQL Server Agent service, a...
|
|
-
|
|
Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities, whereas a random collection of tools can lead to confusion, operational mistakes, high training c...
|
|
-
|
|
This is the third part of the three part article series on partitioning relational data.
In the first part of this three-part article series on partitioning relation data, I started the article by giving an introduction to partition relational data along ...
|
|
-
|
|
Checkout the fourth part of my XML support and SQL Server article series here.
In this part, I talked about XML data type (typed and untyped) and its limitations. I also demonstrated how you can create XML variables and XML columns, and compare between typ...
|
|
-
|
|
Virtualization is a hot trend in the computing world, offering businesses substantial cost and performance benefits that include server consolidation, reducing power consumption and the effortless creation of virtual development and test environments. As a...
|
|
-
|
|
A common requirement for dealing with large datasets is the ability to split the data into smaller blocks to help improve performance. Performance degradation is evident once the tables reach larger sizes, and therefore, it is sometimes appropriate to brea...
|
|
-
|
|
When creating XML documents, you must work from a design that defines the structure of the document. This strengthens the structure and design. If you need to send the document to others, especially from other companies, they need the document format. With...
|
|
-
|
|
Checkout my article here, in which I talked about the basic steps that are requried to plan an successful ETL solution.
This article is published on SSWUG.org.
...
|
|
-
|
|
Checkout my article here, in which I discussed the fundamentals of XML technologies.
This article is published on SSWUG.org.
...
|
|