Good Question. These type of questions will help all of us bursh up our knowledge every day. Thank you again!!!

I got it wrong. But am surprised that when a database is set to simple recover model, it will either clear 0 or all vlf. Good to know this.

Gethyn:

Good article, and moreover good discussions. I like the BCB idea of checking database integrity before the backup. I have added Check Database Integrity Task in my daily...

Shawn:

Thanks for the great article.

I loved the answer to go home.

Hugo,

I agree with your points. I did select wrong answer but it is a good learning experience and i did not know that order by in UNION would make a...

Happy Holidays to you all!! Good question because if we have not read the email notification we would not have known this answer. I am a fan of SSC and...

Thank you. Wonderful free toolset. This will make my daily life little easier.

Got it wrong but learnt a lesson from this question. Thank you for sharing. I was not aware of this.

Thank you for the good question.

I agree that this questions been asked many times, but it is good to have this kind of generic question because there will be new members who want to learn...

Good question. Sometimes it is easy to miss small things and this type of questions will help us to keep up with the tips and tricks.

Congratulations!!! It is a great achievement. This is the best site for any DBAs and Developers and overall to all SQL Server Lovers.

Steve,

We used to have almost same methodology but xp_cmdshell was not used since it was not recommend to use at my company. It is definitely a helpful article but...

Hello GSquared:

I am trying to get a list of all the logins (including SQL Logins, and windows logins) and their permisions on each database and the configuration settings ( service...