Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Knowledge Base
Search:
What's New - What's Hot
More Categories for .NET Framework .NET Framework (376)
Listings for .Net Framework 2.0 .Net Framework 2.0 (9)
More Categories for ASP.Net ASP.Net (385)
More Categories for ASP.Net 2.0 ASP.Net 2.0 (42)
More Categories for C-Sharp C-Sharp (234)
More Categories for SQL Server SQL Server (289)
More Categories for Visual Basic.Net Visual Basic.Net (498)
More Categories for Visual C# .NET Visual C# .NET (44)
More Categories for Visual C++ .NET Visual C++ .NET (71)
More Categories for Visual SourceSafe Visual SourceSafe (17)
More Categories for Visual Studio 2005 Visual Studio 2005 (10)
More Categories for Visual Studio.Net Visual Studio.Net (130)
More Categories for Windows Windows (203)
More Categories for XML XML (15)
More Categories for XML and .NET XML and .NET (71)
 


How To Use the Analysis Services Processing Task in SSIS 2005     
Total Hits: 368  |  Today: 0Author: Ray Barley      Rating:  
Read Reviews | Write Review |  Your Rating: 

We are looking to automate the processing of our SQL Server Analysis Services dimensions and cubes. We'd like to add this processing to our existing SQL Server Integration Services (SSIS) packages which periodically update our data warehouse from our OLTP systems. Can you give us the details on how the Analysis Services Processing Task can be used in an SSIS package?...

How to drag forms by using the client area with Visual C++ 2005 or with Visual C++ .NET     
Total Hits: 183  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to permit a user to move a form by dragging the client area of the form. This article describes how to override the WndProc method of the form to enable the client area dragging....

How To Use Resources in Visual Basic .NET     
Total Hits: 830  |  Today: 0Author: Dan Mabbutt      Rating:  
Read Reviews | Write Review |  Your Rating: 

Part One of this article demonstrated how to use resource files in VB 6. Resource files let you add a bitmap, a wav file, a custom cursor or some other special effect to your Visual Basic project. Microsoft defines them this way, "A resource is any nonexecutable data that is logically deployed with an application." The main advantage of resource files is that they're integrated directly into your Visual Basic project for maximum execution speed and minimum hassle packaging and deploying your a...

HOW TO: Connect to the Microsoft SQL Server Through the Use of Named Pipes (Q159976)     
Total Hits: 1061  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you connect to Microsoft SQL Server from the Active Server Pages (ASP) using ActiveX Data Objects via named pipes, the client computer must be validated by SQL Server to use the named pipe. If SQL Server is on a different physical computer than the ASP files, the Active Server Pages might fail. By default, Internet Information Server (IIS) attempts to connect to the SQL Server anonymously. To do this, it uses the anonymous logon information provided in Internet Service Manager (Inetmgr.exe)...

INF: Troubleshooting Stored Procedure Recompilation     
Total Hits: 442  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article deals with one specific type of performance issue that applications may experience with Microsoft SQL Server: the run-time recompilation of stored procedures. If you are troubleshooting a performance issue, but you have not determined that this is the precise source of your problem, refer to the following article in the Microsoft Knowledge Base before proceeding:
...

HOW TO: Configure Memory for More Than 2 GB in SQL Server     
Total Hits: 327  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to configure SQL Server to use more than 2 GB of physical memory. Microsoft SQL Server 7.0 and Microsoft SQL Server 2000 dynamically acquire and free memory as needed. When you run multiple instances of SQL Server on a computer, each instance dynamically acquires and frees memory to adjust for changes in the workload of the instance....

INF: Common SQL Mail Problems (Q315886)     
Total Hits: 240  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article uses a question and answer format to identify common problems you may encounter when you work with SQL Mail and provides you with some tips on how to correct or troubleshoot these problems. The vast majority of SQL Mail related problems are due to an improper configuration. For additional information on how to correctly configure SQL Mail,...

INF: SQL Logs 17832 with Multiple TCP\IP Connection Requests(Q154628)     
Total Hits: 694  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If SQL Server is hit with multiple and simultaneous TCP/IP connection requests, such as the case with World Wide Web servers, the requests are quickly rejected by responding with a TCP/IP Reset Frame....

