Tag: sql server

Community

Stored Procedures

The use of stored procedures is the one area where the Command object comes into its own. A stored procedure (or stored query as it’s sometimes called) is a predefined SQL query stored on the database. So why should we create and use a stored procedure instead of just creating a SQL string on the fl

Community

MySQL vs. itself

Companies at loggerheads over MySQL envision future partnership. The dispute between the creator of MySQL and a MySQL vendor has escalated into a legal battle. Still, both say they are so committed to the technology that they are open to reconciliation.

Community

SQLClean™

If database object bloat is the problem, SQLClean is the solution. Your database may have many stored procedures, tables and views that aren't being used anymore but unless you determine which of your objects fall into this category you will be stuck with them forever.

Community

A True .NET Server?

By Michael Otey – The Microsoft Servers Web site (http://www.microsoft.net/servers) lists SQL Server 2000 as one of the company's new .NET Enterprise Servers. How can this be, considering that Microsoft developed and released this latest version of SQL Server before it launched its recent .NET c