devxlogo

Tip Bank

Serialize Any .NET Object to a JSON String

The following steps explain how to serialize any .NET object into a JSON string. This tip uses the .NET 3.0 Framework. You’ll find this capability particularly helpful in applications that

Retrieving Table Size in SQL Server

The following SQL query returns the size of each table in the specified database. USE sp_MSforeachtable @command1=’EXEC sp_spaceused ”?”’,@whereand=’or OBJECTPROPERTY(o.id, N”IsSystemTable”) = 1′ Here’s how it works. SQL Server’s system