Couple points...

The ldf is not in the filegroup. Log files are not part of data filegroups.

The primary file (the mdf, file 1) cannot be emptied, there will always be data...

pradeep.mohan (4/2/2013)

---

One of my query (simple update query) with clustered index utilizing 98%. And then i added non-clustered index on the same table then its utilizing 25% [non-clustered Index] and...

Compression algorithms aren't really something you want to write in T-SQL, wrong tool for the job. Have a look at the CLR, there may be some built in functions in...

I already answered that, in the first reply.

Not sure if that was a question with all the !!! after it, but...

Use the smallest data types for the data. If something will be 20 characters, use varchar(20). If...

Without more info, no idea.

Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

The only compression SQL Server has is table/object compression (look up ALTER INDEX) and backup compression (BACKUP DATABASE ... WITH COMPRESSION)

Could you explain more what you're trying to do here?

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

The column that the stats are on is read, the data distribution calculated, the buckets for the histogram selected and populated, the new statistic object written to the database.

Again, what...

No, but if the string will never exceed 200 characters, why consider a varchar(2000)? Max 200 characters = varchar(200)

In what sense? What problem are you trying to solve here?

The point of copying the files is not for a backup, that's what regular, scheduled database backups are for. The file copies are just so that you have files to...

The universe implodes. Please don't try it.

Probably because the active portion of the log is at the end of the file. TRy again later, additonal operations and log backups will have moved the active portion of...

It's not required. Leave it off and the table or index gets created in the default filegroup. That's Primary by default, but can be changed