Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
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
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)

Read Data From XML File in SQL Server  Version: 0.00     Price: $0.00  
Total Hits: 41  |  Today: 0Author: Lakhangarg      Rating:  
Read Reviews | Write Review |  Your Rating: 

sp_xml_preparedocument - Reads the XML text provided as input (@XMLDATA) ,
the xml text and returns a handle that can be used to access the newly created internal representation of the XML document. The output of this procedure is XML handle that is
used for OPENXML command....

Scripting SQL Server 2000 Indexes     
Total Hits: 158  |  Today: 0Author: Ron Talmage      Rating:  
Read Reviews | Write Review |  Your Rating: 

Adding indexes to tables is the most effective way to optimize your SQL Server query performance. Tables that you query often may require several indexes in order to handle the various search arguments you send. There is one particular situation where indexes on large tables are a hindrance, though. When you're bulk-copying data into the table, it's best to have either no index at all, or just a clustered index. For those situations it is best to use Transact-SQL scripts to remove and add those ...

Working with SQL Server     
Total Hits: 176  |  Today: 0Author: Ben Forta      Rating:  
Read Reviews | Write Review |  Your Rating: 

Now that you have a SQL Server DBMS and client software to use with it, it would be worthwhile to briefly discuss connecting to the database.
SQL Server, like all client/server DBMSs, requires that you log into the DBMS before being able to issue commands. SQL Server can authenticate users and logins using its own user list, or using the Windows user list (the logins used to start using Windows). As such, depending on how SQL Server is configured, it may log you in automatically using whateve...

Utility Belt: SQLGenerateUpdate Demo     
Total Hits: 54  |  Today: 0Author: Charles Carroll      Rating:  
Read Reviews | Write Review |  Your Rating: 

The code below calls "Utility Belt" functions.
The Generate Update statement is one demo of Database "Utility Belt" functionality....

Utility Belt: Search Demo C# SQLserver     
Total Hits: 123  |  Today: 0Author: Charles Carroll      Rating:  
Read Reviews | Write Review |  Your Rating: 

The code below calls "Utility Belt" functions.
The Search Code is one demo of Database "Utility Belt" functionality....

Keeping Your SQL Server Databases Defragmented With Diskeeper     
Total Hits: 146  |  Today: 0Author: Howard Butler      Rating:  
Read Reviews | Write Review |  Your Rating: 

All SQL Server databases, over time, experience "internal" fragmentation of its data. This occurs when records are removed from database pages but the space it occupied is still there after deletion. Eventually this space is reused, but as it is reused, the data pages become fragmented, which can lead to unnecessary I/O, especially in case of table scans where many data pages are read one after another....

Setting Up SQL Server 7/2000 Dependency Caching     
Total Hits: 217  |  Today: 0Author:      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 7/2000 dependency caching requires you to run some setup scripts that build the cache tables ASP.NET will monitor for changes. For this purpose the .NET Framework 2.0 provides a utility called aspnet_regsql.exe.
You do not need to have SQL Server 7/2000 installed in order to follow these steps. The same scripts and legacy dependency caching implementation (next lesson) will work with SQL Express....

Analyzing SQL Server 2000 Data Caching     
Total Hits: 342  |  Today: 0Author: Tom Pullen      Rating:  
Read Reviews | Write Review |  Your Rating: 

One of SQL Server 2000’s main selling points is its ease-of-use and simplicity. You can install it out of the box and use it pretty much without making many configuration changes. In terms of the product’s use of memory, there are some settings you can change, for example, how much memory to use, whether to dynamically allocate it, and so on. Otherwise, there isn’t a lot you can do in terms of memory tuning. But you may well find yourself in a situation where you want to know what tables and ind...

PostgreSQL SQL Syntax and Use     
Total Hits: 327  |  Today: 0Author: Korry Douglas      Rating:  
Read Reviews | Write Review |  Your Rating: 

The first two chapters explored the basics of the SQL language and looked at the data types supported by PostgreSQL. This chapter covers a variety of topics that should round out your knowledge of PostgreSQL. We’ll start by looking at the rules that you have to follow when choosing names for tables, columns, indexes, and such. Next, you’ll see how to create, destroy, and view PostgreSQL databases. In Chapter 1, "Introduction to PostgreSQL and SQL," you created a few simple tables; in this chapte...

