(Pinal Dave) Query hints specify that the indicated hints should be used throughout the query. Query hints affect all operators in the statement and are implemented using the OPTION clause.
Other News
Extracting one table from mysqldump or phpMyAdmin backup
(Maciej Dobrzanski) Using mysqldump is a quick way to do backups, although usually limited to only smaller databases – perhaps up to a few gigabytes large. It is still a fairly popular solution as majority of databases aren’t even that big. Also phpMyAdmin provides a variant of mysqldump format thro
Creating Dynamic Textboxes With Auto Complete
(Krishna Garad) In this article we will see how to create textboxes dynamically with autocomplete using jQuery. All of you are aware of Ajax auto-complete which we can apply for providing auto-complete for our textboxes in a ASP.Net page.
SharePoint: Customising the Special Nav Link List
(Chris Grist) In this short article you will learn how to add to the area of the v4.master masterpage that currently shows view all content and the recycle bin.
Convert XML to object using LINQ
(Naufel Basheer) I had a requirement as part of my assignment to convert complex XML to an object using LINQ.
IBM Cognos Proven Practices: Use Case: Data Retrieval
This document describe troubleshooting method of an issue connecting to Teradata.
Final CLR Response
Final CLR Response Today one of our readers digs into a topic I connect with every once in a while regarding the role of your database server. The key question is, “what kinds of roles do you want your database server performing?” As I work with larger and larger databases, my tendency is to put the least amount of extraneous […]
Cloud implementations, technologies, including software (specifically databases) as a service and much more.
Pro-Center Video Programming for IT Professionals
Editorial Thoughts for Today
What to do with SQL CLR There are a lot of things much easier, or more efficient, when done in SQL Server using the CLR. Here are some of the ones I have done. Most of these were done before SQL Server 2008. Some are redundant with features available in SQL Server 2008, but only ship with the Enterprise or […]
Access XML data using LINQ to XML
(Amit Gupta Hyderabad) Today we would be leaning the way to read complex XML data using LINQ to XML, which would include 2 examples: