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
 

FREE 12 month online training for ASP.NET & MS Expression Studio and a Free copy of MS Expression Web with Windows Server Purchase

Home >Search > SQL
Search:
What's New - What's Hot
Listings for Applications Applications (161)
Listings for Articles & Samples Articles & Samples (5027)
Listings for Bugs and Fixes Bugs and Fixes (94)
Listings for Developer Sites Developer Sites (13)
Listings for Downloads Downloads (54)
Listings for Introduction Introduction (29)
Listings for Knowledge Base Knowledge Base (289)
Listings for Sample Chapters Sample Chapters (24)
Listings for Training Training (23)
Listings for WebCasts WebCasts (21)


SQL - Articles / Scripts / Tips     
Total Hits: 697  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQLServerCentral.com offers a large repository of SQL Server articles from throughout the web....

SQL Server - Insert Record And Get New ID     
Total Hits: 827  |  Today: 0Author: Robbe D. Morris      Rating:  
Read Reviews | Write Review |  Your Rating: 

Here's a small sample of how to use ADO and stored procedures to insert records into a table and receive the newly created id back for use in your page....

SQL Tutorial & Tips     
Total Hits: 534  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article provides different tips and samples for Update query in SQL....

Fundamentals of DTS in SQL Server 2000     
Total Hits: 3214  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft has added an enormous amount of features to DTS (Data Transformation Services) in its new release of SQL Server 2000...

HOWTO: Determine Parameter Requirements for a Stored Procedure in ASP     
Total Hits: 4136  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article provides the ASP code necessary to programmatically determine the parameter requirements for any stored procedure. The sample code provided determines the parameter name, data type, direction, and size of all parameters in a stored procedure. The developer can use this acquired information at design time in defining the stored procedure call. The method outlined in this article uses the "Parameters.Refresh" method and the "Parameters" collection and is useful for those developers wh...

Authentication Methods for Connections to SQL Server in Active Server Pages     
Total Hits: 1097  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Both SQL Server authentication (standard security) and Windows NT authentication (integrated security) are SQL Server authentication methods that are used to access a SQL Server database from Active Server Pages (ASP).
...

HOWTO: SQL Server with Integrated Security, IIS on Same Machine     
Total Hits: 1210  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to set up Microsoft SQL Server using Integrated Security on the same physical machine as Microsoft Internet Information Server....

HOWTO: Call SQL Server Stored Procedures from ASP     
Total Hits: 5556  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates three methods of calling a stored procedure from Active Server Pages using ActiveX Data Objects (ADO)....

Microsoft SQL Server & Solid State Accelerators     
Total Hits: 540  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Using Solid State Accelerators (memory) can be an effective way to boost SQL Server I/O performance....

SQL Server 6.5 Useful Undocumented Stored Procedures     
Total Hits: 640  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Author Alexander Chigrik helps us discover the secret world of undocumented SQL Server 6.5 stored procedures....

The Self-Taught DBA     
Total Hits: 856  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Are you thinking of becoming a master DBA? If so, find out how you can....

SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK     
Total Hits: 634  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Relational databases like Microsoft's SQL Server use locks to prevent multiple users from making conflicting modifications to a set of data: when a set of data is locked by a user, no other users can modify that same set of data until the first user finishes modifying the data and relinquishes the lock. There are exceptions, but let's not go there....

DECLARE @local_variable (T-SQL)     
Total Hits: 879  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Excerpt from this page:The latest Microsoft product Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values with either a SET or SELECT statement. Cursor variables can be declared with this statement and used with other cursor-related statements. After declaration, all variables are initialized as NULL....

@@IDENTITY crisis     
Total Hits: 907  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you have worked with SQL Server, you are probably familiar with identity columns. These are equivalent to the "AutoNumber" columns in Access. The main purpose of these columns is to provide a primary key to the table, when a primary key can not be defined using other fields in the table. One of the common questions in the newsgroups is "How can I get the ID of the inserted record in SQL database?" This translates to "How can I get the value of identity column in the inserted record?" In this ...

SQL Server 2000 Undocumented Stored Procedures     
Total Hits: 1252  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Still more from author Alexander Chigrik on the secret world of undocumented SQL Server 2000 stored procedures....

SQL Server 7.0 Undocumented Stored Procedures     
Total Hits: 849  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, you will learn about some useful undocumented stored procedures shipped with SQL Server 7.0....

UUse SET STATISTICS IO and SET STATISTICS TIME to Help Tune Your SQL Server Queries     
Total Hits: 616  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is not an article on how to tune queries (that subject would take a book), but an article on how to use the often overlooked Transact-SQL SET STATISTICS IO and the SET STATISTICS TIME commands to help us tune our queries.
...

The Data Mining Cluster Analysis Algorithm     
Total Hits: 1011  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The goal of clustering is to divide the data set in predetermined ("K") number of clusters around the average locations ("means"), so the algorithm is also known as the K-Means algorithm. Like other techniques it is applied mostly on people, to discover hidden grouping that can't be noticed at the first glimpse....

OLAP Services: Managing Slowly Changing Dimensions     
Total Hits: 1410  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article outlines several main types of slowly changing dimensions. After showing how an online analytical processing (OLAP) server operates when reading dimension members, the article then offers ways to handle these and other real-world scenarios using Microsoft® SQL Server™ OLAP Services....

Implementing Data Quality Through Meta Data     
Total Hits: 700  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Data Quality is as important as data integrity for most every application. This article examines how data quality can be improved in a data warehouse through the use of Meta Data.
...



Disclaimer - Privacy
© 2002-2014 DevASP.net