(Erland Sommarskog) In the public forums for SQL Server, you often see people asking How do I use arrays in SQL Server? Or Why does SELECT * FROM tbl WHERE col IN (@list) not work? The short answer to the first question is that SQL Server does not have arrays – SQL Server has tables. However, you ca
Other News
Paging records in SQL Server 2005, SQL Server 2000, MS Access and MySQL
(Erwin@ODS) As a Web developer, you should know by now that using the default paging capabilities of ASP.NET Webcontrols like DataGrid and GridView is NOT recommended, simply because with every roundtrip to the data-server, you get ALL the records ALL of the time. This is fine perhaps for very small
Using Perl with the Informix Dynamic Server
(Daniel Hebert) This tutorial takes you through the process of setting up the Perl Database Interface (DBI) to work with the IBM Informix Dynamic Server (IDS). See examples of how to exercise a variety of DBI features and learn how to configure CPAN module installation, driver installation, script a
Understanding Full Text Searching Compared with LIKE
(Simon Sabin) One of the most common questions that comes up on the newsgroups is around searching for terms containing punctuation. The questions are normally something like “I’m trying to use Full Text to search my product catalog, when someone enters a product code the results I get back are o
SQL 2005 Maintenance Wizard Part 2
(Don Schlichting) SQL 2005 includes a graphical tool called the Maintenance Plan Wizard that can be used to create database optimization and integrity checking packages. Some of the tasks the Maintenance Plan Wizard can orchestrate include backing up the database, reorganizing data and index files,
Validating ASP.NET Query Strings
(Dino Esposito) For years, classic ASP developers implemented page authentication by inserting some generic code at the top of each page that would grab user credentials, attach a cookie, and redirect. All that repetitive code was swept away by the ASP.NET HTTP modules for authentication. As a resul
How to find out if an outer join was converted to inner
(Sergey Petrunia) After this post I’ve got a question how one can tell if his outer join was converted to inner. You can find it out by looking at the warning generated by EXPLAIN EXTENDED.
(56) Information Lifecycle Management, SQL 2k5 SP2(a), OneCare Issue and More
Pro-Center Video Programming for IT Professionals
Hyperion’s fit with Fusion not entirely clear
(Mark Brunelli) The question of where Hyperion Solutions Corp.’s technology fits into Oracle’s Fusion equation has some industry experts scratching their heads.
Microsoft Releases Visual Studio 2005 Update for Vista
(Darryl K. Taft) Microsoft has released a new version of its Visual Studio toolset for Windows Vista development.