Are you sure ? i think it should be around 70-80%.

sqlstart wannabe (11/3/2010)

---

Hi All, During weekend due to some reason the log file has grown to 100+ GB whereas usually it consumes 40+ GB. I want to find what was...

thanks Wayne, it worked for me

@gail, Here i didnt mean "inlcude column" i meant to say , if i have clustered index on one column "Empid" . then how it would consider other non-participated columns.?

I would go with Second option.

Always ? What if i include only one column like empid in...

Its been a long while nobody has responded here because you are asking for homework.

Google the terms you are asking and test/implement on your local system

and then if you face...

Removed

Any DML operation held in the night which disturbed the indexes/statistics.this could be one cause

Duran (10/27/2010)

---

Hello,

I am trying to decide what the best course of action would be in regards to testing the performance of SQL in a multi instance cluster in test in...

See this http://geekswithblogs.net/johnsPerfBlog/archive/2008/04/16/ntext-vs-nvarcharmax-in-sql-2005.aspx

Steve Jones - SSC Editor (10/25/2010)

---

make sure you have it on another server. Because your server will choose to fail right between the deletion and the next backup at some...

Seems like interview question ?:-D

We should also take Tape drive/Disk space under consideration where we are keeping backup file.

Like, what frequency of the backup should be ? daily/weekly etc ?

and for...

This will not help you in space reclaim and Shrinking will not...