Propagating transactions across a process or network boundary is not a trivial task.
For most applications, creating data contracts for the parameters or return values is all that is necessary. However, there are times when you must have complete control over the message.
For the WCF serializer to marshal a complex type, you must define a data contract for it. To do this, start by applying the DataContractAttribute attribute to the complex type definition that you want to pass in a message. Apply the DataMemberAttribute attribute to each field (either a data member or a property) that is to be serialized. All other data fields on the class are ignored.
Duplicate Rows in a table can be very irritating and cause for many headaches. So how can you identify duplicate rows in a table? SQL Server provides no visual tool or a built in function to show you the duplicate rows in a table, so you need to write your own query to get the duplicate rows.
If you are working with SQL Server and looking for a way to get the row count of all tables in your database, you can do that using this SQL Query.
This Query will display a list of all Tables in your database and a count of the number of Rows the table has.
If you need to trace all the connections from Applications and other Clients to your SQL Database you can do so with the following queries.
Working with SQL Server can be quite interesting. It’s a quite powerful tool and you can really be creative with what you can do with those SQL Queries.
FileStream allows you to store unstructured data (LOB) in the file system instead of the database.
SQL Server 2008 introduces many enhancements to Transact-SQL; Here is a list of some of those enhancements and a brief description of those enhancements.
Team Foundation Error:
The cache file C:\\Documents and Settings\\username\\Local Settings\\Application Data\\Microsoft\\Team Foundation\\3.0\\Cache\\VersionControl.config is not valid and cannot be loaded.