Most of the web applications have a lot of images used in it. These images are usually stored in a web server folder and they are accessed by giving the relative path to the file with respect to the root folder of the website. .Net being the platform for distributed application now, ASP.Net can be u
Tag: sql server
Navigate hierarchies using recursive common table expressions
(Adam Machanic) Our world is, by and large, composed of hierarchies. Within both the natural and business worlds, we see different types of entities related to each other in a hierarchical fashion. Universes are made up of solar systems, which are made up of planets, each with moons. Living thin
Tools of the Trade: SQL Server Profiler and Query Analyzer
(Rob Howard) In my last column, I discussed Microsoft® Application Center Test and how it could be used to measure the performance of your Web application (see Extreme ASP.NET: Tools of the Trade: Application Center Test). Application Center Test is one of those tools you don’t know you need unt
FIX: Some 32-bit applications that use SQL-DMO and SQL-VDI APIs may stop working after you install SQL Server 2000 Service Pack 4 on an Itanium-based computer
You install Microsoft SQL Server 2000 Service Pack 4 (SP4) on an Itanium-based computer that is running a 64-bit version of Microsoft SQL Server 2000. When you do this, some 32-bit applications that are running on the local computer may stop working. The applications that stop working use SQL Distri
Inserting specific values into identity columns
(Arthur Fuller) Here is the problem du jour: You must rebuild a table (T1), and make sure you preserve the primary key (PK) values in T1. You want to move all the data into table T2, which has an identity key, while preserving the PKs from table T1. Once you move all the T1 data into T2, you want T2
An interview with William (Bill) Vaughn
(Douglas Reilly) William Vaughn is a well-known author who writes about Visual Basic and database-related topics. Looking at a list of his books serves as a history of Microsoft software over the last decade or so, from VBSQL, to ADO, to ADO.NET and most recently, SQL Server reporting services.
Introduction to MSSQL Server Analysis Services: Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube, Part II
(William Pearson) In this article, we will continue our examination of the design and creation, within Analysis services, of relative time periods. As we stated in our previous article, Relative Time Periods in an Analysis Services Cube, Part I, a popular feature found in Cognos PowerPlay Transforme
FIX: The Subscriber may not be able to upload changes to the Publisher when you incrementally add an article to a publication in SQL Server 2000 SP3
When you incrementally add an article to a publication in Microsoft SQL Server 2000 with Service Pack 3 (SP3), the Publisher can download changes to the Subscriber. However, the Subscriber may not be able to upload changes to the Publisher. You experience this problem when the following conditions a
How to set up an event forwarding server
(Kevin Kline) In part one of this series, I described why and how I use event forwarding to implement a cheap and effective monitoring feature for my large SQL Server environment. Here I’ll describe how to set up a central server and highlight issues you should be aware of at the central point of co
Loading Images into SQL Server with C#
(Jesse Smith) As your web site grows and images multiply, storing those images on the hosting server’s hard drive can turn a zippy hare of a site into a pokey tortoise. (Yes, they get there eventually, but users are impatiently waiting for a “photo finish”!) This article provides a set of simple
