(Richard Foote) I last discussed how high cardinality columns shouldn’t necessarily be in the leading column of a concatenated index as they don’t provide the performance benefit as sometimes claimed.
Other News
Insert data from Excel to SQL Server 2005 by using copy and paste commands
(Kun Lee) Loading data from SQL Server to Excel is a common practice in many automated and ad-hoc processes completed by DBAs on a daily basis. Traditionally loading data from Excel to SQL Server has been completed by DTS, SSIS, BCP, OPENROWSET, ImportExport Wizard, etc. Unfortunately, for a simp
SQL Server Fly on the Wall
Catch the Latest Shows [Watch] SQLonCall – all about conferences [Watch] SelectViews – a new idea, tips, tricks and SQL Server goodies Featured Article(s) Tips for Improving ASP.NET Application Performance The performance of web applications has always been a major concern for application developers. It is one of the most important factors that we need to take care of. When […]
Tips for Working with Management
SQLonCall Show Posted On the show today – a look at conferences and what they can offer, what you should look for. Find out about different things you can expect and the pros and cons of going to conferences. > Watch The Show Here Featured Article(s) Tips for using SQL Server 2005 stored procedures Here are some helpful tips to […]
Libxml2: Everything You Need in an XML Library
(Victor Volkman) Libxml2 is the XML parser and toolkit written in the C language and is freely available for integration into your apps via the easy-to-digest MIT License. Libxml2 was originally developed for the Gnome project, but doesn’t have any dependencies on it or even the Linux platform. This
Addressing fragments in REST
(Simon St. Laurent) REST offers a great way to build simple applications that Create, Read, Update, and Delete resources. But what if you want to get at part of a resource?
Xml Serialization
(Boyan Mihailov) If you want to store data, you often use a database. It’s very good way. But, sometimes you need to save too little amount of data that using a database is thoughtless. Another way to store data is to put it in a simple text file. One of the most convenient ways to do this is to use
DB2 SQL To Query Tablespace Free Pages Statistics
(Walker) I haven’t tried the DB2 version 9, but the version 8 offers DB2 CLP command to query or list the tablespaces statistics (particularly the used pages and free pages).
APAR Friday: One for V8, one for V9, and only two days late
(Willie Favero) Today’s Friday APARs are arriving on Sunday. I would like to day I had all of these terrific reasons, being so busy and all, but nope.. just forgot to post Friday…
Best Practices to Improve ASP.Net Web Application Performance.
(Somnath Dey) Performance tuning can be tricky. It’s especially tough in Internet-related projects with lots of components running around, like HTML client, HTTP network, Web server, middle-tier components, database components, resource-management components, TCP/IP networks, and database servers. P