(manub22) Namespaces like in every language provides a way to avoid conflict with element names. Here we will see how can we add Namespace to an XML. In previous posts we learned how to query XMLs, but without Namespaces. Here we will see how can we query XML containing Namespaces.
Other News
Self throttling MySQL queries
(Shlomi Noach) Recap on the problem: •A query takes a long time to complete. •During this time it makes for a lot of I/O. •Query’s I/O overloads the db, making for other queries run slow.
Explorations in SQL: Fixing Duplicates for Index
(digitaleagle) I had an issue with some indexes that would not create. The database complained that the table had duplicates in it that violated the index. For me, the table was PS_AUC_HDR, but these steps should work for any table. Maybe some of the techniques will be helpful too. Also, if you k
Simple SQL – Finding the Next Operation
(Charles Hooper) An interesting request came in from an ERP mailing list – how would you write a SQL statement that indicates the next operation in a manufacturing process. Sounds like an easy requirement. Let’s take a look at a graphical view of one example (the graphical view is created using a
New to SQL Server PDW? First, tinker with client tools
(Robert Sheldon) SQL Server Parallel Data Warehouse (PDW) uses multiple SQL Server database servers to store and process data. The PDW environment is built on a massively parallel processing architecture that’s based on the DATAllegro warehouse appliance and SQL Server 2008 Enterprise edition.
How to perform CRUD (Create Read Update & Delete) operation in ListView.
(SheoNarayan) To perform data manipulation (CRUD – Create, Read, Update and Delete) in the ListView, we can follow this approach.
ASP.Net Development Tips
This tutorial highlights the different tips and techniques that a beginner can use when developing ASP.NET 4.0 websites using Visual Web Developer Express 2010 (VWD 2010).
SQL SERVER – How to Ignore Columnstore Index Usage in Query
(Pinal Dave) Earlier I wrote about SQL SERVER – Fundamentals of Columnstore Index and very first question I received in email was as following.
Multiple query plans for the same query?
(Geniiius) A while back i was creating a stored procedure to be used for pulling data from the SQL Server into cacti. The procedure was pulling data from a rather large table, which I had made sure was indexed properly for my query. When I executed the stored procedure from SQL Server Management Stu
Using the Text Plugin With RequireJS To Load Remote HTML Templates
(Ben Nadel) Earlier this week, I started looking into the RequireJS library as a way to manage JavaScript dependencies and modular application design. In addition to the core functionality of loading modules, RequireJS also has a plugin architecture that enables the loading of non-JavaScript data ty