facebook  linkedin  Twitter  skype  Rss googlePlus

Entries for 2004

Using Stored Procedures in SQL

Dec 28 2004
5008
Stored Procedures – What are they?  Stored procedure is a set of pre-defined Transact-SQL statements, used to perform a specific task. There can be multiple statements in a stored procedure, and all the multiple statements are clubbed in to one database object.   How to create a stored procedure?  Creating a stored procedure is as easy as running the “Create Procedure” statement followed by the SQL script. You can run your Create Procedure statement from the SQL Query Analyzer, or can use the New Procedure me...

Using Http.Sys to receive messages with WSE 2.0

Dec 22 2004
1326
I have completed some of my previous samples by adding Http support without using IIS!! I have used Http.sys instead, that is the kernel mode Http listener introduced with IIS 6.0. Previously it was only included in Windows 2003 Server, but now is also shipped in Windows XP SP2.  And more great news, ... .Net Framework 2.0, includes a set of classes to interact with the Http Api's. Then, it is possible to build a lightweight Http receiver without IIS, by using only .Net assemblies. Http.sys is accessible through a .Net class called HttpL...

Indexes: An Overview and Maintenance for Performance

Dec 22 2004
4824
By Desiree Harris Many people know the importance of creating indexes on SQL Server database tables. Indexes greatly improve the performance of a database. However, while many people create indexes on their SQL Server tables, many people don't maintain them properly to ensure queries run efficiently as possible. I'll begin by giving a quick overview of how SQL Server 2000 stores data and how indexes improve performance. Then, I'll spend quite a bit of time explaining why, when, and how to maintain indexes with DBCC SHOWCONTIG and DBCC INDEXD...

Beginning SQL Server Development

Dec 21 2004
4320
Boarding Point If you are reading this article, I assume that you already have an idea that databases are used to store data. Still, if you are a novice, you will be wondering how to ask the database for data and how to put data in to the database. SQL – Structured Query Language provides you with an opening for talking to your database. Every database has its own unique ways to fetch data to its users. As time passed, there evolved a uniform method of accessing data stored in the database – the SQL. The SQL, evolved as a r...
Displaying 1 of 14 - Next Page

 

Thank you for visiting our site, before you leave, please visit some of the areas or information you may have missed.

Popular Articles