Question: Hello we have an SQL server application running over a low bandwith connection.
We use ADO.NET.

I was wondering if anybody has any tips on minimizing traffic over the channel.
Im looking for answers on ADO.NET/SQL-Server specific tips that make it more efficient.
Not obvious answers like "dont fetch many records". 

En example for MySql would be "enable comptression=true" in the connection string.
I'm cannot find anything on transport layer compression in SQL server.

Do any of you people have experience with this ?
Are there important do's and dont's that we must know ? 

Thanks in advance..

Answer: 
When deleting:

```
BEGIN TRANSACTION

   DELETE FROM table1 
   OUTPUT deleted.*
   WHERE property1 = 99 

ROLLBACK TRANSACTION

```

When updating/inserting:

```
BEGIN TRANSACTION

   UPDATE table1
   SET table1.property1 = 99
   OUTPUT inserted.*

ROLLBACK TRANSACTION

```
When I want to see what will be deleted, I just change the "delete" statement to a "select \*". I like this better than using a transaction because I don't have to worry about locking.