The log size also depends on how often you run log backups.

If I can generate 100MB of logs in a day from my database, if I backup every hour, I...

I'm not sure what calculation you are looking for here. 3 and 4 give either 125% or 75%, how do you calculate 57%?

If you can give the algorithm, we can...

There also won't be a deleted table on an insert. Be sure that's the behavior you are looking for.

Do you mean new data inserted into a table? There isn't really an "append" in SQL Server. You have no ideas where the rows physically live, so there isn't a...

Is this a LIKE search?

I'm not sure you'll get faster than full-text. I suppose you could try some type of hash, but that might not work better. Perhaps breaking into...

If you add a NEWID() column to your select and then order by it, you'll get some pseudo random results.

DMO/SMO is what you need to examine. You can create a handle to a SQL Server object and then perform various actions.

A few resources:

http://msdn.microsoft.com/en-us/library/ms162169.aspx

http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=259

varchar(max) is recommended as text will go away. It doesn't affect your use of SSMS.

you can change the limits, but not sure if they'll get above 65k. Why do you...

The Forever War is great! My son picked it up in March and when I saw it in the Science Fiction Museum in Seattle, I read it as well.

The information is...

it depends.

Sorry, hate to say it, but the distributor takes a load of writing transactions to a file and then sending them to subscribers. Is that a...

I think Grant Fritchey does some of this with VSTS. I know a few people did this awhile back with Agile development, but not sure how many do it now.

you'll need to build scripting into your process to append the date to the name as well as delete the old ones. I'd make these two separate processes, one calling...

I think you'd have to read this out of the registry.

Buy a tool. Most of them are cheap and they do a good job. this isn't a hard task, but it's easy to make mistakes. For $300 or so, you...

You can check sysdepends, but that's not always accurate. You can also search syscomments, but that may or may not work.

Red Gate (I work for them) has a dependency tracker...