(Deepankar Sarangi) This code snip explains how to select only those records from a table which follow a particular series. Let us say we want to find only the odd numbered rows from a table.
Other News
Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Building the Database
(Nannette Thacker) In most data-driven Web applications, users add data to the database by entering it through a web page. While this works well for most scenarios, there are times when the user has already collected the data to enter elsewhere, and having them tediously re-enter it through a web pa
Model Domain Objects with the Entity Framework
(Roger Jennings) Microsoft’s ADO.NET Team readies Entity Framework and Tools 1.0 for release as a VS 2008 add-in with enterprise-level features that LINQ to SQL doesn’t offer — domain object modeling, flexible inheritance techniques, multiple database vendors, and do-it-yourself n-tier deployment.
Auto Complete in ASP.NET using Ajax
(Raj Beniwal) AutoComplete is an ASP.NET AJAX extender that can be attached to any TextBox control, and will associate that control with a popup DropDown like list of words that begin with the prefix typed into the textbox.
SqlCredit – Part 13: More on Indexed Persisted Computed Columns
(Rob Garrison) This is part 13 of a series. If you have not read part 12, you can find it here. This article is a follow-up to part 12 and assumes that you have read that.
Clustered indexing and query performance
(dbscience) Last time I showed where partitioning could negatively impact performance, with one partitioned query being four times slower than a non-partitioned one when the data was partitioned by the same column as it was clustered by. This time I’m going to show a way to get better performance b
How to Use System Monitor to Identify SQL Server Hardware Bottlenecks
(Brad McGehee) Use Performance Monitor to Help Identify SQL Server Hardware Bottlenecks In the past several articles, we have essentially taken an inventory of how your SQL Server’s hardware, operating system, SQL Server configuration, and database configuration are set up. These have been easy ta
Oracle BI EE 10.1.3.3/2 – Presentation Variables in TOP filter
(Venkatakrishnan J) I got an email in one of our help lists today stating that Answers does not seem to accept presentation variables in TOP filter. If you are not sure what i mean, look at the screenshot below.
SQL Server 2005 Integration Services makes a good first impression
(Rex Baldazo) You never get a second chance to make a first impression. That aphorism applies to so many things — dating of course, job interviews certainly. And it also applies to software, something I was reminded of when I got to use SQL Server 2005 Integration Services (SSIS) for the first time
SQL Server 2008 – iFTS Transparency – Viewing the words in the index
(Simon Sabin) One of the huge frustrations with using Full Text prior to SQL Server 2008 was that you had no idea what content the iFilter has extracted from the document you have indexed. This leads to questions like “Why hasn’t this document been returned when this one has?”. We had a situation wh