SQL Server 2000: Passing a List with XML

SQL Server 2000 is an old database platform now, but it is still fairly widely used. That’s why it’s good to know how to pass a list of parameters to a stored procedure on the SQL Server 2000 database platform. Likewise, the code is forwards compatible and will work with more modern versions of SQL Server such as 2008.

Have a look here if you are looking for a working example of passing XML to a stored procedure using SQL Server 2008. Continue reading “SQL Server 2000: Passing a List with XML”

T-SQL Find Highly Populated Tables in a Database

When you are working with an unfamiliar database, such as a third-party SQL Server database, you want to find out which tables actually store the important data. If there is no clean database diagram, then the best option is to write a T-SQL query in SQL Server Management Studio (SSMS).

If you are interested in this topic, then I’d suggest also reading my article on batch searching your SQL Server database to find out in which tables the information is being stored.

Continue reading “T-SQL Find Highly Populated Tables in a Database”