On The Horizon: Improved Data Security In SQL Server 2005     
Total Hits: 431  |  Today: 0Author: Don Kiely      Rating:  
Read Reviews | Write Review |  Your Rating: 

Security and data integrity have always been two of the most fundamental reasons to store data in a relational database. That was true when SQL Server 2000 was released, but the world of computing security has changed in ever nastier ways since then. As a result, Microsoft has been talking a lot about the security issues they have grappled with during the design and development stages of SQL Server™ 2005. Microsoft has performed extensive threat modeling and security analysis to identify the thr...

Using SQL Cache Dependency     
Total Hits: 350  |  Today: 0Author: Wei-Meng Lee      Rating:  
Read Reviews | Write Review |  Your Rating: 

Caching has long been recognized as one of the more effective ways to improve your ASP.NET web applications. However, one particular caching feature that was dearly missing in ASP.NET 1.x was SQL cache dependency. SQL cache dependency is the ability to invalidate a database cache if data in a table is changed. In ASP.NET 2.0, Microsoft has, much to the joy of developers, added the new SQL cache dependency feature. In this article, I will discuss SQL cache dependency in ASP.NET 2.0, as well as di...

Understanding UserDefined Counters     
Total Hits: 90  |  Today: 0Author:      Rating:  
Read Reviews | Write Review |  Your Rating: 

There have been numerous occasions when my peers have raised this requirement. The question asked most of the times is that is there a way to audit or keep track of the process flow happening in my system. I've called an stored procedure and how can I know what is happening behind the scenes.
And in this article we target exactly this strange requirement. And for doing this we will rely on using some of the more frequently used simple tools like isqlw window and PerfMon (Performance Monito...

XML and SQL Server 2000 Integration     
Total Hits: 231  |  Today: 0Author: WROX Press      Rating:  
Read Reviews | Write Review |  Your Rating: 

XML has taken the industry by storm - not only revolutionizing the way that web pages are generated, but also the way that data is exchanged between disparate systems. This session will explain the new XML support added to SQL Server 2000. In particular, you will learn about XML recordsets, URL-based queries, XML views/schemas, and how the addition of XSLT transformations can greatly simplify the delivery of XML data to disparate targets....

XML Storage in SQL Server: Strategies and Fallout     
Total Hits: 290  |  Today: 0Author: Eric McMullen      Rating:  
Read Reviews | Write Review |  Your Rating: 

Native XML support is one of the most powerful features included with SQL Server 2005. Read these best practices to make sure you don't overuse it....

Store and Retrieve XML-based Business Objects with SQL Server and .NET (Part II)     
Total Hits: 312  |  Today: 0Author: Evangelos Petroutsos      Rating:  
Read Reviews | Write Review |  Your Rating: 

Improve performance and gain convenience by using custom business objects serialized to and from XML rather than forcing your presentation-tier developers to work directly with DataSets....

Store and Retrieve XML-based Business Objects with SQL Server and .NET     
Total Hits: 269  |  Today: 0Author: Evangelos Petroutsos      Rating:  
Read Reviews | Write Review |  Your Rating: 

Combine SQL Server's XML support and .NET XML serialization to simplify your front-end code by moving custom objects rather than DataSets between application layers and into and out of SQL Server....

SQL - Articles / Scripts / Tips     
Total Hits: 697  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: offers a large repository of SQL Server articles from throughout the web....

Disk Space Alert Script      
Total Hits: 889  |  Today: 0Author: Harry Parkinson      Rating:  
Read Reviews | Write Review |  Your Rating: 

Monitor the free disk space on your SQL Server and send an alert via email or net send if the available space on any of the drives SQL Server resides on is lower than the specified limit. The script could also be scheduled as a job to provide 24/7 monitoring. Supports SQL Server 7 or 2000....

Append File Script     
Total Hits: 716  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This simple script from Ramunas Balukonis is useful when you need to log in to a file from SQL server. The script opens a file and adds user-specified information to that file....

Total Hits: 344  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Use this script to find tables, views, stored procedures that directly reference a column in the SELECT statement or in a join. This script will also return stored procedure and view names that have SELECT * in them when the specified column exists in the table referenced by that SELECT statement.

Disclaimer - Privacy
© 2002-2014