All databases, servers, and database objects in SQL Server (such as tables, constraints, stored procedures, views, columns, and data types) must have unique names, or identifiers. They are assigned when an object is created, and used thereafter to identify the object. The identifier for the object m
Other News
Getting a Handle on Indexes
(Steve Callan) So much has been written about indexes that you practically need an index to keep track of things. Performance is the number one reason why indexes are needed. However, there are situations where indexes are not needed, so how do you know when and where to index? To index or not to in
XForms tip: Reacting to the refreshing of the form
(Tyler Anderson) As data changes in your XForms form it can be essential to know right away and do something with the new data, especially when your XForms get more advanced. This tip shows you how to hook such events right into JavaScript methods, thus allowing you to then use the data in many diff
The .Net Developer And SQL Server: Working On Locks
(George P. Alexander Jr.) We’ve been looking at what we needed to know about the finer details of SQL Server Locks so far. After getting our basics right over here, we continued later by taking a look at the different types of Locks that SQL Server uses to manage data consistency. Assuming your pret
Multiple-Valued Parameters
(Peter DeBetta) So I was doing some research on which is the best way to pass multiple-valued parameters into a stored procedure or user-defined function when I found some interesting results. I had always used a string-based user-defined function to parse a delimited list of values and I knew I cou
Debugging sleeping connections with MySQL
(Peter Zaitsev) Have you ever seen connection in the SHOW PROCESSLIST output which is in “Sleep” state for a long time and you have no idea why this would happen?
Special: MySpace – Lessons learned about SQL Server growth, capacity management and much more.
Pro-Center Video Programming for IT Professionals
Oracle indexes: Adding database performance
(Alf Pedersen) Oracle indexes : Proper database indexing is a crucial factor for the database performance. Most Oracle databases have hundreds or even thousands of indexes. This large number of indexes and their complexity make index tuning and monitoring a difficult task for the DBA.
PHP: Export Database Schema as XML
Sometimes it can be useful to have a dump of the current database schema. The script below reads the schema from a MySQL database and outputs XML that describes the schema.
The Essence of Microsoft’s .NET Framework
(Saripalli Koti Reddy) Microsoft .NET Framework [.NetFx] is one of the most important technological platform to any professional associated with Microsoft technologies. In the vein of any other upcoming technology, .NET Framework is undergoing rapid changes and enhancements to empower its developers