(Frank Ableson) What good is a mobile computing environment if you can’t keep track of your favorite news feeds on the go? Sure, you can use Android’s browser to read your favorite Web sites, but it’s unlikely the sites are optimized for a screen two inches high. And besides, then you’ll miss the op
Other News
Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Creating a Data Access Layer (DAL)
(Nannette Thacker) Over the course of the past three tutorials we have created an ASP.NET page that allows the visitor to upload and display an Excel spreadsheet in a GridView. Our end goal is to allow the user to import the rows in the spreadsheet into the two tables of our application database, a
How to maintain SQL Server indexes for query optimization
(Matthew Schroeder) Maintaining SQL Server indexes is an uncommon practice. If a query stops using indexes, oftentimes a new non-clustered index is created that simply holds a different combination of columns or the same columns. A detailed analysis on why SQL Server is ignoring those indexes is not
Client Application Services: Getting Started
(Vikas Goyal) The primary function of the ASP.NET framework is web site provisioning. It helps deliver static and dynamic (both client and server side) content over HTTP protocol. But, as ASP.NET has progressed, lots of value-added features that are required by most applications have been added to i
Using Linq to paginate your ObjectDataSource
(Jason Witty) When SQL server first launched I wrote about using ROW_NUMBER() to paginate your data with SQL Server 2005. Today I am going to look at an alternate approach on the same subject. In this article I will review data pagination using a grid view bound to an ObjectDataSource that is persis
Understanding the difference between Indexes and Statistics
This was one of the questions that a reader had asked us recently: “What is the difference between an index and a statistic and how do they get stored?”
Find space Usage by Table , Schema in SQL Server 2005 and 2008
(Muthusamy Anantha Kumar) Often SQL Server Database administrators struggle with hard disk space and constantly strive to clean up tables and schemas, writing many queries to find which table and schema uses the most hard disk space.
Researching your MySQL table sizes
(Peter Zaitsev) I posted a simple INFORMATION_SCHEMA query to find largest tables last month and it got a good response. Today I needed little modifications to that query to look into few more aspects of data sizes so here it goes:
Oracle BI EE 10.1.3.3/2 – Conditional Formatting based on Multiple Columns
(Venkatakrishnan J) Another simple question came today to me via email today. Though everyone would know about this, i thought i would blog about it to keep this as a future reference. As soon as 11g comes out(not sure when though), i shall be blogging about how the same can be done in 11g. The ques
Tips for using indexes in SQL Server 2005 (Part 3)
Featured Article(s) Tips for using indexes in SQL Server 2005 (Part 3) Here are some helpful tips to performance tune and optimize SQL Server 2005 indexes. SQL Server Show – Watch Here SelectViews: SharePoint Feedback Results, Discussion Watch, Information Overload and Gaming – What It Could Mean For DBAs. Also – Newsletter Feedback, Upcoming SQL Server Events, Baselines and SQL […]