The tran log's not encrypted, but it's not designed to be human-readable. As far as I know, there are no official documents that are publicly released describing the data in...

Apparently (and this is not confirmed), that's...

homebrew01 (12/31/2008)

---

I'm thinking of shrinking Data.mdf in the Primary filegroup on the F drive and most of my big indexes are in a different filegroup called Indexes on...

Is that the select inside one of the udfs?

What about the other udf?

Right click the exec plan, select save...

Perry Whittle (12/31/2008)

---

Gail, i see where Paresh has gone with this. He advises that after truncating the log and breaking the log chain he does a full backup so its...

You can zip it and attach it to your post here.

Please post the code for the UDFs, the schema of the tables involved, and the indexes on them.

Oh, and read these two posts as well.

http://sqlinthewild.co.za/index.php/2008/08/12/views-or-functions/

http://scarydba.wordpress.com/2008/08/15/more-on-table-valued-functions/

Mani (12/31/2008)

---

after immediately 3 weeks got one more problem that i posted today..and we are decided to take experts opinion before directly contacting to Microsoft support as it is not...

That should be the absolute last resort when all else has failed, not the first thing to try. Rebuilding...

Christopher Stobbs (12/31/2008)

---

Gail, stop me if I'm wrong, but could the OP not use an EXISTS in the where clause instead of the join and this would allow the optimizer...

Sorry, I don't understand what you're saying

could you tell me, any other...

"Remain to close"?

Regardless of how long the transaction has been running, you don't...

What patches did you install? (kb numbers if possible)

Have you read through the section on that function and encryption in general in books Online?

Be sure to rebuild all of your indexes afterwards. Shrink badly fragments indexes.