chewychewy (6/3/2013)

---

anyone can advise why it need to much space for transaction log? i thought the additional spaces required in the mdf file to store the additional index during time...

There are login triggers in SQL Server. Have a look in Books Online for the details and examples, they're a form of DDL trigger. There are no logoff triggers though.

writearjun53 (6/3/2013)

---

If We don't take a full backup and try to take backup of transaction log file then sql server give a error "Msg 4214, Level 16, State 1, Line...

writearjun53 (6/3/2013)

---

After transaction log backup, If we rerun the DBCC LOGINFO command then we will see how the Status=2 has changed in the file. The last entry is still marked...

Maybe a question designed to see whether the candidate will admit they don't know or try to make up something.

Unfortunately some bad info here.

No need to shrink files. ShrinkFile with the EmptyFile option is for when you're removing a data file from a filegroup that has multiple data files....

DBCC ShrinkFile with the emptyFile option...

It's because of the query form you're using. Please read the blog post I referenced above, it's discussed in there.

If you want a test that will show that putting the...

You mean other than the ones on the blog post I referenced?

No, but neither the index architecture nor...

Never heard of query recasting. What's the context?

pietlinden (6/2/2013)

---

So you'd save the transaction logs from the new stuff (back it up), restore the database, rolling forward to a point in time, and then apply the logs, skipping...

Patience.

We're volunteers, we all have our own jobs, our own problems and we post in our spare time. If you want immediate solutions hire someone, it's not as if...

Key columns, because the ordering of them may be useful to the optimiser and query processor. Very much depends on the rest of the index and the rest of the...

Do you want the testing to impact your production server's...

Index rebuilds aren't expected to make the fragmentation exactly zero. Also could be index is too small to be worth rebuilding.