Internet Information Server Performance Logging to Disk vs. ODBC     
Total Hits: 489  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The impact of logging Internet Information Server (IIS) activity to disk is minimal compared to logging it to a SQL Server database. The performance impact of logging to SQL Server is greater and depends on the SQL Server implementation and the hardware you use. See your SQL Server documentation for more information on increasing performance....

INF: Execute a SQL Server DTS Package from Active Server Pages (Q252987)     
Total Hits: 551  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The SQL Server Data Transformation Services (DTS) packages may need to be executed from remote locations. Using Active Server Pages (ASP), you can execute from remote locations over the intranet or Internet, because ASP is an automation client for the Component Object Model (COM) components and can be executed from the browser....

Q99321 : Tips for Optimizing Queries on Attached SQL Tables     
Total Hits: 373  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Special considerations must be made for performance optimization of queries built on attached SQL database tables. An SQL database, for this article, is defined as any client/server database that supports some level of ANSI SQL as an intrinsic part of the database's programming language. Optimal query strategy for these queries is to ensure that all query operations are performed on the server. This article outlines tips on how to ensure that queries against attached SQL database tables are.....

HOWTO: SQL Server 7 Distributed Query with OLAP Server (Q218592)     
Total Hits: 429  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to perform a SQL Server distributed query to retrieve data from an OLAP Services cube....

Q178295 - How to Obtain SQL Server 6.5 Service Pack 4     
Total Hits: 1347  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to obtain Service Pack 4 for Microsoft SQL Server version 6.5. To see a complete list of bugs that are fixed by this update, see the Fixlist.txt file that accompanies the Service Pack....

Q203638 - HOWTO: Return Information About SQL Server Linked Servers     
Total Hits: 505  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 7.0 allows the addition of external data sources as linked servers. This feature provides access to distributed, heterogeneous queries against OLE DB data sources. When connecting to SQL Server, a cursor listing available tables can be returned with the SQLTables(file_handle) command. The SQLTables() command, however, does not return information about tables available in Linked Servers. Information regarding linked servers is returned by three different SQL Server 7.0 stored procedure...

Q224587 - INF: Troubleshooting Application Performance with SQL Server     
Total Hits: 1124  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Troubleshooting performance issues involves using a series of steps to isolate and determine the cause of an application slowdown. Possible causes include blocking, system resource contention, application design problems, or a particular set of queries or stored procedures with long execution times. This article walks you through the process of determining the source of a performance issue. It also references other articles in the Microsoft Knowledge Base that cover the details of specific perfo...

Q243586 - INF: Troubleshooting Stored Procedure Recompilation     
Total Hits: 773  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article deals with one specific type of performance issue that applications may experience with Microsoft SQL Server: the run-time recompilation of stored procedures. If you are troubleshooting a performance issue, but you have not determined that this is the precise source of your problem, refer to the following article in the Microsoft Knowledge Base before proceeding.....

How to Collect and Analyze Performance Data in Microsoft SQL Server     
Total Hits: 357  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

During this session, we will discuss the tools used to collect performance data and how to use this data to analyze some common SQL Server performance issues. We will review how to set up these tools and analyze the data collected. In addition, we will talk about troubleshooting techniques used to identify SQL Server performance issues....

Q251004 How to Monitor SQL Server 2000 Blocking     
Total Hits: 363  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article documents the usage and design of a stored procedure that you can use to diagnose blocking and performance issues. For a description of how to understand and resolve blocking...

Q199037 - INF: Trapping Error Messages Sent to Clients from a SQL Server     
Total Hits: 408  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The opportunity to trap error and warning messages sent to a client from the SQL Server can provide powerful information when you are tracking down a problem. This document explains, in detail, how to accomplish this from both SQL Server version 6.5 and 7.0....

Q237980 - INF: How to Convert an Access Database to SQL Server     
Total Hits: 409  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The easiest way to convert an Access database to SQL Server is to use the Upsizing Wizard. The Upsizing Wizard: Preserves database structure including data, indexes, defaults, and so on. Automatically converts Access validation rules and defaults to the appropriate SQL Server equivalents. Maintains table relationships and referential integrity after upsizing....



Disclaimer - Privacy
© 2002-2017 DevASP.net